Thread: Frequency
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default 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