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