Pilot Logbook

[markvukotich]

Hi everyone, need some help with an excel formula. Refer to attachment:

Column A is where I enter the date for a flight. Column X is the number of ILS approaches performed on that flight. Cell X4 is where I input the last date I completed an ILS and cell X5 calculates when the next one is due.

Instead of having to input the date manually into X4 I would like a formula that scans column X for the most recent entry and returns the date that it occured from column A.

Im sure it can be done but have no idea how to do it.

Cheers in advance.

[TMS]

I can't pretend to understand your flight log.

However, a date is just a number so you should be able to use MAX to get the most recent date and then add a constant to it to get the next date due.

Regards, TMS

[markvukotich]

Thanks. It doesnt work though because the most recent entry in column A doesn't neccessarily contain an entry in column X. All I've been able to do so far is return the most recent value in column X (which is usually "1") but this value is useless. What I need is a formula that finds the most recent entry in column X and return the corresponding value in column A from the same row

[Winon]

Hello markvukotich,

Place this formula in Cell X4:

Please Login or Register  to view this content.

Extend the Range of 3000 to suit.

HTH

[TMS]

Have a look at:

http://www.excelforum.com/excel-work...quivalent.html

For an alternative approach.

[markvukotich]

you are a legend!!! works perfectly. thanks heaps!!!

[Winon]

Thank you markvukotich,

You are welcome.

Also see the "Please consider" note at the bottom of this Post to mark your thread as Solved