ExcelBanter - Frequency

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Frequency (https://www.excelbanter.com/excel-programming/309098-frequency.html)

Materialised[Work]

Frequency

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[_94_]

Frequency

use mode. For example mode(A1:A10)

- Manges

--
Message posted from http://www.ExcelForum.com

Jerry W. Lewis

Frequency

Use the worksheet function MODE()

Jerry

Materialised[Work] wrote:

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

All times are GMT +1. The time now is 09:52 AM.