Choose maximum value out of a number of values that match certain criterias from an array

Hi All,

Been a member for over a year, many thanks to all, it's been an educational experience.

I am trying to write a formula that will do 2 steps:-

1- Choose several values out of an array according to several criteria
2- return the highest value amongst above chosen values

Example

Excel Forum.png

In this Example i want a formula to be entered in column "G" that will calculate the number of days between the last return date of the vehicle and the shipping date of the vehicle on this row.

In other words the formula in "G5" must give the result "2" since the vehicle 22 returned from its last ship on January 4th and then shipped again on the 6th, to me that's 2 days in standby, and "G8" must give the result "3" because the vehicle 23 last returned on Jan 12th and shipped again on the 15th.

Any suggestions?!!

If a formula can't calculate this, how can i rearrange the data tables so some sort of a formula can calculate the standby days accurately?