Pull data from most recent of record with same values

[Hayley]

I know that title made no sense...sorry.

I have a spreadsheet that shows trips booked by customers. Customers are identified by a customer number and each trip shows trip number, customer number, booking date, and location. For each unique customer number, I want to show the location of the most recent booking. I can't figure out how to pull that information.

How do I do a formula that identifies the most recent one and then only pulls the location for that one?

Thanks much!

 

[amrit1186]

Dear Hayley

Please share the sample data.

Amritansh

 

[Hayley]

Here's the sample. I highlighted the ones where there are multiples of the same customer number and the highlighted ones are the ones I would want, because they are the travel center for the most recent booking. So if I dedupe the customer numbers (P#), I want to then only show the recent one.

 

[amrit1186]

Please use the below array formula

INDEX($D$2:$D$15,MATCH(MAX(--($C$2:$C$15=C2)*($B$2:$B$15)),--($C$2:$C$15=C2)*($B$2:$B$15),0))

Press Ctrl+Shift+Enter after entering the formula.

 

[Hayley]

Oh, that worked! awesome, thank you!!!