View Single Post
Old 03-10-2009 | 08:48 AM
  #73  
Roberto's Avatar
Roberto
Gets Weekends Off
 
Joined: Jan 2007
Posts: 579
Likes: 0
From: 757/767
Default

[quote=b2pilot186;575790][quote=Roberto;575345]The counts are pretty easy, after you've pasted the 01Feb09 Seniority List into Excel. Change the text to columns, and then sort by age.

Thanks Roberto...pretty slick. I did that, sorted the list and then wrote a formula for an extra column to display the current age of each pilot based on DOB and current date.

B2P
I've also got the 09-201 Seniority List converted to Excel, but I don't know where I can post it as an attachment since the old IPA forum went down. I don't like the company lists with the crewmembers in two side-by-side columns as it takes a while to format, cut and paste into one column. It took me about 3 hours for 09-201.

Last edited by Roberto; 03-10-2009 at 09:06 AM.