+ Reply to Thread
Results 1 to 6 of 6

How to delete only certain rows

  1. #1
    Registered User
    Join Date
    05-30-2022
    Location
    Germany
    MS-Off Ver
    10
    Posts
    7

    How to delete only certain rows

    Hello All,

    I am a new user of excel and I have a large datasheet to clean and had a doubt with clearing the certain rows, I have attached a jpg file in that I wanted to delete the rows with certain occurring numbers for example in the attached file there fewer numbers in the column of numbers like 3,4,5,6 these are the less occurred numbers and I want to clear the rows like this for the rest of the sheets and I have a large data set to clear like this, is there and way to do so, if you could please help it would be great.

    Thank you.
    Attached Images Attached Images

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to delete only certain rows

    1. We always prefer actual excel files rather than pics - we cant work with pics.

    2. Have you tried to apply filters, then filtering for just those numbers you want t delete> Once you have that filter set, you can delete all that display.

    SAVE THE FILE before you try this though, just in case you mess up
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-30-2022
    Location
    Germany
    MS-Off Ver
    10
    Posts
    7

    Re: How to delete only certain rows

    Thank you for your reply I can attach the file, as i have written the number is varying so i find it so difficult to delete the numbers, There is nothing common in these rows. for example i want to delete the row which has least occured number like 4,5,6 in the given attachment or photo.

    Thank you!
    Attached Files Attached Files

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: How to delete only certain rows

    per Ford's instructions, apply a filter to row 1, select the numbers you want to delete from the filter dropdown list, delete those rows.
    same details are in the workbook you uploaded that I am returning with a filter on row1.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to delete only certain rows

    Sam, thanks for the assist.

  6. #6
    Registered User
    Join Date
    05-30-2022
    Location
    Germany
    MS-Off Ver
    10
    Posts
    7

    Re: How to delete only certain rows

    Thank you so much Really appreciate it!

+ 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. Rows delete formula as per range of cell values with counter to delete # rows
    By qureshi2016 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2017, 09:35 AM
  2. Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E
    By LennyC91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2016, 08:22 AM
  3. [SOLVED] Delete blank rows between data rows, shift rows up, then repeat
    By excelactuary in forum Excel General
    Replies: 2
    Last Post: 03-11-2013, 11:53 AM
  4. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  5. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  6. delete duplicate rows, delete empty rows
    By loade in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-03-2012, 05:42 AM
  7. Delete & Merge Columns,Delete Rows with filter, etc
    By traderindia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2009, 02:12 AM

Tags for this Thread

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