Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Strathalbyn, South Australia
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Excel capabilities

    I have an Excel spreadsheet in Office 2010 on which I have a list of 10 runners in a race. They are listed in the order they nominated but I need to transfer this info to another sheet in the same Workbook to show the finishing order along with their name and odds. I am stuck. Any help would be appreciated. Have tried find, lookup, hlookup, vlookup, index and match.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Milorpar,

    Welcome to the lounge as a new poster.

    For such a short list a simple copy should work fine. Another option would be to place absolute references to the names in the first sheet in the second then they would be linked but could still be sorted, e.g. Sheet1!$A$1, etc.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Strathalbyn, South Australia
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you RetiredGeek, for your welcome and the advice, both were appreciated! I was hoping to be able to have the names in the second sheet automatically sorted so that a manual sort was unnecessary. The exercise requires data operators to enter the finishing order in a field of 10 runners. The second sheet is the official result sheet and needs to show the finishing order for publication. I know sorting would solve the problem but I thought it would exercise my poor old brain to automate the job. I have noticed that these simple exercises are not as easy as they used to be, similar to running, climbing stairs etc. Agian thanks for your interest.

  4. #4
    New Lounger
    Join Date
    Feb 2012
    Location
    St. Louis, MO
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts
    If I'm reading your question correctly, attached is a spreadsheet that I believe fulfills the requests made.

    Thanks!

    RVASQUEZ
    Attached Files Attached Files

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    RVasques,

    Nice solution!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    New Lounger
    Join Date
    Feb 2012
    Location
    St. Louis, MO
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts
    Thanks RetiredGeek

Posting Permissions

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