macro or function to check true or false

[excelhelpseeker]

Hi champs,

I have a excel file with 2 columns
col A - Doc no
col B - type

Col A has doc no with type "WW" in col B and "RR" or "KK" in col B.

function or macro needed to check whether the doc no (Col A) has both WW and RRorKK

pls note Col A with WW (mandatory) and RRor KK. find attached samplesample.xlsx

[Bob Phillips]

Try

=AND(COUNTIFS(A:A,A2,B:B,"WW"),SUM(COUNTIFS(A:A,A2,B:B,{"KK","RR"})))

[excelhelpseeker]

Hi Bob,

Thanks for the formula... it works excellent.