|
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 |
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 |
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 |
| All times are GMT +1. The time now is 01:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com