The most occurence of a value in a column

[cpliu]

I have 1 to 5 as values in a column. How can I find the number with the
most occurrence in that column?

Thanks,

cpliu

 

[Frank Kabel]

Hi
=MODE(A1:A100)

 

[Jason Morin]

Try:

=INDEX(A1:A5,MATCH(MAX(COUNTIF(A1:A5,A1:A5)),COUNTIF
(A1:A5,A1:A5),0))

Array-entered, meaning press ctrl/shift/enter.

HTH
Jason
Atlanta, GA

 

[cpliu]

Thank you all for the quick help. It works now.

Best regards,

cpliu