Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unique order number according to criteria
I have the following slate numbers in a column but they do not run in this
numerical order. 01_01 01_02 02_01 02_02 02_03 03_01 04_01 i would like to get an "order" number for each slate as they are above. pls note that a slate number may not be unique and will be differentiated by a set name in another colum. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unique order number according to criteria
I have tried concatenating the information into a new colunm
=CONCATENATE(MID(U59,4,2),RIGHT(U59,2)) and then using a simple RANK =RANK(V59,V59:V64,0) but it doesn't work, i get a NA! error. any ideas? "ellebelle" wrote: I have the following slate numbers in a column but they do not run in this numerical order. 01_01 01_02 02_01 02_02 02_03 03_01 04_01 i would like to get an "order" number for each slate as they are above. pls note that a slate number may not be unique and will be differentiated by a set name in another colum. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
how do I order a cel to be in red color if number is negative | Excel Discussion (Misc queries) | |||
unique alpha's in order | Excel Worksheet Functions | |||
Unique Number | Excel Discussion (Misc queries) | |||
Count number of Unique values | Excel Worksheet Functions |