ranking

[Guest]

Here's the formula that I'm using to rank: =rank(c15,$c$15:$p$15,1) and it works great except.....Columns E and G should not be looked at as they contain comparisons (% difference between c&d and c&f).

Does anyone know how to do this?

 

[Aladin Akyurek]

=RANK(C15,(C1515,F15,H1515),1)

Here's the formula that I'm using to rank: =rank(c15,$c$15:$p$15,1) and

it works great except.....Columns E and G should not be looked at as they
contain comparisons (% difference between c&d and c&f).

 

[Frank Kabel]

Hi
one way:
- select the column for which you want to calculate the rank (select
columns C,D, hold down the CTRL key and select the other columns)
- goto 'Insert - Name - Define' and define a name for this list (e.g.
call this selection 'rank_list)
-now use the formula
=RANK(C15,rank_list)

--
Regards
Frank Kabel
Frankfurt, Germany

Here's the formula that I'm using to rank: =rank(c15,$c$15:$p$15,1)

and it works great except.....Columns E and G should not be looked at
as they contain comparisons (% difference between c&d and c&f).