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