Thread: What number appears the most with a certain number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rossmolden rossmolden is offline
external usenet poster
  
Posts: 5
Default What number appears the most with a certain number
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
Reply With QuoteReply With Quote