Quarter final result convert to semi final

[Fraserj]

Hi, i'm doing a football spreadsheet, I need a formula that will recognise P in column A3 to put Manchester into the next round and appear in Column A5
Whilst if No "P" appears it will pick the highest score from either A4 or A5 to put through to the next round
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Manchester[/TD]
[TD]2[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]Liverpool[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barca[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Madrid[/TD]
[TD]4



[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Basically Manchester would be playing Madrid in the next game
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'd be grateful if someone would be able to assist me please

Thank You

 

[wideboydixon]

	A	B	C
Manchester	P
Liverpool
Manchester
Manchester

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A4[/TH]
[TD="align: left"]=IF(B1 > B2, A1, IF(B2 > B1, A2, IF(C1 = "P", A1, A2)))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A5[/TH]
[TD="align: left"]=IF(B1 & C1 > B2 & C2, A1, A2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Take your pick between the two formulas ...

WBD

 

[Fraserj]

Thank you... ended up using the top one

Really Appreciate it