vaughn9
Technical User
- Sep 23, 2001
- 183
I have and excel file that will be popupalated with a list of names every week. I need to keep a tally of the names at the end of every day for example
Day 1 Day 2 Day 3
John Paul Fred
Peter John Paul
Sue Patsy Sue
At the end of each day I need to output how much times John's name appears and how much times Paul's name appears.
The count of the name needs to be updated each day as the names come in. I thought of using a cell find macro to find how many times with a combination of =if but I am not sure that will work. Also I need to tally the number of times each person name appears and output that number on the sheet
I know that I could do a count on the names if they appeared in order but the project I am working on does not lend to bringing in the names in sequence (all Johns together)
Does anyone have any idea of a macro I could use to the number of times a name appears, output that number and keep updated as names come in?
Day 1 Day 2 Day 3
John Paul Fred
Peter John Paul
Sue Patsy Sue
At the end of each day I need to output how much times John's name appears and how much times Paul's name appears.
The count of the name needs to be updated each day as the names come in. I thought of using a cell find macro to find how many times with a combination of =if but I am not sure that will work. Also I need to tally the number of times each person name appears and output that number on the sheet
I know that I could do a count on the names if they appeared in order but the project I am working on does not lend to bringing in the names in sequence (all Johns together)
Does anyone have any idea of a macro I could use to the number of times a name appears, output that number and keep updated as names come in?
