+ Reply to Thread
Results 1 to 9 of 9

Q> Deleting 3k++ rows

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    PH
    MS-Off Ver
    2017
    Posts
    4

    Question Q> Deleting 3k++ rows

    Hi,

    I am not an excel guru and have a question.
    I've got 10,000 rows of items, I would need to remove 3000 individual rows which are randomly picked in no particular order.. (i have the list of items to be deleted : Image reference below)

    I can find those item and delete them one by one but we're looking at 3000 rows here and it would take me forever.
    what's the best way to do this without clicking and deleting one row at a time?

    Thanks in advance!

    Untitled.png
    Last edited by SwitchDC; 08-16-2017 at 04:32 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: Q> Deleting 3k++ rows

    So then the rows to be deleted are not actually random, they just don't necessarily follow a specific order correct? Or maybe you randomly generated the 3000 criteria already, and now just want to delete these?
    Either way, sounds to me like something that would best be done with a macro (vba code). If you upload a sample of your workbook I should be able to help.

  3. #3
    Registered User
    Join Date
    08-16-2017
    Location
    PH
    MS-Off Ver
    2017
    Posts
    4

    Re: Q> Deleting 3k++ rows

    Yes, no specific order.. those 3000 rows must be removed from the main list..

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Q> Deleting 3k++ rows

    b1=IFERROR(IF(Match($A1,$D$1:$D$9,0)>1,"delete",""),"") and drag down

    After that filter on delete and delete the rows (in 1 move).

    in which d1:d9 houses the values which needs to be deleted.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: Q> Deleting 3k++ rows

    So are these two lists on two separate sheets?

    Or that^

  6. #6
    Registered User
    Join Date
    08-16-2017
    Location
    PH
    MS-Off Ver
    2017
    Posts
    4

    Re: Q> Deleting 3k++ rows

    Quote Originally Posted by danielexcelvba View Post
    So are these two lists on two separate sheets?

    Or that^
    separate file actually

  7. #7
    Valued Forum Contributor
    Join Date
    07-10-2017
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2013
    Posts
    430

    Re: Q> Deleting 3k++ rows

    Well let me know if oeldere's solution works

  8. #8
    Registered User
    Join Date
    08-16-2017
    Location
    PH
    MS-Off Ver
    2017
    Posts
    4

    Re: Q> Deleting 3k++ rows

    Quote Originally Posted by oeldere View Post
    b1=IFERROR(IF(Match($A1,$D$1:$D$9,0)>1,"delete",""),"") and drag down

    After that filter on delete and delete the rows (in 1 move).

    in which d1:d9 houses the values which needs to be deleted.
    It worked, this was the exact idea i had in mind but didn't know how to put it in formula.. look for the items in the remove list from the main list then tag them so I can filter. I'm not very much good at formulas.. but thanks mate!

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Q> Deleting 3k++ rows

    You're welcome. We appreciate the feedback!

    Thanks for marking the question solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ 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: 10
    Last Post: 06-07-2018, 04:16 PM
  2. Cleaning rows of data and clean rows of duplicates not deleting.
    By guidom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2014, 12:48 PM
  3. Replies: 2
    Last Post: 08-20-2013, 07:52 AM
  4. [SOLVED] Macro help with combining data across 2 rows (and deleting non-required rows)
    By InnesMcc in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 05-20-2013, 05:21 AM
  5. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  6. [SOLVED] Deleting part of a column without deleting whole rows.
    By dstrdOne in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2013, 11:42 AM
  7. VBA- deleting rows which contain cells that meet criteria, but skip alpha rows
    By cheapkid1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:49 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