+ Reply to Thread
Results 1 to 3 of 3

Delete row if row if cell value is greater than value of next row

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    Arkansas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Delete row if row if cell value is greater than value of next row

    I am trying to write a macro which will delete an entire row of data if by looking at column I, the cell is greater or equal to the value in the next cell one row down. For example if Cell I2 has a value of 3 and Cell I3 has a value of 1, then row 2 should be deleted. The macro needs to continue down the column i until the next row becomes a lesser value than previous, so when cell I7 is 14 and I8 is 18, then the macro should stop. I am lost on how to do this. Thanks,

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Delete row if row if cell value is greater than value of next row

    Hi.

    Try this:

    deleterows.xlsm
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    02-25-2013
    Location
    Arkansas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Delete row if row if cell value is greater than value of next row

    Thanks, it works

+ 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