| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign unique number to column duplicates?
Hi All,
I need to assign a unique number to a set of duplicates all in one column in Excel 2007. so columnA will has about 9000 numbers, some of them unique, and others are duplicates of 2-4 approx. I used to conditional formatting to show which are duplicates, but need to be able to assign a unique number to each set duplicates, that will be in sequential order... e.g. ColumnA ColumnB(unique ID) 01233 0001 01233 0001 01234 - 01255 0002 01255 0002 etc.... Any ideas please? I don't know how to do programming, just formulas in excel. Thanks Heather |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign unique auto-generated number | Excel Discussion (Misc queries) | |||
| How do I assign a unique ID number to an invoice sheet I created? | Excel Worksheet Functions | |||
| Showing a unique random number w/o duplicates | Excel Worksheet Functions | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
| How do I assign a unique tracking number in excel? | Excel Worksheet Functions | |||
Threaded Mode
