Thread: Working from oldest date
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Working from oldest date
Hello Biff,

Why not simply:

A10: =INDEX(B1:B2,1+($A1$A2))
A11: =INDEX(B1:B2,1+($A1<=$A2))

Copied across to B10:B11

:-)


....Yeah, that'll work :-)

Regards,
Bernd

Reply With QuoteReply With Quote