Forum Discussion

matt0020190's avatar
matt0020190
Brass Contributor
May 03, 2024
Solved

Automatically repeating rows based on repeat factor cell (without VBA)

Hello experts, hope you are all well! I have intermediate skills with excel but this one has stumped me. I cannot use any Macros due to workplace policy so this needs to be done with formulas.   ...
excel
  • djclements's avatar
    djclements
    May 04, 2024

    matt0020190 There are a couple of things with this new layout/structure that I would do differently. Your dates are being entered as Text, which is wreaking havoc with the Duration formula, and the repeated use of VLOOKUP to pull data into the Ongoing Projects worksheet can be simplified with one FILTER formula.

     

    In the attached spreadsheet, I've formatted your Lookup Data as a structured Excel table (Insert > Table), added data validation and conditional formatting to ensure data integrity, and used a different formula to calculate the duration (for more info, see: https://exceljet.net/formulas/get-months-between-dates ).

smunozgonzalez's avatar
smunozgonzalez
Copper Contributor
Jan 08, 2025

Hi, I am creating a budget template and I have certain payments that are recurring for X amount of months, how to repeat each record? The records are in a table (Structured reference). 

 



PS: I am Chilean, my English is very bad!
Thanks!!

Resources