+ Reply to Thread
Results 1 to 4 of 4

Names and scores of the two lowest scores

  1. #1
    Registered User
    Join Date
    04-20-2007
    Posts
    19

    Names and scores of the two lowest scores

    In my scoring sheet, I need to pull the names of the people with the two lowest scores of their ride.

    Names are in Column D (rows 4 - 18). Their score is in column H (rows 4 - 18).

    Once I get these identified, I will pull them to another sheet. All I need is to ID them (along with their score) lower in the sheet and I will then pull the names and scores to another sheet.

    Thank you

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    as long as they all have unique scores this will do it
    formulas in yellow cells
    Attached Files Attached Files
    Last edited by martindwilson; 07-14-2008 at 07:22 PM.

  3. #3
    Registered User
    Join Date
    04-20-2007
    Posts
    19

    Thank you

    Thank you, I will check it out when I get to the office....

    Hopefully my example was sufficient (thank you for the support yesterday in my post and responses from VBA Noob)

  4. #4
    Registered User
    Join Date
    04-20-2007
    Posts
    19

    Works!

    Fantastic! Thank you!

    Enjoy the Tour de France and the success of Mark Cavendish (Team Columbia)!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1