repeat calculation

  1. M

    Repeat formula in X columns

    Hello, I am trying to repeat a formula across X cells, where X is a variable defined in another cell. For example, in the image below I am investing $100 evenly over 4 years. I want to automate the sheet so that if I change J1 to, say, 5, the sheet will automatically populate the formula over...
  2. E

    VBA to loop code to the next row

    Hey everyone. Very new to coding. I have a spreadsheet that we use to track employee stats each week and we keep a running total of their performance from previous weeks along with their current perfomance on each sheet. Typically we used to just copy the last sheet and then manually add the...
  3. J

    Counting Multiple, Inconsistent Order Lengths as a Singular Order

    I'm currently trying to sum up the total number of items ordered within a single order. Currently, I have tried to individually go through and find the number of repeated order numbers in order to find how many lines of items I need to sum into a singular order number. What I would like to do...
    • jmackey
    • Thread
    • function number order repeat calculation summation
    • Replies: 6
    • Forum: Excel Questions
  4. L

    VBA Code for bulk Goal Seek

    I'm trying (and failing:laugh:) with some VBA code to make a 'Bulk Goal Seek'. My Goal Seek is as follows: Set Cell Range is G2:G1001 Value I want is 12.00% Change Cell Range is B2:B1001 So I want to Goal Seek Cell G and convert it to 12% (or closest match) by changing cell B. The other cells...
  5. S

    Need to calculate number of repeat customers in an alphabetic list.

    I am creating a working template spreadsheet for a small business owner, and she would like to see how many repeat customers she is getting. I have built a table that has the customers names on one column sorted alphabetically. Just curious if I can write a formula that will countif. The way...
  6. W

    VBA: Looping Macro to copy & paste

    I have a very cumbersome Macro set up that I know is unnecessarily long. It takes about 25 minutes to run and I finally have some time to look at making it more concise. Basically all I need the macro to do is enter two values into cells A1 and A2 (these are inputs to a formula) and then have...
  7. S

    Repeat Calculation At Length & Calculate Lowest Value At Length

    <tbody> Repeat Calculation At Length 100 Calculate Lowest Value At Length 100 A B Length Requirement A Length Requirement 10.000 25.000 10.000 35.000 25.000 10.000 17.000 15.000 27.000 15.000 42.000 17.000 15.000 150.000 29.000 30.000 179.000 33.000 30.000 170.000...

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