Good Morning,
Goal is to populate a monthly grid based on an increase %, start month, end month, and then the months remaining for different factors.
The start month, end month, and annual factors can all vary.
I have completed the formulas for Months remaining, and # of months remaining for each factor, what I cannot complete is the formula for the end result.
The final piece is then multiplied by a seasonal factor, but that is straight forward.
Thanks for any assistance.
Made a couple of changes, highlighted in orange.
1) Put dates in row 3, then applied the formatting 'mmm' to the cells
2) Inserted a helper column (A), which may be moved and/or hidden for aesthetic purposes, populated using: =SUM(D$8:D8)
Then populated row 8 using the array entered formula*:Formula:
=$C4*INDEX($F5:$Q5,MATCH(MONTH(F7),MONTH($F3:$Q3),0))*INDEX($C9:$C12,MATCH(COUNT($E8:E8),$A9:$A12,1))
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER (BEFORE copying across). You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks