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.

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.