Bet I'm *past* your age!

Nov. '38

--
Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

"Don Guillett" wrote in message
...
Wait till you get to be my age and forget everything.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAGdyer" wrote in message
...
Yes ... forgot that ... didn't I?<bg
--
Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

"Don Guillett" wrote in message
...
=Countif($B$1:$B$100,C1)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAGdyer" wrote in message
...
Probably the easiest way would be to create a "master, unique" list of
all available meals, say in Column C.
Then, with names and choices filling A1 to B100, try this in D1:

=Countif(B1:B100,C1)

And copy down as needed.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
----------------------------------------------------------------------------------------


"Ray" <I ate wrote in message
...
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