Hi to all, i would like a formula which counts the delays of 0(zero).i hope is easy!thanks so much!!
Hi to all, i would like a formula which counts the delays of 0(zero).i hope is easy!thanks so much!!
i attached an example here!
Can you explain how you arrive at your sample answers?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i would like to cound delays in cell D2 please!!
what i need is a formula which checks the numbers at C:C and countsthe dalays of 0 zero.
thank you!
Last edited by louis128; 01-12-2019 at 04:47 AM.
is it posssible,to count?
This is not clear. I do not know if you want a series of values... or just one which gives the result to the last row in the column.
In C4, an array formula:
=COUNTIF(INDEX($B$4:B4,MAX(($B$4:B4=0)*MATCH(ROW($B$4:B4),ROW($B$4:B4)))):B4,"<>0")
copied down.
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...
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
is working!! But in order to go down ,it cant track C:C and just write the last result on D4?
Thanks clenn!!!!
here is something similar please! And if i want to count how many times a number(any number) did not apear at D4(D4 is just lets say a counter of any number,except 0)
can D4 get a memory?)
In "D3"Formula:Please Login or Register to view this content.
Ensure press shift+ctrl+enter
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Try this alternative:
=COUNTIF(INDEX(Range,MAX((Range=0)*MATCH(ROW(Range),ROW(Range)))):INDEX(B:B,MAX(IF(Range<>"",ROW(Range),""))),"<>0")
again, an array formula, an also a named Range (CTRL-F3 to view/edit)
Last edited by Glenn Kennedy; 01-12-2019 at 05:31 AM.
yes is grat , but please see the new example!
At this stage we are interesting in C3 and F4 cells
thanksClenn!
i think is difficult cause C3 has no memory ,yes?
actually ,i need a formula which counts how many times a number did not apeared in C3. so in this way it would count 0s , yes?
Another array formula:
=COUNTIF(INDEX(Range,MAX((Range<>0)*MATCH(ROW(Range),ROW(Range)))):INDEX(C:C,MAX(IF(Range<>"",ROW(Range),""))),0)
super ! but my clenn i would like F4 to look only on E4(counter) just the counter and check how many times a number diid not apeared and counts like the formula youmade!
Last edited by louis128; 01-12-2019 at 06:16 AM.
or maybe can we create for the counter E4 a range? so is like first step is the range B:B ,then the counter E4, then to create a 'new range' for the counter and F4 to look on 'new range'?
Last edited by louis128; 01-12-2019 at 06:18 AM.
can we create an range of counter? i mean whick shows the counting results of E4 , please!
No. I do not understand what you want.
dear clenn ,I want in Q4 amodification of the formula like you made, to count a number did not apeared!, so it means alternative it counting how many zero apeared, yes? i attached you the exact example, sorry if i was not clear before!
I want in Q4 amodification of the formula like you made, to count how many times a number(any number except 0) did not apeared in P2.
I do not understand your English. Please show me your expected results for two or three example sets of data.
thanks! i will try to explain better. so atthe last work book i attached, i have a formula which counts the event 1 2 in O:O, so if 1 2 comes counts 1, if 1 2 1 2 1 2 comes counts 3 but if any other event comes like 222,or 112222 counts 0 zero.what i need is a 'history of counts.
please see attachement example 2. thanks!
i attached another example of 'history'.
please have a look to that example!!thanks
is like
extract the results of the array formula(or counter)!!!
Your examples do not help. Post one file, not 3. Remove EVERYTHING except the relevant data. Your sheets are full of rows of numbers and I do not have the patience, the time, or the enthusiasm to figure it all out. You MUST tell me what results you expect to see. There is no point in repeating the same words, as they do not make sense to me.
please check that one
and last you put the extract results where was like i show here!thanks alot
Mr. Louis, as per your last so many example, all necessary result's, solved out. This is a new one, kindly closed this thread, & post new one.
ok.thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks