+ Reply to Thread
Results 1 to 6 of 6

Count the continuous positive results.

  1. 01-05-2019, 07:57 AM #1
    Jayprakash
    Jayprakash is offline
    Registered User
    Join Date
    01-05-2019
    Location
    India
    MS-Off Ver
    office 365
    Posts
    3

    Question Count the continuous positive results.

    Hello friends,

    Here is the case I am not able to resolve in excel.
    there is a attendance data of the month like
    date 1 2 3 4 5 6 7 8 9 10 1 1 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
    name
    a p p p p p p p a p p p p p p p p p p p p p p p p p a a a a a p p p p p p p p p p p p p
    b p p p p p p a p p p p p p p p p a p p p p p p p p p p p p p a p p p p p p p p p p p p
    and there is lot of employees likes this.

    the result i want is if someone has worked for continuous 6 days in a month then i want "yes" and if not than "NO".

    i don't want count of how many times in a month just yes if he had worked continuous 6 days at any time in a month.

    kindly help me out with this.

    Thanks in Advance.
    Reply With QuoteRegister To Reply
  2. 01-05-2019, 08:09 AM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,048

    Re: Count the continuous positive results.

    One way, using an array formula:
    =IF(MAX(FREQUENCY(IF(B3:AF3="P",COLUMN(B3:AF3)),IF(B3:AF3="A",COLUMN(B3:AF3))))>=6,"Yes","No")

    Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

    You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

    Don't type the curly brackets yourself - it won't work...
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 01-09-2019, 02:15 AM #3
    Jayprakash
    Jayprakash is offline
    Registered User
    Join Date
    01-05-2019
    Location
    India
    MS-Off Ver
    office 365
    Posts
    3

    Cool Re: Count the continuous positive results.

    Thanks .IT was really helpful.
    you made my day.
    Reply With QuoteRegister To Reply
  4. 01-09-2019, 02:24 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,825

    Re: Count the continuous positive results.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 01-09-2019, 03:37 AM #5
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,048

    Re: Count the continuous positive results.

    You're welcome.


    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
    Reply With QuoteRegister To Reply
  6. 03-07-2019, 08:12 AM #6
    Jayprakash
    Jayprakash is offline
    Registered User
    Join Date
    01-05-2019
    Location
    India
    MS-Off Ver
    office 365
    Posts
    3

    Re: Count the continuous positive results.

    bhai ye try kar tu...tere se bhi achhha hai.....

    try this dude,
    =IF(ISERROR(SEARCH(REPT("P",10),CONCAT(E4:AI4),1)),"NO","YES")

    it is more reliable.
    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. Sum non continuous (positive) cells
    By BenHatton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2016, 01:45 PM
  2. Positive Results
    By lmthomas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  3. [SOLVED] Positive Results
    By lmthomas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. Positive Results
    By [email protected] in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  5. Positive Results
    By lmthomas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Positive Results
    By lmthomas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] Positive Results
    By lmthomas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2005, 10:05 AM

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