| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference contents of a cell at the bottom of a column?
I have a growing set of data which I continually add rows to the bottom of.
How do I reference the lowest cell in a particular column, when I don't know if there are 10 rows or a 1000? I suppose it might be useful to know the same thing rows too. i.e. the rightmost value of a row. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I reference contents of a cell at the bottom of a column?
The value of the last numeric value in column A is:
=LOOKUP(99^99,A:A) -- Gary''s Student - gsnu200841 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I reference contents of a cell at the bottom of a colum
Many thanks fro that Gary. Just what I needed.
"Gary''s Student" wrote: The value of the last numeric value in column A is: =LOOKUP(99^99,A:A) -- Gary''s Student - gsnu200841 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell contents from a reference | Excel Discussion (Misc queries) | |||
| show last used cell in a column at the bottom of column. | Excel Worksheet Functions | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
| Reference cell contents | Excel Discussion (Misc queries) | |||
Linear Mode
