I can see that 2000 was the best year, and that membership has been
declining each year since. I can see that the smallest decrease came
between 2001 and 2002 (-15), and that the largest decrease came between
2002 and 2003 (-230). Overall, membership has declined by a total of
-479 since 2000. But I'm just not sure which years you want to compare
(obviously not the first and the last).

Fill in the blanks: I want the formula in H1 to take the membership
number from year _____(blank1) and compare it to year _____(blank2).

If it's pertinent, how did you determine which years to compare?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=390227