Results 1 to 7 of 7

unique data

Threaded View

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    unique data

    Dear Community, good afternoon from a wet cold London.

    Thanks for taking the time to look at this post.

    I have found myself at the mercy of Excel again..........

    Please find attached a spreadsheet.

    In the sheet entitled "Sorted by cc & s" which is already sorted in the following order:

    course code (ascending) followed by starts (descending)

    I would like to unique the data on course code, that is extract all data, Cols A to Q but only for course codes where the starts are the highest.

    I.e, if a course code appears 3 times extract only data where the number of starts (Col H) is highest.

    Therefore, I would like to be left with a list of unique course codes with the HIGHEST nuber of starts (col H)

    Thanks all.

    Darren
    Attached Files Attached Files
    Last edited by Blake 7; 11-08-2010 at 12:47 PM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

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