Sorting Data

Originally Posted by Pete_UK

You can put this formula in G4:

=SUMPRODUCT(--(MID($A$5:$A$20,2,1)=F4))

then copy into G6, G8 and G11.

You can use this formula in J4:

=COUNTIF($A$5:$A$20,I4)

and copy down into J5:J11.

This formula in L4:

=IF(COUNT(O4:S4)=0,"",INDEX($O$3:$S$3,MATCH(MAX(O4:S4),O4:S4,0)))

copied down to L11 will give you the first subject that is a maximum - I'm just thinking of the best way to get the other subjects.

Hope this helps (for now).

Pete

Thx . Will give you feedback in a day or 2...... Can you post your example spreadsheet