Thread: EXCEL
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default EXCEL

Will all the numbers on each row be unique?

In other words, can you have something like this:

4 1 1
2 2 1 3


--
Biff
Microsoft Excel MVP


"rossmolden" wrote in message
...
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