+ Reply to Thread
Results 1 to 4 of 4

macro or function needed for count...

Hybrid View

  1. 01-20-2015, 11:49 AM #1
    excelhelpseeker
    excelhelpseeker is offline
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    macro or function needed for count...

    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 advancesample.xlsx
    Reply With QuoteRegister To Reply
  2. 01-20-2015, 12:10 PM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,034

    Re: macro or function needed for count...

    Put this formula in cell U2 and copy it down the column: =IF(COUNTIF(A2:T2,"Yes")>0,"No","Yes")
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 01-20-2015, 12:14 PM #3
    excelhelpseeker
    excelhelpseeker is offline
    Forum Contributor
    Join Date
    11-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    204

    Re: macro or function needed for count...

    Thanks. Helps me great...
    Reply With QuoteRegister To Reply
  4. 01-20-2015, 12:15 PM #4
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,034

    Re: macro or function needed for count...

    My pleasure.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro for lookup function
    By excelhelpseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2015, 03:12 PM
  2. Function or Macro needed for the task
    By qwerty2work in forum Excel General
    Replies: 1
    Last Post: 06-26-2013, 10:58 AM
  3. [SOLVED] HELP NEEDED: IF ELSE FUNCTION in VB MACRO
    By havenzhiv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2012, 03:22 AM
  4. macro or function needed for sorting data
    By Kezwick in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-19-2011, 09:57 AM
  5. HELP NEEDED FOR IF Function Inside a Macro
    By Sandi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-01-2006, 11:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1