Thread: Counting items
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Garry[_3_] Garry[_3_] is offline
external usenet poster
 
Posts: 1
Default Counting items

Hi,

I have a basic understanding of formulas and such, but I need to do
something and I am yet to find a solution. Its probably easy.

Say I have a list of names;
bob
bill
fred
fred
bob
fred
sandra
fred

I want to make a formula that will say 'fred', or the most common name
that appears.