iterations

  1. L

    Use value in a cell to iterate and fill target Columns

    Hi Every1, I have got myself a little trouble.. The functionality of the code is quite simple but i being a beginner am not able to do it . I have 3 columns Number of iterations Data to be repeated Target block I am trying to fetch the value of each cell in the 1 st column as the counter...
  2. I

    Excel Not Calculation - Iterations

    Hi, I have built a very complicated financial spreadsheet at work that requires MANY circular references. I recently needed to change something and add another circular reference, and now that section of the file is not calculating correctly. When I go to into the "Evaluate Formula" it...
  3. Q

    VBA Array Sum Value Each Iteration

    Hi guys, I'm fairly new to VBA and I'm having a hard time with how Excel handles arrays. I'm generating a random number of integers from 1 to 10, iterating 10 times. I can't seem to figure out how to sum each iteration and place the value in a new array. Here's the code I have so far: Sub...
  4. H

    Get values for latest instance

    I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which gets constantly updated with the latest values. In Sheet2, in column D (starting with cell address D1), I am able to constantly update with the latest value of K1, whenever a change in value takes place in...
  5. R

    Avoiding a 'circular reference' popup window when opening a spreadsheet?

    I have a worksheet with some references that Excel sees as circular. Actually, it is just some conditional if statements that calculate quantities from the front if front information is given, and from the back if back information is given. If I change the options to iterate the calculation, it...
  6. R

    Avoiding Circular references with iteration--getting rid of error box?

    I have a worksheet with some references that Excel sees as circular. Actually, it is just some conditional if statements that calculate quantities from the front if front information is given, and from the back if back information is given. If I change the options to iterate the calculation, it...
  7. R

    Powerful Histogram Concept!

    I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!). Here is the catch...

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
Back
Top