If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
In the attached file I'd like to have a formula on cell B3 that would pick the number from the latest entry on "Actual" columns (column K, column M....). This should update the cell each month data is entered in respective month column.
This would work if there are seven or less Actual columns you are looking at. If there is a full year you need to check, maybe someone could tweak this or come up with another solution.
Linear Mode
