Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Inquiry
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Sep 2019
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Inquiry

    Quote Originally Posted by Peter_SSs View Post
    If we have the same data how is the requirement different?

    What do you mean by "consecutive cells are not yet zero"?

    Perhaps we do need a couple more sets of sample data and the results?

    Sample:

    A1 10
    A2 20
    A3 40
    A4 28
    A5 0
    A6 35
    A7 29
    A8 40
    A9 15
    A10 0

    In this sample it must say "Inspect" because there is a cell with equal OR greater than 35 and its consecutive cell is not a zero value yet.

    However in this sample


    A1 10
    A2 20
    A3 40
    A4 0
    A5 28
    A6 35
    A7 0
    A8 40
    A9 0
    A10 0

    It must say "ok" because after the cell with equal or greater than 35 the nect value is 0 already. Thanks in advance

  2. #12
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Inquiry

    Thanks. What about this one then?

    Inspect

    ABC
    1101010
    2202020
    3404040
    42800
    502828
    6353535
    729022
    8404040
    91500
    10000
    11InspectokInspect

    Spreadsheet Formulas
    CellFormula
    A11=IF(COUNTIFS(A1:A9,">=35",A2:A10,"<35",A2:A10,">0"),"Inspect","ok")


    Excel tables to the web >> Excel Jeanie HTML 4
    Last edited by Peter_SSs; Sep 23rd, 2019 at 02:11 AM.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #13
    New Member
    Join Date
    Sep 2019
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Inquiry

    Quote Originally Posted by Peter_SSs View Post
    Thanks. What about this one then?
    Inspect

    ABC
    1101010
    2202020
    3404040
    42800
    502828
    6353535
    729022
    8404040
    91500
    10000
    11InspectokInspect

    Spreadsheet Formulas
    CellFormula
    A11=IF(COUNTIFS(A1:A9,">=35",A2:A10,"<35",A2:A10,">0"),"Inspect","ok")


    Excel tables to the web >> Excel Jeanie HTML 4
    Thank you very much peter ��
    Last edited by Peter_SSs; Sep 23rd, 2019 at 05:29 AM. Reason: Fixed quote tag

  4. #14
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Inquiry

    Quote Originally Posted by Duwin View Post
    Thank you very much peter
    No problem, glad to help.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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