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="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]
</tbody>[/TABLE]
I'd be sincerely grateful if someone would be able to assist me please
Thank You
Whilst if No "P" appears it will pick the highest score from either A4 or A5 to put through to the next round
[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]
</tbody>[/TABLE]
I'd be sincerely grateful if someone would be able to assist me please
Thank You