Entering changing months with a cell
Maybe
=OFFSET(INDIRECT(ADDRESS(SUMPRODUCT(MAX((ROW(D2:AH 13)*(D2:AH13<"")))),SUMPRODUCT(MAX((COLUMN(D2:AH1 3)*(D2:AH13<"")))))),0,(SUMPRODUCT(MAX((COLUMN($D $2:$AH$13)*($D$2:$AH$13<""))))*-1)+3,1,1)
It's a bit long winded and I'm sure there must be an easier way but lets
wait and see. Mind out for the line-wrap it's all one line.
Mike
"Loadmaster" wrote:
Cells D1:AJ1 have years 2006:2038. Cells C2:C13 have Jan thru Dec. Cell A4
has the array formula
=LOOKUP(9.999999999999E+307,INDEX(D2:AH13,0,MAX(IF (D2:AH13<"",COLUMN(D2:AH13)-COLUMN(D2)+1))))
,showing the last figure entered in the table. Note: I had to push
Ctrl+Shift+Enter to execute the formula. How do I enter into cell BC16 the
Month corresponding to the last figure entered in D2:AH13 from column C?
|