Last text entry in a column
 

I know I've seen this discussed here, but I haven't been able to find it.

I have a long column of text entries that will continue to grow
indefinitely. I simply want to use the value of the bottom entry in a cell
on another worksheet. There will be many repeats, entries are in no
particular order, and there will always be an entry.

For instance, with the following in column A on Sheet 1, I'd like "Larry" to
appear in cell A1 on Sheet 2.

John
Sam
Joe
Larry

thx

Last text entry in a column
 

=LOOKUP(2,1/(Sheet1!A1:A65535<""),Sheet1!A1:A65535)

"AnotherNewGuy" wrote:

I know I've seen this discussed here, but I haven't been able to find it.

I have a long column of text entries that will continue to grow
indefinitely. I simply want to use the value of the bottom entry in a cell
on another worksheet. There will be many repeats, entries are in no
particular order, and there will always be an entry.

For instance, with the following in column A on Sheet 1, I'd like "Larry" to
appear in cell A1 on Sheet 2.

John
Sam
Joe
Larry

thx

Last text entry in a column
 

=INDIRECT("Sheet1!"&ADDRESS(MATCH("",Sheet1!A:A,-1),1))

"AnotherNewGuy" wrote in message
...
I know I've seen this discussed here, but I haven't been able to find it.

I have a long column of text entries that will continue to grow
indefinitely. I simply want to use the value of the bottom entry in a
cell
on another worksheet. There will be many repeats, entries are in no
particular order, and there will always be an entry.

For instance, with the following in column A on Sheet 1, I'd like "Larry"
to
appear in cell A1 on Sheet 2.

John
Sam
Joe
Larry

thx

Last text entry in a column
 

Thank you, Sean.

"Sean Timmons" wrote:

=LOOKUP(2,1/(Sheet1!A1:A65535<""),Sheet1!A1:A65535)

"AnotherNewGuy" wrote:

I know I've seen this discussed here, but I haven't been able to find it.

I have a long column of text entries that will continue to grow
indefinitely. I simply want to use the value of the bottom entry in a cell
on another worksheet. There will be many repeats, entries are in no
particular order, and there will always be an entry.

For instance, with the following in column A on Sheet 1, I'd like "Larry" to
appear in cell A1 on Sheet 2.

John
Sam
Joe
Larry

thx

Last text entry in a column
 

If the data does not contain formula blanks (""), try...

=LOOKUP(REPT("z",255),'Sheet1'!A2:A100)

Adjust the range, accordingly.

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
AnotherNewGuy wrote:

I know I've seen this discussed here, but I haven't been able to find it.

I have a long column of text entries that will continue to grow
indefinitely. I simply want to use the value of the bottom entry in a cell
on another worksheet. There will be many repeats, entries are in no
particular order, and there will always be an entry.

For instance, with the following in column A on Sheet 1, I'd like "Larry" to
appear in cell A1 on Sheet 2.

John
Sam
Joe
Larry

thx