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
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(COUNTIF(A2:T2,"YES")>0,"NO","YES")


  3. #3
    Quote Originally Posted by NBVC View Post
    Try:

    =IF(COUNTIF(A2:T2,"YES")>0,"NO","YES")


    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
  •