Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Line
Is there any formula to tell me what the last line of data in a column is?
-- for example if data ends in cell A45 -- is there a formula that would look a column a and return A45? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Line
In article ,
terri wrote: Is there any formula to tell me what the last line of data in a column is? -- for example if data ends in cell A45 -- is there a formula that would look a column a and return A45? Do you want to return the contents of A45 or the cell reference A45? Does Column A contain text or numerical values? Or does it contain both? -- Domenic http://www.xl-central.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Line
I want it to return the cell reference of A45. The column contains
alpha-numerics. "Domenic" wrote: In article , terri wrote: Is there any formula to tell me what the last line of data in a column is? -- for example if data ends in cell A45 -- is there a formula that would look a column a and return A45? Do you want to return the contents of A45 or the cell reference A45? Does Column A contain text or numerical values? Or does it contain both? -- Domenic http://www.xl-central.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Line
In article ,
terri wrote: I want it to return the cell reference of A45. The column contains alpha-numerics. "Domenic" wrote: In article , terri wrote: Is there any formula to tell me what the last line of data in a column is? -- for example if data ends in cell A45 -- is there a formula that would look a column a and return A45? Do you want to return the contents of A45 or the cell reference A45? Does Column A contain text or numerical values? Or does it contain both? -- Domenic http://www.xl-central.com Alpha-numeric values, such as ABC12345, are considered text values. As such, the following formulas will find the last text value in Column A and return its cell reference... =CELL("address",INDEX(A:A,MATCH(REPT("z",255),A:A) )) or =SUBSTITUTE(CELL("address",INDEX(A:A,MATCH(REPT("z ",255),A:A))),"$","") -- Domenic http://www.xl-central.com |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Line
=ADDRESS(MATCH(REPT("z",255),A:A),1) will return address of last text data
in column A =ADDRESS(MATCH(99^99,A:A),1) will return address of last numeric data. The ,1 is a variable for cell address reference style. 1 is absolute................4 is relative........2 and 3 are row and column relative. Gord Dibben MS Excel MVP On Tue, 7 Apr 2009 09:41:05 -0700, terri wrote: I want it to return the cell reference of A45. The column contains alpha-numerics. "Domenic" wrote: In article , terri wrote: Is there any formula to tell me what the last line of data in a column is? -- for example if data ends in cell A45 -- is there a formula that would look a column a and return A45? Do you want to return the contents of A45 or the cell reference A45? Does Column A contain text or numerical values? Or does it contain both? -- Domenic http://www.xl-central.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions |