Hi John,

Am Wed, 6 Jul 2011 13:23:28 -0700 (PDT) schrieb John Sofillas:

This is just a small portion of what this giant spreadsheet needs to
be, so maintaining it is a nightmare. Is there anyway E43 can have a
formula that reads the row range of 46 and returns the last #. And
work so that when the last # gets deleted, it is still returning the
last # in that row/range.

try:
=LOOKUP(9^99,46:46)


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