Originally Posted by Claus Busch

Hi Guy,

Am Sun, 3 Jun 2012 02:48:56 +0000 schrieb Guym:

One last thing. Changing "true"
with "false" to return the last value of a year does not return the
correct value. Any hint? Thank you again guys.

the last value of the year is 1 row above the first value of the
following year. If you have continuous years, try this for year 2000:
=INDEX(B:B,MATCH(TRUE,YEAR($A$1:$A$2000)=2001,0)-1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2