loop a formula

  1. A

    Best approach to creating a formula(?) to loop through monthly data, if all employees have different start dates

    Hello, I'm currently working on a project with employee data and need to create a table that displays each employee's score for 5 different KPIs during each month of their employment. I have a huge table with all the relevant data and was trying to create a pivot table or write a formula that...
  2. deadlyjack

    Looping through A3-A13 with monthly numbers (Formulas only)

    Hey all Excel warriors, I'm currently designing a totally new workbook at work which involves every single item within our warehouse, combined with a forecast of the monthly marketing. I got an idea at work today and started working on a concept that I found logical and might actually work 🤔 Now...
  3. G

    Combination of data based on loop

    Hello, I have searched the boards for what seems like hours and I can not find anything to help me. I need to group 3 columns of data. The first 2 columns (group number and store number) must stay paired (they are a required combination) but I need to create the 3rd column to loop through a...
  4. A

    Repeat Formula until it Returns zero [VBA]

    Hi. Is there a way to paste certain formula in column E until the formula returns a zero value? Column E don't have anything in it. So basically, I want to input a formula in E1, then input same formula in E2... and so forth.. until the formula return a zero value.

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