How do I reference contents of a cell at the bottom of a column?

M

MarkB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell reference of a formula 2
Display selected cell at bottom of screen 2
Locking a cell reference in a formula 1
Multiple SUM's in a column 15
Copy last entry of column to bottom of column 3
Delete rows based on contents of Col A 0
show last used cell in a column at the bottom of column. 3
nested Cell("contents", w/ cell contents reference) 1

Top