| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text in last used cell in a column to another cell.
I need a formula that will allow me to show the text in the last cell of a
column in another cell at the top of that same column. I have found one that works for numbers but not text. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text in last used cell in a column to another cell.
=LOOKUP(2,1/(A1:A65535<""),A1:A65535)
"rdp" wrote in message ... I need a formula that will allow me to show the text in the last cell of a column in another cell at the top of that same column. I have found one that works for numbers but not text. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text in last used cell in a column to another cell.
Try this:
=LOOKUP(REPT("z",255),A;A) -- Biff Microsoft Excel MVP "rdp" wrote in message ... I need a formula that will allow me to show the text in the last cell of a column in another cell at the top of that same column. I have found one that works for numbers but not text. Any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text in last used cell in a column to another cell.
It worked. Thank you very much.
"Gaurav" wrote: =LOOKUP(2,1/(A1:A65535<""),A1:A65535) "rdp" wrote in message ... I need a formula that will allow me to show the text in the last cell of a column in another cell at the top of that same column. I have found one that works for numbers but not text. Any suggestions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text in last used cell in a column to another cell.
I have run across one problem with what you gave me. When the cell in the
column has a formula in it the result is a blank cell. All is well as long as there are no formula in the referenced cell. Help would be appreciated. "Gaurav" wrote: =LOOKUP(2,1/(A1:A65535<""),A1:A65535) "rdp" wrote in message ... I need a formula that will allow me to show the text in the last cell of a column in another cell at the top of that same column. I have found one that works for numbers but not text. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| adding text to column cell if there's a value present | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
Linear Mode
