This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Currently trying to create the table in the End Product tab of the Excel attached using the Data and Month Table. Also attached is the current workflow.
Simply the data table has the first month in which the car has a certain value and the value of add-ons. The next start month for the same car is when the cost or add-ons has altered (one less add-on/more add-ons available/change of cost of car). In between those months, the car has the same cost and number of add-ons.
What I am trying to do is create a table where for each month I have the cost and the number of add-ons (as in the End Product tab of the excel). Usually I would just use a Multi-Row Formula, however, where there are more than one add on this does not work, as I i can not populate more than one row. Does anyone have any ideas?