Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare alpha and numeric values within a range | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
multiple numeric values applied to single text | Excel Discussion (Misc queries) | |||
How to compare multiple cell values | Excel Programming |