• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

1-2-3

P

Pofski

Member
Hi,

i need some help, because for some reason i am feeling really stupid atm

there are 3 cells (A,B,C)
if a result is good, the cell of that result turns TRUE
if bad it is FALSE.
Each week there is a check, the cells change.
If a cell becomes bad, it has to be checked daily, until it becomes good again.
If it is good 3 times, the check becomes weekly again.

I want to make a column that counts the amount of times that a good result is needed, before the check becomes weekly again.

I realise it is simple(ish), but my mind is at a blank atm.
Could somebody please help me out?

Thank you in advance
 

Attachments

  • 3 strikes.xlsx
    10.2 KB · Views: 8
Hi Pofski,

Correct me if I am wrong, in your file B9:D26 will be input, A9:A26 is max of B:D column.
Where in this file you want a solution to appear?

Regards,
 
Hello Misra,

the solution should appear in E9:E26.
At thiss moment, the numbers that are filled in there are to give a correct representation of what the solution should look like.

Thanks for looking at this.
 
Can you explain why have you put a 1 in E11 and again 3 in E12 than 0 in E15...the logic of those number is not getting clear. In your earlier post you told a 1 should apper only after 3 Good (True is good I suppose).
 
Pofski,

Your problem statement is not clear, please elaborate the requirement using examples that refer to your sheet. Thanks
 
let's take row 11 as the first example
3 measurements ago, the reading was FALSE. Because of this, we would need 3 readings TRUE, before the statement becomes completely true again. We already have 2 time TRUE (C11 and D11), so we need 1 more TRUE (E11 states that we need 1 more)

Row 12
The last measurement was FALSE, so we need 3 TRUE's, before the statement becomes TRUE again. Mind you, not 3 TRUE's in total, but 3 consecutive TRUE's (although there are only 3 columns here, there could be more columns added in the future, but we will always look at the last 3 neasurements)

Row 15, we have all TRUE's, so the total amount of TRUE's needed before the complete statement becomes TRUE, is 0

the numbers that you see in column E, are a representation of how many consecutive you need in that row, before the entire statement becomes TRUE.


I hope this clears it up a bit, and i apologize if I make it confusing.
 
Unfortunately no Narayan.
The company that i work for prefers to not implement vba in their excel sheets.
I realise that this does not make it easier.
 
Hi ,

I think your result in row 16 is wrong. Can you try this ?

=IF(COUNTIF($B9:$D9,TRUE)=3,0,IF(AND(C9,D9),1,IF(D9,2,3)))

in E9 , and see if it is OK ?

Narayan
 
i think you've got it Narayan.
It looks correct, and i did seem to have made a mistake in row 16.

Thanks a lot, you guys really helped me out again.
This is why i love this forum.
 
You must log in or register to reply here.
Back
Top