Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany asked on

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 ...

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
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsVBA

Avatar of undefined
Last Comment
Andreas Hermle

8/22/2022 - Mon
Subodh Tiwari (Neeraj)

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 Hermle

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
Subodh Tiwari (Neeraj)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
aikimark

Andreas

How long/big is this list of emails?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Andreas Hermle

ASKER
Great job, thank you very much for it.