Multiple criteria within an IF statement

[muish]

I have the following formula =IF(P2="","",COUNTIF($P$2:P10000,P2)>1) which returns a true or false value return on a column of unique reference numbers, basically I need to identify 2 matching reference numbers but also a further match with the reference number and a W in another column and the second ref number with an R.

Hope this makes sense.

TEST.xls

[tigeravatar]

muish,

Using your provided example workbook, in cell T2 and copied down:

Please Login or Register  to view this content.

Does that work for you?

[muish]

Not exactly, if returns the correct result, however I need the result to only be true if one instance of the unique reference if found with W and 1 with R, if these values were to appear further down I need it to return a false value.
so for example if the values in rows 2&3 appeared again in rows 7&8 I need the result to be false.
So the unique reference along with a w and then r can only appear once after that it is a false value.
Hope this makes sense.
Thanks for your help.