+ Reply to Thread
Results 1 to 2 of 2

delete rows depending on value in two column

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    cluj napoca
    MS-Off Ver
    Excel 2007
    Posts
    50

    delete rows depending on value in two column

    Hello,
    I have a problem.If the value in column B is equal then depending on value in column D, i need to delete row with the highest value(in absolute value).

    Column B Column D
    x=25.75 125.00
    x=25.75 98.00
    x=25.75 76

    x=13.34 -679.74
    x=13.34 -693.57

    x=26.68 59.65
    x=26.68 59.65

    the result:
    Column B Column D
    x=25.75 125.00
    x=13.34 -693.57
    x=26.68 59.65
    Any advice is well taken.
    Cheers.
    Last edited by meslija; 05-09-2011 at 07:05 AM.

  2. #2
    Registered User
    Join Date
    03-15-2011
    Location
    cluj napoca
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: delete rows depending on value in two column

    I sorted out the data, after that i deleted the unnecessary rows.

+ 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