Numbering Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Could someone help me with a formula for the following?

I have a list of data which I would like to highlight the duplicates in.
Basically I would like to add a column which would prefix the value by a
number which would increase by each duplicate

AAAA
AAAA
AABA
AABA
AACA
AADA

Would become

1_AAAA
2_AAAA
1_AABA
2_AABA
1_AACA
1_AADA

Etc etc.....Can anyone help?

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates are GOOD: How to find the most duplicated values? 1
Augmenting an integer in a column to reflect duplicates in another 23
How to filter Unique values from Duplicates 6
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
Duplicate Function Help 1
is there a simple formula that will remove all duplicates 3
How to assign unique number to column duplicates? 3
Deleting Duplicates 2

Back
Top