• 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.

Need Some Help on Frequency Formula/countif every nth column

L

LaurenL

New Member
I have attached an example; I have a descriptive explanation on what/where I am stuck at in the document.

Thanks for any help~always appreciative!
 

Attachments

Hi lauen

It's a bit difficult to understand your problem

Try:

E2: =IF(AND(B2<$K$1,D2<$K$1),1,0)
G2: =IF(F2<$K$1,1,0)
I2: =IF(H2<$K$1,1,0)

copy all down

If that isn't correct, can you explain what your trying to achieve?
 
Hi ,

It is not clear why cell I2 = 2 , while cell G3 = 0.

If I2 is 2 , it means we are looking at all the cells from B2 through H2 , excluding cells E2 and G2.

If G3 = 0 , it means we are looking at only cell F3 , and not counting the values in B3 and D3.

Narayan
 
Hui,

I probably didn't explain myself well; I need to determine in the columns named "frequency" how often in the previous columns the cell is at or below 93.99 and it is a rolling count. However, as soon as it is at or above 93.99 then the counting stops and would start again if/when frequency was at or below 93.99. ( Looking for a pattern) entered your formulas in and reattached

Thank you for any help!
 

Attachments

NARAYANK991 said:
Hi ,

It is not clear why cell I2 = 2 , while cell G3 = 0.

If I2 is 2 , it means we are looking at all the cells from B2 through H2 , excluding cells E2 and G2.

If G3 = 0 , it means we are looking at only cell F3 , and not counting the values in B3 and D3.

Narayan[/quot

Yes- that is correct: I need to determine a pattern every other column and report that pattern in the column: Frequency. Any suggestions?
Click to expand...
 
NARAYANK991 said:
Hi ,

It is not clear why cell I2 = 2 , while cell G3 = 0.

If I2 is 2 , it means we are looking at all the cells from B2 through H2 , excluding cells E2 and G2.

If G3 = 0 , it means we are looking at only cell F3 , and not counting the values in B3 and D3.

Narayan
Click to expand...
 
Do you have any suggestions to help: I need to determine the frequency of 2 or more when cells B,D,F, etc are less than/= to 93.99 (continuous count). However, the moment those cells are above- the frequency stops counting and would only start again if/when the every other cell drops below the threshold of 93.99
 
Hi ,

How many more columns will this span ?

Will what ever solution is proposed need to be extended over several more columns , or will the columns E , G and I be the only ones ?

Narayan
 
I need it to run for 26 columns in all (this is a performance tracker) built for every 2 weeks. The purpose of the formula I am seeking assistance is to be able to see pattern in performance.
Thank you for all your assistance.
 
Hi ,

Why do you have the frequency formula columns in between your data columns ?

If you can separate the data from the formulae , the formula can become that much simpler.

Secondly , why is the formula in column E referring to two columns of data which are in effect 4 weeks ? Isn't the column C also supposed to have a formula in it ?

Narayan
 
NARAYANK991 said:
Hi ,

Why do you have the frequency formula columns in between your data columns ?

If you can separate the data from the formulae , the formula can become that much simpler.

Secondly , why is the formula in column E referring to two columns of data which are in effect 4 weeks ? Isn't the column C also supposed to have a formula in it ?

Narayan
Click to expand...


Hi, Narayan

First thank you for your help...


Why do you have the frequency formula columns in between your data columns ?
R: The data represents performance indicators that are distributed biweekly; the goal is to keep a history of that data and after each period determine if they are meeting the goal or not. The Frequency column is to indicate how many in the previous consecutive period the standard was met or not.

If you can separate the data from the formulae , the formula can become that much simpler.
R: I am open to any suggestions.

Secondly , why is the formula in column E referring to two columns of data which are in effect 4 weeks ? Isn't the column C also supposed to have a formula in it ?
R: The formula in column E is the first set of data; there is no pattern established yet.

Thank you for all your help~
 
You must log in or register to reply here.
Back
Top