Hi guys,

Don't know if anyone can help with this, I think it's pretty simple, but can't find an example on Google that's similar enough!

I am looking to find the modal value when certain conditions apply.

I am using two sheets and wish to find the mode of a given production line (out of 3 possible 'lines', B, C & D). I have a list of 'products made' (Column A, Sheet 1), the 'runs' of these products (Column A, Sheet 2), where each product has multiple runs. Finally, the 'line' on which the product was ran (Column C, Sheet 2).

I wish to find the modal line on Sheet 1 for every product, based on the previous runs.

I've tried MODE, MATCH, IF & INDEX statements in a few different ways and think I may be over-complicating things!

Any help/advice would be appreciated, thanks!