Thread
:
Count certain values
View Single Post
#
8
Posted to microsoft.public.excel.newusers
RagDyeR
external usenet poster
Posts: 3,572
Count certain values
Well ... 2 years probably worth 2 bottles ... I owe ya!
--
Regards,
RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------
"Don Guillett" wrote in message
...
Send the Wild Turkey 101 to me
April 15 (income tax day) 1936
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RAGdyer" wrote in message
...
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
Reply With Quote
RagDyeR
View Public Profile
Find all posts by RagDyeR