+ Reply to Thread
Results 1 to 7 of 7

Delete all rows in which column does not contain specific word

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    chicago
    MS-Off Ver
    Excel 2010
    Posts
    52

    Delete all rows in which column does not contain specific word

    How can I delete any row in which column H does not contain the word "example"? The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,870

    Re: Delete all rows in which column does not contain specific word

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Cheers!
    Deep Dave

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,427

    Re: Delete all rows in which column does not contain specific word

    Hi BVT3030,

    Try this while on the sheet in question - though initially on a copy of your data as the results cannot be undone if they're not as expected:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,920

    Re: Delete all rows in which column does not contain specific word

    Quote Originally Posted by BVT3030 View Post
    The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.
    Perhaps
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-10-2013
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2007
    Posts
    125

    Re: Delete all rows in which column does not contain specific word

    Quote Originally Posted by BVT3030 View Post
    How can I delete any row in which column H does not contain the word "example"? The range in which I'm looking at is a table with headers and can vary in size. This data usually contains 50,000 + rows so looping would likely be too slow.
    Hi BVT3030!

    I tested. Pretty fast. Try it!

    Sincerely Pan 314



    1. If I helped, Don't forget to add to my reputation (click on the ★ AddReputation at bottom of this post)
    2 If you see that the thread is finished, no more request: --->Don't forget to mark thread as "Solved"! (Edit First post>Advanced>Change Prefix

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,920

    Re: Delete all rows in which column does not contain specific word

    BVT3030

    Thanks for the rep.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Registered User
    Join Date
    05-10-2013
    Location
    chicago
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: Delete all rows in which column does not contain specific word

    All seemed to work but I went with jindon's since it was the most straight forward. Thanks all!

+ 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. Delete rows that do no contain a specific word
    By Tesseh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:08 AM
  2. [SOLVED] delete rows when column has specific word(s)
    By chrisblackman in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-22-2013, 10:21 PM
  3. [SOLVED] Macro to delete rows that DO NOT contain specific word
    By enfieldsteve in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-19-2013, 10:59 AM
  4. [SOLVED] Need a macro to delete rows with specific word
    By renjithvakkayil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2013, 12:54 PM
  5. Delete rows or Clear contents below a specific word is found in Column A
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2012, 04:08 PM
  6. Delete all rows that dont contain a specific word.
    By BPSJACK in forum Excel General
    Replies: 4
    Last Post: 03-15-2012, 05:05 AM
  7. Macro to look for a specific word and delete rows
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2009, 06:35 PM
  8. Delete Row if Specific Word in Column A
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2009, 07:39 AM

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