I am trying to add an index or grouping every time a cell is not blank. In the image below I have a multi row formula that adds a month to the Minimum new date value every time the running total exceeds 18k. Ideally I need to add month everytime so the NextMonth column would be 10-27-2022 at the first 18k and then 11-27-2022 at the second 18k. I could not figure out how to do that so I thought maybe I could add an index every time NextMonth is not empty. Anyone have any ideas??
MultiRow
Included sample data with desired output. Basically in the output tab, every time the running total is 18k or more, add 1 month to the Minimum date. So in this data set, the next month would range from 9/27/2022 - 12/27/2022
Solved! Go to Solution.
@oneillp111 Can you provide some sample data and expected output
I added a sample set with output tab
@binuacs thanks for this but this would only chnage the date to 10/27. I need to increment everything the running total hit 18k. So it would go all the way to 12/27/2022.
Solved my issue by adding a Record ID and Tile on Unique values, utilizing the Tile Sequence number as the months to add to Minimum ship date.
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |