• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 84
  • Last Modified:

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
0
Andreas Hermle
Asked:
Andreas Hermle
  • 2
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please try this...

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

Open in new window

and copy it down.
Numbering_Occurrences_e-mail_ee.xlsx
1
 
Andreas HermleTeam leaderAuthor Commented:
Oh Great Subodh, this seems to be trick. Will do some testing and then let you know. Thank you very much.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Thanks Andreas!
0
 
aikimarkCommented:
Andreas

How long/big is this list of emails?
0
 
Andreas HermleTeam leaderAuthor Commented:
Great job, thank you very much for it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now