Results 1 to 3 of 3

Thread: macro or function to check true or false

  1. #1

    macro or function to check true or false



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Try

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

  3. #3
    Hi Bob,

    Thanks for the formula... it works excellent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •