count most frequent value in column

**runnerpaul** · 11-02-2006, 01:25 PM

Is it possible to do a countif to count the number of times the most frequent value appears in a column? If so how?

**Maistrye** · 11-02-2006, 01:33 PM

Originally Posted by runnerpaul

Is it possible to do a countif to count the number of times the most frequent value appears in a column? If so how?

=countif(A1:A100,mode(A1:A100))

Scott

**Carim** · 11-02-2006, 01:33 PM

Hi,

With array formulas, Control Shift Enter instead of Enter

The most frequent value

Please Login or Register  to view this content.

The Count of the most frequent value

Please Login or Register  to view this content.

HTH
Carim

**Carim** · 11-02-2006, 01:37 PM

Hi Scott,

Thanks for this formula I did not know about ...
I like it a lot ...

Cheers
Carim

**runnerpaul** · 11-03-2006, 12:52 PM

Cheers to both of you.

**runnerpaul** · 11-03-2006, 01:02 PM

How can I find what the value of the mode is?

**runnerpaul** · 11-03-2006, 01:03 PM

Pretend I never asked that.