View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Using the "IF" function?

Ruff,
I understand that the months will be filled in chronological order.
Hence you want the last month entered.
The formula I am suggesting for A13 is an array formula, i.e. you need
to enter it with Shift+Ctrl+Enter
=INDEX(B1:B12,MAX(ROW(1:12)*--(B1:B12<0)))

HTH
Kostis V