Excel Question

  • Thread starter Thread starter rossmolden
  • Start date Start date
R

rossmolden

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
 
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
 
Back
Top