Compare Multiple Numeric Values
Hey everyone...
I was wondering what the easiest way would be to compare 3 nmueric
values, rank them, and return 3 "text" results. Here is my issue:
I have 3 cells, A1, A2 and A3, that look at numerical values in cells
B1, B2 and B3. What I need to do is have the rankings, 1st, 2nd and
3rd appear in the cells in the A column (respectively), based on the
"position" of the numeric values in the B column. So in short...
A B
1st 10
2nd 9
3rd 8
or...
A B
2nd 9
1st 10
3rd 8
The numbers in column B will change constantly, so I need column A to
adjust automatically.
Thanks to everyone for any help on this!!
|