Results 1 to 2 of 2

Thread: AFL/LG Discrepancies

  1. #1
    Join Date
    Nov 2007
    Location
    Reading, Berkshire, UK
    Posts
    3,602
    Thanks
    3
    Thanked 12 Times in 12 Posts

    Default AFL/LG Discrepancies

    Hello All,
    I’m currently cross-checking entries in the LG for the RAFVR Met Branch against any corresponding entries in an AFL (and vice versa). There are some discrepancies.
    The AFL, for example, gave the name ‘Durwood, J’. This was not found in the LG – it should have been ‘Durward, J.’ (only picked this one up because I personally knew of him years ago!!)!!! Similarly, there are some Commissioning/Seniority date discrepancies. The advantage of working from the AFL is that (hopefully?) all the Officers are listed on half-a-dozen pages whereas the LG data had to be derived “the hard way” – and I probably missed several!!!
    My instinct is to believe the LG entries as opposed to the AFL entries? And life would be so much easier if I could sort the 3 x cols per page of the AFL alphabetically! Anybody know how this can be done? I’ve only got an ancient version of Excel, and Abbey FineReader 6.0. Any suggestions (strictly of a polite/legal nature!) welcomed!
    TIA
    Peter Davies
    Meteorology is a science; good meteorology is an art!
    We might not know - but we might know who does!

  2. #2
    Join Date
    Nov 2007
    Location
    Canada, eh
    Posts
    1,217
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Peter, all but the oldest Excels should allow you to sort your data alphabetically.

    1. Save your data under a different file name, in case you mess up (voice of sad experience)
    2. Highlight all the data, in all three coloumns
    3. Under the "data" pull down, pick "Sort"
    4. Fill in all the boxes in the little window that pops up, press OK, and Bob's your uncle.
    Last edited by Bill Walker; 23rd February 2013 at 17:54.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •