software

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 quot;orderquot; 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.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?
quot;ellebellequot; wrote:

gt; I have the following slate numbers in a column but they do not run in this
gt; numerical order.
gt;
gt; 01_01
gt; 01_02
gt; 02_01
gt; 02_02
gt; 02_03
gt; 03_01
gt; 04_01
gt;
gt; i would like to get an quot;orderquot; number for each slate as they are above.
gt; pls note that a slate number may not be unique and will be differentiated by
gt; a set name in another colum.
gt;