Thanks for your advices.
--
Michel Gerday
Belgium


"Tushar Mehta" a écrit :

That's a nice way to use named formulas to create a step chart. :)

A few comments.

Don't use Date as a name since it is a native XL function.

II.2 has an erroneous comment about subtracting 1.

Define subsequent names using already existing names. That makes
maintenance easier and IMO the design more transparent. For example (with
XL in R1C1 mode):

AllDates =OFFSET(Sheet1!R2C1,0,0,COUNTA(Sheet1!C1)-1,1)
AllDatesX =OFFSET(AllDates,1,0,COUNTA(AllDates)-1,1)
FedRate =OFFSET(AllDates,0,1)
FedRateX =OFFSET(FedRate,0,0,COUNT(FedRate)-1,1)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions