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.

I have a list of names that needs to repeat into another table based on a cell repeat factor i.e. 3 times, 4 times etc

I attach an example spreadsheet and the desired output I am after.

The original table has names, a date range per name (ie. May to July) and a calculated repeat factor based on this date range. For example May to July is 3 months inclusive. Therefore the number of rows to display in the new table is 3, one row for each relevant month.

Can anyone help me do this with formula please?

Would be most appreciated!

Thanks

Matt

​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. I have a list of names that needs to repeat into another table based on a cell repeat factor i.e. 3 times, 4 times etc I attach an example spreadsheet and the desired output I am after. The original table has names, a date range per name (ie. May to July) and a calculated repeat factor based on this date range. For example May to July is 3 months inclusive. Therefore the number of rows to display in the new table is 3, one row for each relevant month. Can anyone help me do this with formula please? Would be most appreciated! Thanks Matt  Read More

​