cycles

  1. J

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

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

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

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

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

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

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

    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. <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top