Results 1 to 4 of 4

Rank the Alphanumeric characters

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Rank the Alphanumeric characters

    Hi,

    I have alphanumeric characters and I have to rank them. Previously these characters were only digits (Using Rank function) and now some alphabets mixed with them. What is the function to rank Alphanumeric characters? They are like:

    1A2240E01
    210003004U
    216000001U
    499630001
    463630001
    400650001
    400650002
    499990011
    460610001
    474640003
    7A2215003
    7A2110003
    7A0000003
    7A0000002
    7A3300001
    474670002
    474670001
    499990010
    499990014
    310101002
    330101006
    330101008
    340101001
    340101008
    7A1000004
    7A1000003
    7A1000001

    I will appreciate your answer over this!

    Thanks,
    Last edited by centro; 12-03-2012 at 07:16 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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