Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up number of repeated names
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do not allow a number to be repeated on the same column? | Excel Discussion (Misc queries) | |||
using conditional formatting to mark repeated names in list? | Excel Discussion (Misc queries) | |||
max number repeated | Excel Discussion (Misc queries) | |||
how do I number a form for repeated use? | Excel Discussion (Misc queries) | |||
Most repeated number | Excel Worksheet Functions |