adding up number of repeated names
2003.
"ShaneDevenshire" wrote:
Hi,
What version of Excel are you using? This is a piece of cake in 2007.
--
Thanks,
Shane Devenshire
"h20polo" wrote:
I have a compiled list of all the guests that have attended different events
that we have held in the last couple of years. We are trying to figure out
the loyalty of our guests; identifying those that have attended 2 or more
events. The guest names are in cells A3:A988. How do I come up with a formula
so that the output is the name of anyone who has attended more than one event
(meaning their name appears more than once in column A) and the number of
times they've attended an event, which is updated as more events/names are
added to the list?
Thanks so much.
|