multiple if statement????

[muish]

I have the following formula =IF(P2="","",COUNTIF($P$2:P10000,P2)>1) which matches 2 matching reference numbers.
I now need to add in a match for the reference number once with an R and again with a W. If the reference number occurs with 2 R's or W's or indeed with only 1 occurrence of the reference number the formula should return a false result????

Attached file probably shows better what I mean.TEST1.xls

[oeldere]

See the attached file (green cells).

[muish]

Hi,

I guess excel is the universal language.

This almost work however you'll notice on the uploaded file I've tested another few events and the cells highlighted in green should be blank not true.

Thanks in advance for your help with this greatly appreciated.

TEST1 muish (oeldere).xls