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) |