FlyerTalk Forums - View Single Post - Using Excel - Taking the pain out of finding MRs
Old Feb 21, 2005 | 5:39 pm
  #1  
925
 
Join Date: Jul 2003
Location: Seattle, WA
Programs: Marriott Titanium
Posts: 2,861
Using Excel? - Taking the pain out of finding MRs?

Bikeguy just posted this link: http://www.indiakane.com/ff/ff.jsp.

You can type in up to four airports you can depart from, and the fares will be listed from lowest to highest if you use the price option.

It is easy to cut and paste this info into an Excel spreadsheet.

Can any of you Excel wizards figure out how to search the first column for the airports in parenthesis, run it against a table of miles between airports, so a new column called EQM can be populated? Then sort by EQM and voila! Take your pick of your best MRs!

Last edited by 925; Feb 21, 2005 at 5:47 pm
925 is offline