Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
I'm trying to achieve the following without success:
- I have Sheet 1 that as forms are submitted a Names column is filled.
- I have Sheet 2 with a Names and Counter columns
When a new submission occurs, I would like to get that name from Sheet 1 and add it to the Name column in Sheet 2 if it doesn't exist already and set the counter to 1. If the Name already exists in Sheet 2 I don't want a new row with that name but I would like to update the counter of the existing name.
This would be my Sheet 1:
And as an example, if "Steven" is added again in Sheet 1 the "Counter" in Sheet 2 for "Steven" would be updated to "2". The current Sheet 2 for the names above in Sheet 1 should be:
I tried using the VLOOKUP, IFERROR and MATCH functions and combinations of them, but I'm still struggling to make it work as intended.
Thank you for your help and any insight on this! It is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!