How do i give unique number in set of duplicate number?

V

Vilish

15604
15604
15604
15604
15604
16484
16484
16484
16484
16484
16484
19606
19606
19606
19606
19606
23064
23064
23064
23064
23064
23064
23734
23734
23734
23734
23734
23734
23734
I have got this data set and i wanted to give unique number for
ie.15604_1,15604_2 so on ... Can anyone please help me. Vilish
 
J

Jacob Skaria

Suppose you have the data in Col A starting from row 1 ...In B1 enter this
formula and copy that down. Once done copy paste special values to the same
column...

=A1 & "_" & COUNTIF(INDIRECT("A1:A" & ROW()),A1)

If this post helps click Yes
 
V

Vilish

your are a star!!! You have sloved my problems..

Thanks you very much for your help...much appreciated.

Vilish
 

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

unique number 2
Data Lookup Question 1
Vlookup to cope with duplicates 5
Duplicate sorts 4
Count Unique Values in Pivot table 5
find unique records 8
Excel Drag autofill only part of formula 3
Unique Reference Number 9

Top