Uploaded May 2015 | Updated September 2026, 53 minutes ago

---

Get the Excel file here: http://1drv.ms/1bYwrTa

Add up flight route total miles. Looks easy but 'ATL-CLE' = 'CLE-ATL' and this should be 1 value.

(00:00) Challenge explanation
(01:21) Step 1: Extract the route codes
(01:57) Step 2: Per row, dynamically sort the routes
(02:09) Step 3: Created dynamic sorted route codes
(03:00) Step 4: Refresh pivot, use new route code.

Cheers,
Kevin Lehrbass
https:twitter.com-kevinlehrbass
http:myspreadsheetlab.com