Results 1 to 4 of 4

Get rows with greatest value based on value in first column

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    blah, us
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Get rows with greatest value based on value in first column

    Hello all,

    I did not know anything about Excel but the most basic functions.

    I want only the rows with the greatest value (3rd column) per user (1st column).

    Here's a sample of the data:

    user1 file1 5
    user1 file2 2
    user2 file1 244
    user2 file2 104
    user2 file4 1
    user2 file3 1
    user3 file2 390
    user3 file1 193
    user3 file3 2
    user3 file4 2
    user4 file1 243
    user4 file2 85
    user5 file2 136
    user5 file1 123
    user5 file4 17
    user5 file3 8


    Desired output:
    user1 file1 5
    user2 file1 244
    user3 file2 390
    user4 file1 243
    user5 file2 136

    Thanks for your help!
    Attached Files Attached Files

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