Displaying Last Number that is in a cell

[instereo911 via OfficeKB.com]

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!

 

[L. Howard Kittle]

Try =LOOKUP(99^99,C:C)

Where C:C is the column you are entering the numbers, 3 in your example.

HTH
Regards,
Howard

 

[T. Valko]

=LOOKUP(100^10,B:B)

Will return the last numeric value entered in column B.

Biff

 

[Bob Phillips]

=LOOKUP(2,1/(D<>""),D)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[instereo911 via OfficeKB.com]

Worked like a charm. Thank you so much Howard

Try =LOOKUP(99^99,C:C)

Where C:C is the column you are entering the numbers, 3 in your example.

HTH
Regards,
Howard

I saw that someone replied but it didn't work.

[quoted text clipped - 15 lines]

Thank you again for all your help guys!

 

[L. Howard Kittle]

You are welcome, and Bob Phillips offers an interesting solution.

Worked like a charm. Thank you so much Howard

Try =LOOKUP(99^99,C:C)

Where C:C is the column you are entering the numbers, 3 in your example.

HTH
Regards,
Howard

I saw that someone replied but it didn't work.

[quoted text clipped - 15 lines]

Thank you again for all your help guys!