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 |
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 |