Hi Group, I need to find a program that will identify rows which have the same numbers in it and delete it. For example I have multiple rows of data and I want to go through each one and find and delete the rows which have the number 1 in it more than 4 times. Any idea how to start or use a function which compares values in a row?
Thanks.
Hello sgrondines,
This macro will delete the entire row if a cell in column "A" contains 4 or more "1"s. You can change the column if needed.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Awesome Leith.
Here's a slight amendment, just in case this macro is being run on a HUGE dataset, it only does a single deletion at the end of the macro, might be a faster option:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
So far it all works great. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks