Frequency

[Materialised[Work]]

Hi All,

I am looking for a way to calculate which number appears most in a
perticular column. I don't need to know how many times it actually
appears, just which number appears the most.

Does anyone know how I can do this?
Thanks
Mick

 

[mangesh_yadav]

use mode. For example mode(A1:A10)

- Manges

 

[Jerry W. Lewis]

Use the worksheet function MODE()

Jerry