Finding largest values with exclusions

[Rich2511]

Hello,

I have a spreadsheet which users enter data into. Reports update according to the data that they enter. I am using a formula at the moment to find the largest values. But i need to amend it so that recognises certain criteria.

A	B	C	D	E	F
	subject code	465743	3423	34535	654654
	level	3	2	2	2
	subject type	EBACC - L	EBACC - L	EBACC - L	EBACC - L
	course code	FKS	FKG	FKS	FKF
Gerry		3	5	6	8

<tbody>
</tbody>

The formula I am currently using is =LARGE(IF($C$3:$F$3="EBACC - L",$C5:$F5),1)

Below are the current results. Largest EBACC - L

A	B	C	D	E	F
	highest	second highest	third
Gerry	8	6	5

<tbody>
</tbody>

The formula needs to take into consideration the fact that 2 course codes are the same columns C and E (FKS). It also needs to take into consideration the higher level score in row 3.
So in this instance I would want the results to be

A	B	C	D	E	F
	highest	second highest	third
Gerry	8	5	3

<tbody>
</tbody>

The score of 6 in column E would be ignored because it has the same course code as the score in column C and although the score of 6 is higher than 3, the score in column C is a level 3 course.

Any help would be appreciated.

 

[jbeaucaire]

Crossposted: Finding largest value on mutiple criteria