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...
Maybe, though I can't think of a formula solution right now. And I prefer not to use formulas that most likely get quite complex when there is an easy PQ solution staring at me :)