Forum Discussion
Solved
Repeat list of items for each month in table
Hi all I am looking to have an automatic repeating list of items that repeats based on the amount of months in a table. If however a month is mentioned in the list of items, the item will only rep...
My best guess would be the TRIMRANGE function is not yet available to you. I'm on the Current Channel for MS365 Business and just got it this month (last week).
Try the same formula but change the rng variable to just A2:R14 and it should work...
Perhaps the attached PQ solution is something for you. I didn't make any effort to make it fancy but it seems to do what you asked for.
Thank you for this. However ideally I need in the way of a formula using LET or FILTER etc
Is this an option please?
