Posted to microsoft.public.excel.worksheet.functions
|
|
Entering changing months with a cell
Take a look at T.Valko's reply his reply is what I was looking for.
"Bernard Liengme" wrote:
It worked for me!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Loadmaster" wrote in message
...
It didn't work either.
"Bernard Liengme" wrote:
Try
=INDEX(C2:C13,MAX(IF(D1:AH12<"",COLUMN(D1:AH12)-COLUMN(D1)+1)-1))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Loadmaster" wrote in message
...
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?
|