Find the top ten most frequently used numbers in a range.

Question

Hi All, I have a large data base filled with numbers and am wanting to extract the top ten most frequently used.

At present I have a list of all 150 numbers presently in use and use this formulae =COUNTIFS($D7:GA13,J62) to count the number of repeats for each number. I then copy the list plus the results to a new list and past as values only, then sort the list to obtain my result.

Is there an easier way of doing this?

preagan · Answer

Hello&nbsp;Tappy_Snr,&nbsp;Please refer here:https://exceljet.net/formula/list-most-frequently-occuring-numbers

tappy_snr · Answer

PReagan&nbsp; Many thanks for your valued help, I will give that a try.

Forum Discussion

Find the top ten most frequently used numbers in a range.

2 Replies

Resources