+ Reply to Thread
Results 1 to 4 of 4

how to delete rows based on the certain values in several columns

  1. #1
    Registered User
    Join Date
    04-26-2015
    Location
    Tehran
    MS-Off Ver
    2007
    Posts
    57

    how to delete rows based on the certain values in several columns

    Dear all,
    I have a large excel file having 65848 rows and 350 column.

    I want to delete rows for which the value of cells are less than 10 in even one single column.

    I have provided a sample file here and sheet1 and shhet2 show you what I mean.

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: how to delete rows based on the certain values in several columns

    Hi nazaninibb,

    Try this subroutine:

    Please Login or Register  to view this content.
    Change the 15 in my code above to 350 to deal with your bigger set of data.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-26-2015
    Location
    Tehran
    MS-Off Ver
    2007
    Posts
    57

    Re: how to delete rows based on the certain values in several columns

    Thanks MarvinP,
    But after 3 hours of running it is not finished yet.
    Is the computational expense so high for this task?
    Can u suggest faster way to do this job?

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

    Re: how to delete rows based on the certain values in several columns

    See if this runs faster...
    Please Login or Register  to view this content.

+ 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 unwanted rows and update count of rows based on values
    By boddulus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2015, 08:34 PM
  2. Replies: 2
    Last Post: 04-02-2015, 12:27 PM
  3. [SOLVED] Delete rows based on value of two columns
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-07-2013, 11:04 PM
  4. Delete rows based on 3 columns
    By nitin1309 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 03:32 PM
  5. Delete rows based off two columns
    By lricci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2013, 12:37 PM
  6. 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
  7. Macro to delete entire rows based values in columns
    By shamade2107 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2009, 11:17 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