Code:
--------------------
Term 1 Term 2 Term 3 Term 4
Class 1 200.0 98.0
Class 2 111.0 99.0
Class 3 100.0 97.9
Class 4 99.0 97.2

Average 127.5 98.0 No numbers No numbers

Winner Class 4 Class 2 #N/A #N/A
200.0 99.0 0.0 0.0
--------------------



I spoke too soon I think. That formula works for all of them apart from
"Class 1" which returns "Class 4" instead


--
Daminc
------------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=483454