Hunter Childress
Member
I need help. Non-VBA please. Excel Formula only.
I am looking for support in creating one formula that does 3 different things in the range E11:CD25. It needs to pull the previous month down to the next percentage but when it gets to 100% it continues on the same row (yellow cells). In addition, when the other pink cell catch up and achieve 100% shown in AO25, it sums up the cumulative. Sorry for the poor explanation but you will see how it's manually working in my spreadsheet. My spreadsheet is how I want it to work but I only want one formula for the range E11:CD25.
Let me know if you have any questions. Thanks in advance.
I am looking for support in creating one formula that does 3 different things in the range E11:CD25. It needs to pull the previous month down to the next percentage but when it gets to 100% it continues on the same row (yellow cells). In addition, when the other pink cell catch up and achieve 100% shown in AO25, it sums up the cumulative. Sorry for the poor explanation but you will see how it's manually working in my spreadsheet. My spreadsheet is how I want it to work but I only want one formula for the range E11:CD25.
Let me know if you have any questions. Thanks in advance.
Last edited: