Results 1 to 3 of 3

Thread: macro or function needed for count...

  1. #1

    macro or function needed for count...

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

    Hi champs,

    I have data from A to T column.

    the rule is

    1. if i have all cells from A2:T2 as "No" or "N/A", then the result is "Yes" in U2
    2. If any of the cells from A2:T2 is "Yes" then result is "NO"

    Please not that "N/A" entry is dummy. so its a dont care cell.

    please help me with a formula or a macro. i have attached a sample file

    Thanks in advance.sample.xlsx

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016


  3. #3
    Quote Originally Posted by NBVC View Post


    Thanks .. working fine.

Tags for this Thread

Posting Permissions

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