| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a column be formated to make any entry in that column capitali | Excel Discussion (Misc queries) | |||
| Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| Changing none text entry to text? | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
Linear Mode
