delete duplicate rows, delete empty rows

[loade]

hello!

is there a macro to delete all duplicate rows?
is there a macro to delete all empty rows?

(seperate macros)

thanks!

[jraj1106]

Hello...
Upload sample data...

[tom1977]

Hi for empty rows You can use this:

Please Login or Register  to view this content.

[bonny24tycoon]

Hi Tom,

Im happy to learn from you again and again. The above code of yours and your knowledge deserves a rep :-)


Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **

[arlu1201]

For duplicate rows, are there just 2 rows duplicating or more?

[loade]

For duplicate rows, are there just 2 rows duplicating or more?

there may be more duplicates

I didnt upload anything, because it has to be universal solution

[arlu1201]

Based on what conditions should the duplicate rows be deleted? I mean, which are the fields that should be checked for duplicates?

[loade]

Based on what conditions should the duplicate rows be deleted? I mean, which are the fields that should be checked for duplicates?

Umm, just when two or more rows are exactly the same, to be more precise, have the same text, but then leave intact the first and delete all subsequent duplicates

[arlu1201]

Since you are attempting an universal solution, is there any particular range or can that be changing each time?

[loade]

Since you are attempting an universal solution, is there any particular range or can that be changing each time?

the range is from the first not null cell to the last not null cell

[arlu1201]

So even if a file has 20 columns of data, you want all 20 columns to be compared to each other for duplicates?

[Nrowell92]

This is the code I usually use. It asks which column to check for duplicates and blanks.

Please Login or Register  to view this content.

Not the most efficient or best way at all but I personally like it. Good Luck

[loade]

So even if a file has 20 columns of data, you want all 20 columns to be compared to each other for duplicates?

regardless of the number of columns, data will be considered as rows only