Try
=AND(COUNTIFS(A:A,A2,B:B,"WW"),SUM(COUNTIFS(A:A,A2,B:B,{"KK","RR"})))
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
Try
=AND(COUNTIFS(A:A,A2,B:B,"WW"),SUM(COUNTIFS(A:A,A2,B:B,{"KK","RR"})))
Hi Bob,
Thanks for the formula... it works excellent.
Bookmarks