Forum Home
Press F1
 
Thread ID: 4795 2000-06-29 12:21:00 Excel Value Ranking Guest (0) Press F1
Post ID Timestamp Content User
5281 2000-06-29 12:21:00 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.
Guest (0)
1