+ Reply to Thread
Results 1 to 4 of 4

Delete Entire Row where there is text (word) in the Column

  1. #1
    Forum Contributor
    Join Date
    09-19-2003
    Posts
    226

    Delete Entire Row where there is text (word) in the Column

    Hi All

    I want to delete entire rows where a word is repeated down Column G. If Cells G1, G20, G100, etc. contains the word "GOV" I want to delete rows 1,20,100, etc.

    Thanks

    Patish
    Patish

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Delete Entire Row where there is text (word) in the Column

    Try:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    09-19-2003
    Posts
    226

    Re: Delete Entire Row where there is text (word) in the Column

    Many thanks, Olly. Worked like a charm.

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Delete Entire Row where there is text (word) in the Column

    Quote Originally Posted by Patish View Post
    Many thanks, Olly. Worked like a charm.
    Happy to help, thanks for the feedback.

+ 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: 2
    Last Post: 05-27-2016, 12:30 AM
  2. Delete entire row when specifc word is typed into a cell in that row
    By d41 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2016, 10:05 AM
  3. [SOLVED] Delete entire row in table if cell in column P contains any value (numbers or text)
    By BuntyMac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2016, 02:49 PM
  4. Help With formulas to delete entire row if text contains a word
    By copal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2014, 01:50 PM
  5. Delete entire column if word "False" exists
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 02:33 PM
  6. delete Entire Row if specified word exist
    By contaminated in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2009, 04:41 AM
  7. How to search for a word in a column and have entire row opaque once word is found
    By copleyr in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-04-2009, 07:11 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