LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default What number appears the most?

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

Can anybody help me with this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting the times a number appears Jennifer B[_2_] Excel Discussion (Misc queries) 2 July 17th 08 11:54 PM
find the frequency a number appears with another number within a s greenmachine Excel Worksheet Functions 10 September 11th 07 03:19 AM
Selecting the first time a number appears Jaydubs Excel Discussion (Misc queries) 11 July 18th 06 07:34 AM
same number appears in a random number generator Carmel Excel Worksheet Functions 4 May 28th 06 12:22 AM
The number I type in a cell, e.g. 500, appears at 0.5 - why? Becky Excel Discussion (Misc queries) 4 March 17th 06 12:04 PM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"