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.
Last edited by nsd3; 07-02-2009 at 09:49 PM.
Will each Actual column be updated just once a month or will there be multiple entries in a column for the month?
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.
=IF(ISNUMBER(Q3),Q3,(IF(ISNUMBER(O3),O3,(IF(ISNUMBER(M3),M3,(IF(ISNUMBER(K3),K3,(IF(ISNUMBER(I3),I3, (IF(ISNUMBER(G3),G3,(IF(ISNUMBER(E3),E3,"")))))))))))))
Try this,
B3
=LOOKUP(2,1/(($D$2:$IV$2="Actual")*($D$3:$IV$3<>"")),$D$3:$IV$3)
Hope this help,
windknife
Thanks to both of you Lizabeta and windknife. It's solved now. Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks