Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
is it possible to do the following without the use of a
macro; There are four columns A,B,C,D I want column E to show the ranking in order of highest to lowest based on the value in column C, but putting its equivalent symbol from column A of the same row in the cell in column E, For example, if cell c11 has the highest value, I want the symbol (they are in letters) from a11 to go in the first cell of the ranking column (column E), If c19 had the second highest value, then its corresponding symbol in a 19 would go to the next cell in column E and so forth throguh the list, so that colume E showed a list of the whole set, ranked by highest value, and shown by symbol. Thanking all in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ranking from multiple columns | Excel Discussion (Misc queries) | |||
Ranking multiple columns by 1000th inch | Excel Worksheet Functions | |||
Ranking based on two columns | Excel Worksheet Functions | |||
Scoring/Ranking 2 Columns of Stock Symbols | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |