I just need questions c and d answered using excel language like lookup functions and such - no sql. I've had to ask this question 3 times already and people have not been able to answer it correctly...

c Determine which driver traveled the maximum number of miles on their 1st route d Count the number of truck drivers who travel from Vienna to Baltimore or from Baltimore to Vienna. Mileage Vienna Baltimore Alexandria Vienna Baltimore Rockville 27.2 70.4 43.2 35.2 35.2 12 27.2 70.4 Miles Traveled Truck Driver ID Mil Truck Driver ID Route Order Pi ABC1234 ABC1234 ABC1234 DEF5678 DEF5678 DEF5678 DEF5678 GHI9101 GHI9101 GHI9101 JKL1121 JKL1121 JKL1121 JKL1121 MNO3141 MNO3141 MNO3141 PORS161 PORS161 PORS161 STU7181 STU7181 STU7181 VWX9202 VWX9202 Springfield Vienna BaltimoreSprin Vienna BaltimoreRockville lexandria Baltimore Springfield Alexandria Rockville Alexandria Springfield Rockville Springfield Vienna Alexandria Vienna Rockville Baltimore Rockville Vienna Rockville ABC1234 DEF5678 GHI9101 JKL1121 MNO3141 POR5161 STU7181 VWX9202 YZA1222 Baltimore 83.2 90 70.4 21 90 Alexandria 43.2 90 Alexandria 22.4 35.2 Which Driver drove max miles on 1st route? 70.4 83.2 27.2 35.2 Baltimore Vienna Number of Drivers who travel from Vienna to Baltimore OR from Baltimore to Vienna Alexandria Rockville Alexandria Springfield Baltimore Vienna Springfield Baltimore Rockville Springfield Rockville Vienna Rockville Springfield Rockville Alexandria Springfield Alexandria Baltimore Springfield Rockville 35 83.2 Vienna 27.2 39 Baltimore 83.2 WX9202 YZA1222 YZA1222 YZA1222 Alexandria 43.2