Thread: count text values and return most common occurence
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default count text values and return most common occurence
=COUNTIF(A1:A100,"amber")
=COUNTIF(A1:A100,"red")
=COUNTIF(A1:A100,"green")



"MMcQ" wrote:

I have a column with the values red, amber and green.
I want to count the values and in the calculation field, show the value
which occurs most frequently.
e.g.
amber
amber
red
green
amber

the calcualtion field should return amber
Reply With QuoteReply With Quote