+ Reply to Thread
Results 1 to 2 of 2

Delete rows based on highest value

  1. #1
    Forum Contributor
    Join Date
    10-31-2010
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    152

    Delete rows based on highest value

    Hi all, I wondered if you could help on this one, I have a table where I want to keep the row with the lowest value, so with this example


    a b
    cx121 5
    cx122 7
    cx122 8
    cx123 9
    cx121 4


    the result I would need is

    a b
    cx121 4
    cx122 7
    cx123 9


    Any help would be really appricated.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete rows based on highest value

    Maybe:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-27-2012, 10:12 PM
  2. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  3. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  4. Delete rows without the highest value
    By BME_Guy in forum Excel General
    Replies: 7
    Last Post: 09-16-2010, 05:12 AM
  5. Replies: 3
    Last Post: 08-10-2006, 11:40 PM

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