I want to display what number appears in the same row the most with the
number 1.
So this example, would be 2 as it appears with 1 in the same row 3 times.

4 1 3 2
2 1
4 3 2
1
2 3 4 1

Is each number in its own cell or are the numbers in one cell?

"rossmolden" wrote:

I want to display what number appears in the same row the most with the
number 1.
So this example, would be 2 as it appears with 1 in the same row 3 times.

4 1 3 2
2 1
4 3 2
1
2 3 4 1

See your other post

Hi,

I share you your frustration and I think you should have said other postS
because there are 4 more in 'worksheet functions' making 6 that I've seen.

Unfortunately mode alone won't work because of the need to find the most
common number where there is a 1 in the cell or row.

Mike

"CurlyDave" wrote:

See your other post