+ Reply to Thread
Results 1 to 4 of 4

Find a row with a specified value and then delete it!

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    4

    Find a row with a specified value and then delete it!

    Hi All,
    This is my first thread. I am really bad with excel formulae so please help.
    Have a 8000 line spreadsheet. I need to find zero values in column D AND blank values in column E and then delete them.

    Pls suggest an easy and quick way.

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Find a row with a specified value and then delete it!

    You can't delete a row using a formula, so you would need a macro to do that (which might be even more daunting to you than formulae).

    However, you can do it manually - just apply autofilter to column D and column E then select the visible rows and click the <delete> icon, then remove the filters.

    Hope this helps.

    Pete

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

    Re: Find a row with a specified value and then delete it!

    Hi

    It can also be done by using macro too... what will you prefer?
    If you want macro then pls upload sample file...
    Click *, if my suggestion helps you. Have a good day!!

  4. #4
    Registered User
    Join Date
    06-04-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Find a row with a specified value and then delete it!

    Thanks Pete and jraj.
    I used the filter, works just fine without any formula!

+ 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