referenceing 'last row' in a cell formula

E

EdStevens

I know how to do this in a vba script, but not as part of a cell formula ...

Given a sheet where the first few rows contain some fixed 'header' and
'summary' information, then below that are 'detail' rows that are added to on
a daily basis. I have a cell in the 'header' area that I'd like to build a
formula that references "column a" in the last detail row.

Thanks in advance
 

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

Repeating a row other than the 1st row as the header row in a table from next page 1
how to reference a changing 'last row' cell in a formula 2
= cell above last entered data 9
Insert Row also adds formulas and moves cursor 2
Copy Formula Down until last row 2
Sort on 3 columns when number of rows vary daily 1
Email Last row to an email address in the last active cell 1
Get text from last and first cell in a column 3

Top