Assigning Unique Numbers To Duplicate Values
I'm trying to find out if there is a way to label each duplicate in a column with a unique sequential number that count each set of duplicates like in the below pic. So, if John was listed 4 times in a column and Abe was listed 7 times, John would be numbered 1-4 and Abe would be numbered 1-7, etc.
Any assistance would be appreciated.
Help Article Resources
Check out the Formula Handbook template!