=LOOKUP(100^10,B:B)

Will return the last numeric value entered in column B.

Biff

"instereo911 via OfficeKB.com" <u27979@uwe wrote in message
news:6c8798082a557@uwe...
I saw that someone replied but it didn't work.

I have a document that Looks like this:

1 2 3 4 5
a 1/1/07 53
b 1/2/07 64
c 1/3/07 42
d 1/4/07 102
e 1/5/07
f 1/6/07

g (to show D3)

I want G3 to show the last number that was inputted (which in this case
would
be D3). Is there any way of doing this?

Thank you again for all your help guys!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1