# cycles

1. ### Grouping by periods - Specific Scenario - Formula/Workaround

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...
2. ### A loop counter

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.
3. ### Countblank and If statements

=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...
4. ### Looping within a loop

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...
5. ### going to next i on certain condition

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...
6. ### Value interpolation trough multiple ranges

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...
7. ### combining multiple formulas into one if statement

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...
8. ### Working with dates and cycles

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back