Forum Discussion

Copper Contributor

Mar 08, 2020

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

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 =C...

excel

PReagan

Bronze Contributor

Mar 08, 2020

Hello Tappy_Snr,

Please refer here:

https://exceljet.net/formula/list-most-frequently-occuring-numbers

Tappy_Snr

Copper Contributor

Mar 10, 2020

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