| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numbering Duplicates
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Numbering Duplicates
in B1, enter:
=COUNTIF($A$1:$A1,A1)&"_"&A1 and copy down HTH -- AP "Edgar Thoemmes" a écrit dans le message de news: ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
| i need to find duplicates! ASAP | Excel Worksheet Functions | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Duplicates | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
Linear Mode
