Excel formula in an expanding table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm calculating the gas mileage on our new car. As a result I have to change
the formula to reference the last fillup date in my table. Is there any way I
can make this formula automatically reference the last fillup date or row?
I've looked at all the Exel functions and can't seem to find one that works.
Thanks.

Pete
 
The following will return the last numerical data in a column, including
dates which are stored as serial numbers...

=LOOKUP(9.99999999999999E+307,A:A)

Hope this helps!
 

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

Collecting data for MPG (miles per gallon) calculation 4
Looking for Mileage / MPG Tracking formula 3
Searching up a column 7
Excel VBA 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Conditional formula in Excel 3
Formula help 1
Protecting Formulas in Tables 2

Back
Top