Sequentially number occurrences of e-mail addresses using a formula or VBA

Andreas Hermle
Andreas Hermle used Ask the Experts™
on
Dear Experts:

I got a list / datat table with the following make-up ...

data_list_numbering
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Please try this...

In A2
=COUNTIF(B$2:B2,B2)

Open in new window

and copy it down.
Numbering_Occurrences_e-mail_ee.xlsx
Andreas HermleTeam leader

Author

Commented:
Oh Great Subodh, this seems to be trick. Will do some testing and then let you know. Thank you very much.
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Thanks Andreas!
Top Expert 2014

Commented:
Andreas

How long/big is this list of emails?
Andreas HermleTeam leader

Author

Commented:
Great job, thank you very much for it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial