Finding the most current and previous current date based on multiple criteria

Here is one way...

Being that this is going to use a match to find the last date, you will need to sort your order in Descending order (TIME) also need to make sure your dates are values and not text as you have them in your current shared file.

Array - So you will need to hit CTRL+SHIFT+ENTER to apply the formula

Please Login or Register  to view this content.

Cheers

Here is another array entered formula* solution which doesn't require sorting, but does require that dates be dates as opposed to text (use the text to columns method):

Formula:

Please Login or Register  to view this content.

*Array entered formula are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let me know if you have any questions.

As your dates are in Text format, so you can use this array formula :

Please Login or Register  to view this content.

Or,

Please Login or Register  to view this content.

Confirm Ctrl+Shift+Enter

Try this ...

=LOOKUP(SUMPRODUCT((A$2:A$38=A2)*(B$2:B$38=B2)*(C$2:C$38=C2)*(D$2:D$38=D2)*(E$2:E$38-E2>0))+1,{1,2,3},{"Current","Previous",""})

Or

=LOOKUP(COUNTIFS(A$2:A$38,A2,B$2:B$38,B2,C$2:C$38,C2,D$2:D$38,D2,E$2:E$38,">"&E2)+1,{1,2,3},{"Current","Previous",""})

Try this solution (cars can be any order):

Please Login or Register  to view this content.

You're Welcome, thank you for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.