Results 1 to 7 of 7

Formula to sort by numbers

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to sort by numbers

    Hello:

    Please refer to attached file.

    I need to list Unique numbers from Column E in row 1 at I1
    So basically want 10131 at I1,10134 at J1,10137 at K1,10431 at L1, 10437 at M1 and so on..
    Once this is done, i need the ID # listed from Row 3 for particular unique number as shown in attached.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. When I sort the part numbers the formula gets messed up.....is it a glitch?
    By Rlong1818 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-07-2015, 04:40 PM
  2. [SOLVED] How do you sort item numbers targeting only specific numbers?
    By matt323 in forum Excel General
    Replies: 10
    Last Post: 12-29-2013, 01:15 AM
  3. Replies: 1
    Last Post: 12-28-2013, 11:46 PM
  4. [SOLVED] Formula problem, get and sort numbers between two values
    By Michaelice in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-04-2013, 03:36 AM
  5. [SOLVED] How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2012, 11:59 AM
  6. Replies: 7
    Last Post: 07-24-2010, 08:07 PM
  7. formula required to sort numbers as per given in sheet
    By kaustubhghag in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 12-22-2008, 02:01 AM

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