This formula returns the range of the last 12 entries, which you can
hopefully use:

=OFFSET(INDIRECT("D"&SUMPRODUCT(MAX(((D1:D50)<"") *(ROW((D1:D50)))))),-11,,12)


Note: It does not check for blanks. If finds the last entry and
returns the last 12 cells ending in the location of the last entry. If
you need the last actual non-blank entries, let me know.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=378121