Results 1 to 4 of 4

How to sort values in ascending order and to lookup a reference to that sorted value

Threaded View

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Colombo ,Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    3

    Exclamation How to sort values in ascending order and to lookup a reference to that sorted value

    I wanted to arrange series of different times into an ascending order in a one column and then to look up a value which is in the same row in a different column. Pls refer the attachment.
    I used small() function to sort the times to the ascending order and then used vlookup() funtion to lookup the name related to the time. But when there is two equal times it always gave only one lookup value. i tried with few formulas as well but failed at the repetition of same value/time.

    Pls help me to sort out this issue...

    EXEL SORTING FUNTION.png
    Attached Files Attached Files

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