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
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version


  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