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
Bookmarks