View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default determine which cell is the max count

Hello guys, pls. help.

Column A
dog
cat
cat
dog
dog

I would like to know which animal in the column A is max. or is min.
the max. is dog.
the min. is cat.

What is the formula to use?