We help IT Professionals succeed at work.

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

167 Views
Last Modified: 2017-11-07
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

Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED 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
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions