+ Reply to Thread
Results 1 to 2 of 2

unique order number according to criteria

  1. #1
    ellebelle
    Guest

    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. #2
    ellebelle
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1