Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i give unique number in set of duplicate number?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i give unique number in set of duplicate number?
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 --------------- Jacob Skaria "Vilish" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i give unique number in set of duplicate number?
your are a star!!! You have sloved my problems..
Thanks you very much for your help...much appreciated. Vilish "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Vilish" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I give text (A,B...) a number value in Excel (A=1, B=2..) | Excel Worksheet Functions | |||
how to give an automatic number | Excel Worksheet Functions | |||
The same IF (SE) formula give me two different number: why??? | Excel Worksheet Functions | |||
Are you able to give a letter a number value | Excel Discussion (Misc queries) | |||
Minutes multiplied by a number to give a number | Excel Discussion (Misc queries) |