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...
Your output table is empty and do not make sense what you want. Can you please fill-up your output table with desired output so that we can understand what you want?
Hi Harun, looks fine to me. The output table is below the input table.
Have uploaded again here