how would i calculate fastest average transit time from shenzen to sav. the data set is much bigger but if you could kindly explain how to do it i can use the formula on the whole set.

X K H8 -VLOOKUP(SH$6,AS:G1479,7,1) Destination SAVANNAH, GA #N/A B C D F G 1 Exercise 1 2 Which carriers has the fastest average transit time from Shenzhen, China to Savannah GA? 3 we think about variability and should it change which carrier we consider the fastest from Shenzhen to Savannah? 4 5 Carrie Origin Name Port of Discharge_Nam Departu Arrival Days in Transit 6 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 3-Jul-20 18-Jul-20 15 7 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 10-Jul-20 25-Jul-20 16 8 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 10-Jul-20 26-Jul-20 16 9 Carrier 2 SHENZHEN, CHINA SAVANNAH, GA 11-Jul-20 13-Aug-20 33 10 Carrier 3 SHENZHEN, CHINA SAVANNAH, GA 11-Jul-20 7-Aug-20 27 11 Carrier 3 SHENZHEN, CHINA NEW YORK, NY 4-Jul-20 31-Jul-20 27 12 Carrier 2 SHENZHEN, CHINA SAVANNAH, GA 18-Jul-20 20-Aug-20 33 13 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 17-Jul-20 1-Aug-20 15 14 Carrier 3 SHENZHEN, CHINA LOS ANGELES, CA 2-Jul-20 16-Jul-20 14 15 Carrier 3 SHENZHEN, CHINA LOS ANGELES, CA 2-Jul-20 16-Jul-20 14 16 Carrier 2 SHENZHEN, CHINA SEATTLE, WASHINGTON 9-Jul-20 25-Jul-20 16 17 Carrier 2 SHENZHEN, CHINA SAVANNAH, GA 4-Jul-20 6-Aug-20 33 18 Carrier 4 SHENZHEN, CHINA LOS ANGELES, CA 20-Jul-20 3-Aug-20 14 19 Carrier 3 SHENZHEN, CHINA SAVANNAH, GA 18-Jul-20 14-Aug-20 27 20 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 3-Jul-20 18-Jul-20 15 21. Carrier 3 SHENZHEN, CHINA SAVANNAH, GA 4-Jul-20 1-Aug-20 28 22 Carrier 3 SHENZHEN, CHINA SAVANNAH, GA 4-Jul-20 1-Aug-20 28 23 Carrier 2 SHENZHEN, CHINA LOS ANGELES, CA 3-Jul-20 18-Jul-20 15 24 Carrer 2 SHENZHEN, CHINA LOS ANGELES, CA 3-Jul-20 18-Jul-20 15 25 Carrier 3 SHENZHEN, CHINA LOS ANGELES, CA 2-Jul-20 16-Jul-20 14 26 Carrier 2 SHENZHEN, CHINA SAVANNAH, GA 4-Jul-20 6-Aug-20 33 Sheets Exercise 1 Exercise 2 Exercise Pivot Table Exercise 4