Thank you, MODE is definately the right function, however I think I
need to incorporate IF also, but not sure how.
Using the below example, I would want to find out what appears the
most (MODE) with the number 1 in the same row (IF). The answer is (2)
as it appears with 1 in the same row twice. I'm not sure how to put
this all together though!
4 1 3 2
2 1
4 3 2
1
2 3 4 1