Using rank to select top marks

R

ruthhicks999

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
 
R

Ron Coderre

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
 
Top