| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,comp.sources.d
|
|||
|
|||
Q) Referencing the last cell in a formula
Hi,
I would like to know if there is a generic way to reference the last non-blank cell in an Excel formula. The last non-blank cell could be: 1) in a row (e.g. $LASTROW) 2) in a column (e.g. $LASTCOL) 3) in a worksheet Thanks, Gus |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q) Referencing the last cell in a formula
You say "reference"
Do you want the value of this last cell or its location? -- Gary''s Student - gsnu200813 "Generic Usenet Account" wrote: Hi, I would like to know if there is a generic way to reference the last non-blank cell in an Excel formula. The last non-blank cell could be: 1) in a row (e.g. $LASTROW) 2) in a column (e.g. $LASTCOL) 3) in a worksheet Thanks, Gus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a formula and cell referencing. | Excel Worksheet Functions | |||
| #VALUE! displayed when referencing a formula cell | Excel Discussion (Misc queries) | |||
| need help referencing cell using result of formula | Excel Discussion (Misc queries) | |||
| Referencing text in a cell in a formula | Excel Discussion (Misc queries) | |||
| referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
Linear Mode
