| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Displayed
How do I set up a cell to display the last entry (of text) in a column,
regardless of what the text says...and have it update daily as more rows are added to the column, and as the text entry may change...based on the formula? Can anyone assist me with this? Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Displayed
=LOOKUP(REPT("Z",255),A:A) will display last text entry in selected range HTH "Tom" wrote: How do I set up a cell to display the last entry (of text) in a column, regardless of what the text says...and have it update daily as more rows are added to the column, and as the text entry may change...based on the formula? Can anyone assist me with this? Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Displayed
Assuming there are no gaps in the data in column A, this will display the
last entry: =OFFSET(A1,COUNTA(A:A)-1,0) Regards Trevor "Tom" wrote in message ... How do I set up a cell to display the last entry (of text) in a column, regardless of what the text says...and have it update daily as more rows are added to the column, and as the text entry may change...based on the formula? Can anyone assist me with this? Tom |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Displayed
How do I eliminate the blank lines displayed by the formula in the ceels of
that column? The formula is this: =IF(GA264="","",IF(AND(GA264<=0, GB264<=0),"Go",IF(AND(GA264=100, GB264=97),"Stop",GG263))) Right now I am getting a blank cell as a response. Tom "Toppers" wrote: =LOOKUP(REPT("Z",255),A:A) will display last text entry in selected range HTH "Tom" wrote: How do I set up a cell to display the last entry (of text) in a column, regardless of what the text says...and have it update daily as more rows are added to the column, and as the text entry may change...based on the formula? Can anyone assist me with this? Tom |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Displayed
Thanks !!
"Trevor Shuttleworth" wrote: Assuming there are no gaps in the data in column A, this will display the last entry: =OFFSET(A1,COUNTA(A:A)-1,0) Regards Trevor "Tom" wrote in message ... How do I set up a cell to display the last entry (of text) in a column, regardless of what the text says...and have it update daily as more rows are added to the column, and as the text entry may change...based on the formula? Can anyone assist me with this? Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with function on LOOKUP with Text | Excel Worksheet Functions | |||
| truncating text strings of different lengths | Excel Discussion (Misc queries) | |||
| moving text from a word document to excel | New Users to Excel | |||
| Text in autoshape not displayed | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
