Frequency questio

[Guest]

I have a column of data and i would like to know what number occur the most
frequently. I dont know how to accomplish this though...could anyone please
help me? Thank you if you can!

 

[Bob Phillips]

=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng,rng),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Hi!

Would this help?

=MODE(your_column)

 

[Guest]

where do i insert the formula

=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng,rng),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

where would I put that formula?

Hi!

Would this help?

=MODE(your_column)

 

[Guest]

Hi again meegan,

You may enter the formula anywhere w/in the spreadsheet except the column
containing the data.

the your_column previously mentioned in the formula means you have to select
the range containing the data

Hope this helps!

 

[Guest]

what do i put in for the ranges...its in column C rows 1-57

 

[Domenic]

Bob's formula...

=INDEX(C1:C57,MATCH(MAX(COUNTIF(C1:C57,C1:C57)),COUNTIF(C1:C57,C1:C57),0)
)

....confirmed with CONTROL+SHIFT+ENTER.

Raymund's formula...

=MODE(C1:C57)

....confirmed with just ENTER.

Note that MODE will return #N/A when no number occurs more than once.
Also, what if there's more than one number occurring most often?

 

[Guest]

Hi!

For multimodal data, we can use the FREQUENCY function instead. As per
example if data is in C1:C57, we can select the output range as D157 then
enter the ff as an array formula (using CTRL+SHIFT+ENTER):

=FREQUENCY(C1:C57,C1:C57)

From there we can determine the number of occurences for each value.

Hope this helps!