Results 1 to 4 of 4

Finding Max Value in Duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2009
    Location
    RI, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Finding Max Value in Duplicates

    Hi - I have data that has about 10 duplicate values (UTC Time) in one column and another column with number values (depth ft) that vary. I need to obtain the maximum (highest) value in the depth column and remove the other duplicates to filter out the low values. So for the data example below for UTC 15:56:28 I only want the 5.7 row, for 15:56:29 I want5.3 row and so on. I can attach the sheet if that helps, any help appreciated - this is a huuge dataset so manual filtering wont work. Data is from a sonar that gives 10 depth readings per second - I only need one depth tat is the highest value. Thanks

    ID UTC Depth (FT)
    1 15:56:28 4.3
    2 15:56:28 4.4
    3 15:56:28 5
    4 15:56:28 5.4
    5 15:56:28 5.7
    6 15:56:28 5.5
    7 15:56:28 5.6
    8 15:56:28 5.6
    9 15:56:28 5.5
    10 15:56:28 5.4
    11 15:56:28 5.3
    12 15:56:28 5.3
    13 15:56:28 5.3
    14 15:56:29 5.2
    15 15:56:29 5.3
    16 15:56:29 5
    17 15:56:29 4.9
    18 15:56:29 5.1
    19 15:56:29 5.1
    20 15:56:29 5.2
    21 15:56:29 5.2
    22 15:56:29 5.1
    23 15:56:29 5.1
    Last edited by Mr.Higgins; 07-28-2009 at 08:40 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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