Sequentially number occurrences of e-mail addresses using a formula or VBA
Dear Experts:
I got a list / datat table with the following make-up ...
The numbering in Column A (so far manually) should be automated.
The macro or formula is to count the number of occurrences of the e-mail adresses in Column A as depicted in the screenshot above.
- Single e-mail addresses get the number 1
- Multiple occurrences of e-mail addresses get 1 to n numbering depending on the number of occurrences of the respective e-mail address.
I have attached a sample file for your convenience.
Help is very much appreciated. Thank you very much in advance.
Regards, Andreas
Numbering_Occurrences_e-mail_ee.xlsx
I got a list / datat table with the following make-up ...
The numbering in Column A (so far manually) should be automated.
The macro or formula is to count the number of occurrences of the e-mail adresses in Column A as depicted in the screenshot above.
- Single e-mail addresses get the number 1
- Multiple occurrences of e-mail addresses get 1 to n numbering depending on the number of occurrences of the respective e-mail address.
I have attached a sample file for your convenience.
Help is very much appreciated. Thank you very much in advance.
Regards, Andreas
Numbering_Occurrences_e-mail_ee.xlsx
Last Comment
ASKER
Oh Great Subodh, this seems to be trick. Will do some testing and then let you know. Thank you very much.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Andreas
How long/big is this list of emails?
How long/big is this list of emails?
ASKER
Great job, thank you very much for it.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
In A2
Open in new window
and copy it down.Numbering_Occurrences_e-mail_ee.xlsx