cycles

Hi guys, Wonder if any of you have encountered a similar scenario: I've got a table similar to the following one, with a few hundreds of different entities where each of them have its own specific "length". Don't know how exactly explain it but I would like to group the Q by buckets of...

Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.

=IF(ISBLANK(Q22),"FAIL",COUNTif(C27:Q27)"=>"&$Q$22),IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS") I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...

Hi need some help ... Say i have loop as below, but what i want is to run another loop within this loop so that every time the original loop reaches 10 cycles it wold run the second loop, but on the final time the original loop may not run 10 cycles so i would want the second loop to run even...

Hey guys, i have a piece of code that is throwing an error: next i without for at the NextIteration part For i = 2 To lastRow variableInQuestionReal = Range("L" & i) variableInQuestionDecimal = GetDecimal(Range("L" & i), False) If isError(variableInQuestionReal) = true Then GoTo NextIteration...

Hi, I'm struggling with a problem here, with processing some data in excel - I'm out of ideas,please help. so, I have a large amount of data that looks like this: So to explain, i have a lot of cycles of measurements, (Cycle 1, Cycle2 in example picture), and each cycle gives a "y" values...

Hello! i am back playing with a status sheet again. had to start a new plane. i am trying to make it less error prone. in the Next Due Column H Hours =f16+K16 Months =EOMONTH(j16,f16) Cycles =l16+f16 Days =(J16+f16) Years =EOMONTH(J16,F16*12) Ldgs =L16+F16 AC Hours =IF(G131="AC...

Please can someone assist me with some formulas working with dates and yearly cycles. I need formulas for the cells highlighted in green below based on today's date. Excel 2013/2016CDEFG1Today05 March 201823Start DateCycle in yearsCurrent start cycleCurrent end cycleExpiring in401 January...