View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Working from oldest date

Why not simply:

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

Copied across to B10:B11

:-)

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello,

If I understand you correctly, select A10:B10 and array-enter
=INDEX(B1:B2,1+(A1A2)):INDEX(C1:C2,1+(A1A2))

Then array-enter into A11:B11:
=INDEX(B1:B2,1+(A1<=A2)):INDEX(C1:C2,1+(A1<=A2))

Regards,
Bernd