PDA

View Full Version : Excel Value Ranking



30-06-2000, 12:21 AM
I have a need to choose the 4th lowest value in a column of Values, and then record the relative position. Example, if Column A:R1-R20 contains numbers 1 thru 20, and Column B contains various $Values, the fourth lowest value may occur in Row 6 of the range, 6 is the answer I seek.

Would appreciate your help.