ranking columns

[Tom Donino]

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.

 

[Tom Ogilvy]

this can be done with large, match and index I believe. Are there any
duplicates in the data in column C. Is column C numeric?


in E1

=INDEX($A$1:$A$100,MATCH(LARGE(C$1:$C$100,ROW()),$C$1:$C$100,0),1)

If there are duplicates, it will take more work.

 

[Bernd Plumhoff]

No matter whether you have numerical values or strings
(but do not mix them) or whether there are duplicates:

Assume that all values start in row 1.

Put into cell M1 (M is a helper column):
=COUNTIF($C:$C,">"&C1)+COUNTIF($C$1:C1,C1)

Put into cell E1:
=INDEX(A:A,MATCH(ROW(),M:M,FALSE))

Now copy E1 and M1 down as far as necessary.

HTH,
Bernd