Quote:
Originally Posted by Claus Busch
Hi Guy,
Am Sat, 2 Jun 2012 22:20:08 +0200 schrieb Claus Busch:
=INDEX(B:B,MATCH(TRUE,YEAR($A$1:$A$2000)=2000,0))
this is an array formula to enter with
CTRL+Shift+Enter
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Thank you Claus. It works. That's great. 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.