Formula to find most recent oil change date, then compare it to current date

I'm trying to write a formula that will search the range of D6:D200 for the word "Oil Change". Then when it is found, search the range of A6:A200 for the most recent date that is in the same row as the word "Oil Change", which then compares this date with the current date, letting me know if I'm way over due or not.

Or would this be more efficient if the date is searched first, then the string "Oil Change"? I'm guessing it probably doesn't make much difference.


Thank you
Mike

Hi,
please post a sample in excel. Look at the yellow banner at the top of the page for more instructions. Thanks.

Originally Posted by belinda200

Hi,
please post a sample in excel. Look at the yellow banner at the top of the page for more instructions. Thanks.

I figured it out by using this formula: =MAXIFS($A$6:$A$200,$D$6:$D$200,"Oil Change")

I was trying to do it using vlookup, Search, and Index, etc, then found the MaxIfs, which worked perfectly.