+ Reply to Thread
Results 1 to 6 of 6

Need Basic Formula for Indicating by columns to cell

  1. 02-05-2024, 07:08 AM #1
    maddyrafi1987
    maddyrafi1987 is offline
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Need Basic Formula for Indicating by columns to cell

    If all 9-10 range rows from N5 to W5 indicate 'YES,' then the answer for the F5 cell (Intensify) should also be 'YES.' If only 5-8 rows have 'YES' as the answer, then the G5 cell (Semi-intensify) should be 'YES.' In case there are fewer than 1-5 rows with a 'YES' answer, then the H5 cell (Common minimum) should be 'YES.' If none of the rows from N5 to W5 have a 'YES' answer (All NO means), then the I5 column (Not yet started) should be 'YES,' indicating that not a single column has a 'YES'?*response.

    10 Questions given in N5 to W5 Columns:

    1. All 9-10 Ans. says Yes - F5 (Intensify) Should says YES
    2. 5-8 Ans. comes Yes - G5 (Semi Intensify) Should says YES
    3. 1-5 Ans. comes Yes - H5 (Common Minimum) Should says YES
    4. All 10 ans. says No - I5 (Not yet Started) should says YES

    I need formula for F5, G5, H5, I5 rows...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-05-2024, 07:26 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Need Basic Formula for Indicating by columns to cell

    you could do with countif()

    1
    =IF(COUNTIF($N5:$W5,"yes")>=9,"yes","")
    2
    =IF(AND(COUNTIF($N5:$W5,"yes")>=5,COUNTIF($N5:$W5,"yes")<=8),"yes","")
    3
    =IF(AND(COUNTIF($N5:$W5,"yes")>=1,COUNTIF($N5:$W5,"yes")<=5),"yes","")
    You have 5 twice - In 2 - which column should the 5 e a result in
    4
    =IF(COUNTIF($N5:$W5,"NO")=10,"yes","")

    also if all blank - then will just be blank
    Attached Files Attached Files
    Last edited by etaf; 02-05-2024 at 07:31 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 02-05-2024, 07:53 AM #3
    maddyrafi1987
    maddyrafi1987 is offline
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Need Basic Formula for Indicating by columns to cell

    Please see in G9, H9 cells, the rows says 2 Yes, Why?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-05-2024, 07:57 AM #4
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Need Basic Formula for Indicating by columns to cell

    wrong formula , i was not going to post - Untill you answered the question which column should be 5 in as its in 2 at the moment

    =IF(AND(COUNTIF($N6:$W6,"yes")>=5,COUNTIF($N6:$W6,"yes")<=8),"yes","")
    AND
    =IF(AND(COUNTIF($N6:$W6,"yes")>=1,COUNTIF($N6:$W6,"yes")<=5),"yes","")

    FIVE is in BOTH
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-05-2024, 08:32 AM #5
    maddyrafi1987
    maddyrafi1987 is offline
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Need Basic Formula for Indicating by columns to cell

    5-8 is semi intensify G5 and 1-4 is common minimum H5..

    Pls work and give correct formula for F5, G5, H5, I5
    Reply With QuoteRegister To Reply
  6. 02-05-2024, 08:33 AM #6
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Need Basic Formula for Indicating by columns to cell

    so for H you need
    =IF(AND(COUNTIF($N5:$W5,"yes")>=1,COUNTIF($N5:$W5,"yes")<5),"yes","")
    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. indicating cells included in a formula
    By Millie2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-06-2016, 07:46 AM
  2. Indicating mismatches in 2 columns
    By Nare91 in forum Excel General
    Replies: 3
    Last Post: 06-11-2015, 03:18 AM
  3. Pop Up Box indicating contents in a particular cell
    By miradest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2014, 08:38 AM
  4. Excel 2007 : Formula indicating Expiration dates
    By Chainsaw_019 in forum Excel General
    Replies: 4
    Last Post: 07-12-2011, 02:59 AM
  5. Formula indicating Expired
    By euwest30 in forum Excel General
    Replies: 1
    Last Post: 07-14-2010, 09:51 PM
  6. I need a little help with comparing columns and indicating the mat
    By IFIXPCS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2006, 01:10 PM
  7. I need a little help with comparing columns and indicating the mat
    By IFIXPCS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 12:50 PM

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