Choosing x cells from y cells
Posted by Stan Wilson on June 14, 2001 4:01 AM
I'm sort of desperate: I have 90 marksmen with 15 target scores each(Names in A, scores in Columns B to P with the occasional absence). How do I select the best 12 scores in a row and print them along with names?
Further, how do I select the best 5 marksmen from the lot?
I realise that I should know this but have reached the mental block stage.
I would be grateful for any help that points in the right direction.