View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ray[_5_] Ray[_5_] is offline
external usenet poster
 
Posts: 11
Default Count certain values

I have a spreadsheet that has column A with names, column B with their
choice of meal.
Example:
A B
John Steak
Bill Chicken
Joe Salmon
May Steak
Jean Chicken
What I want to do is count how many of each dish are required (how many
steaks, chickens to order)
Can someone please show me the formula?
Thanks