FlyerTalk Forums - View Single Post - Using Excel - Taking the pain out of finding MRs
Thread: Using Excel - Taking the pain out of finding MRs
View Single Post
Old Feb 21, 2005 | 7:29 pm
  #5  
gitismatt
 
Join Date: Feb 2004
Location: LAS
Programs: DL PM, Honors Gold, Marriott Gold, AA Gold
Posts: 894
Originally Posted by 925
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!
sounds like something a vlookup could accomplish. if you can send me a small sample version of this info, i can tinker around with it to see what i can do. PM me for my email address
gitismatt is offline  
Reply