how to find find To list the most frequently occurring numbers in a column (i.e. most common, second most common, third most common, etc),
how to find find To list the most frequently occurring numbers in a column (i.e. most common, second most common, third most common, etc),
asking google about:
most frequently occurring numbers in a column
one gets the following, as topmost answer:
https://exceljet.net/formula/most-fr...curring-number
and then as third from the top:
https://exceljet.net/formula/list-mo...curing-numbers
And I think it is the one you are looking for.
Best Regards,
Kaper
To complement the information provided in 'post # 2', but for newer versions of Office, since 2010
Use this formula and drag down to get the first, second, .... most frequently occurring numbers in a column
Formula:Please Login or Register to view this content.
And just in case you want to return remaining counts of 1 --- in order to make those modal this trick from XOR LX applied to the 2nd formula Kaper cited.
Array entered:Formula:Please Login or Register to view this content.
B C D E 4 Data Number count 5 93 93 3 6 92 95 2 7 93 97 2 8 94 92 1 9 95 94 1 10 96 96 1 11 97 98 1 12 98 99 1 13 99 14 93 15 97 16 95
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks