Just curious. How can Bob's formula be tweaked to handle a generic
situation where* the last 6 rows in Column A* are always averaged.


+-------------------------------------------------------------------+
|Filename: encdcpt.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3621 |
+-------------------------------------------------------------------+

--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=389720