| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate occurance, assigning an ordinal value
Hi, Is there any way to not only count duplicates, i.e.
=COUNTIF(range,C2), but to assign each occurance an ordinal value? So for example, if Model1234 appears twice within "range", not only would "2" result, but that the first occurance of Model1234 would display "1" and the second occurance would display "2". Any thoughts? Thanks, Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurance of largest duplicate number in a single column ran | New Users to Excel | |||
| Ordinal Numbers | Excel Worksheet Functions | |||
| Format cells to display ordinal numbers ex 21st | Excel Worksheet Functions | |||
| display dates with ordinal numbers in excel | Excel Discussion (Misc queries) | |||
| frequency for each occurance | Excel Worksheet Functions | |||
Threaded Mode
