I have a logbook in excel. Included is a column with airplane names in it, and a column with dates when i flew those airplanes. What i'm looking for is a function that will tell me the date that i last flew a specific airplane.
For example, given
column 1 = piper, piper, zlin, piper, zlin
column 2 = may 10, may 12, may 13, may 15, may 16
I want a function that will look through the list and tell me I last flew a piper on may 15.
Thanks!
- Adam
For example, given
column 1 = piper, piper, zlin, piper, zlin
column 2 = may 10, may 12, may 13, may 15, may 16
I want a function that will look through the list and tell me I last flew a piper on may 15.
Thanks!
- Adam