RANK

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

I have two spearate arrays: E13:E20 and I13:I20 that
contain numeric values. I want to assign (for each value
in E13:E20, a rank (to be displayed in F13:F20) based on,
say, cell E13's rank in the combined set E13:E20 AND
I13:I20. (and also display a rank in J13:J20 for each cell
in I13 to I20)

Is it possible to do this using the RANK function WITHOUT
copying the contents of I13:I20 and putting them in
E21:E28??

Many Thanks,

Gary.
 
Hi
try the following:
1. Define a name for this non-contingenous range ('insert -
Name - Define). e.g. rang_rng
2. Use the formula
=RANK(E13,rang_rng)
 
Thanks Frank,

Regards,

Gary.

-----Original Message-----
Hi
try the following:
1. Define a name for this non-contingenous range ('insert -
Name - Define). e.g. rang_rng
2. Use the formula
=RANK(E13,rang_rng)

.
Click to expand...
 
Frank Kabel wrote...
try the following:
1. Define a name for this non-contingenous range ('insert -
Name - Define). e.g. rang_rng
2. Use the formula
=RANK(E13,rang_rng)
Click to expand...
...

Defined name isn't necessary. The following in F13 should work.

=RANK(E13,($E$13:$E$20,$I$13:$I$20)
 
Back
Top