Using rank to select top marks
 

I have recently found and started using the RANK function which I have found really useful. I am now in a situation where I need to rank a set of 8 test results and then select the best 4 and then transfer them to another area so that they can be totalled, averaged etc.

Can anyone please advise on the best way of doing this. Thank you.

Ruth

Using rank to select top marks
 

Try something like this:

With
A2:A9 containing the scores
and
D2:D5 contains the series 1 through 4

Then these formulas return the top 4 (largest) scores
E2: =LARGE($A$2:$A$9,D2)
Copy that formula down through E5

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"ruthhicks999" wrote:


I have recently found and started using the RANK function which I have
found really useful. I am now in a situation where I need to rank a
set of 8 test results and then select the best 4 and then transfer them
to another area so that they can be totalled, averaged etc.

Can anyone please advise on the best way of doing this. Thank you.

Ruth




--
ruthhicks999