VBA+Delete duplicate rows ignoring certain columns

[nickytraps]

Hi all,

I have a file that contains data from columns B3 to V (rows will be dynamic). I am looking to delete duplicate rows of data in my set (if any exists otherwise do nothing), however columns G&H can be disregarded. Meaning whether the data in G&H is duplicated or not is irrelevant. A sample file has been provided. Thank you in advance for any assistance!

Note there are duplicate columns in the set as well, which can/should be disregarded at this time. Thanks again.


The below actually works but I'm not sure how to modify it for my range while ignoring columns G&H.

Please Login or Register  to view this content.

Perhaps like this, but I would like the experts to weigh in as to whether this would be accurate. Thank you.

Please Login or Register  to view this content.

[Kaper]

Hi,

The second approach shall do the job. You may code it also this way:

Please Login or Register  to view this content.

note parentheses around arr passed as argument to removeduplicates - they are needed here

[nickytraps]

Thank you Kaper, I really appreciate the information and code. Forgive my questions but I am very new to coding and trying to learn.
In the code you provided I assume 0 to 18 represents columns B to V excluding G and H?

And the line arr(i) = IIf(i < 5, i + 1, i + 3) is basically looping through columns B to V and saying:
"if columns are B to E move right to the next cell by one, otherwise move right 3 cells (skipping G&H) arriving at column I?

Lastly I am not familiar with ReDim. I've read that it relates to resizing an array, but still not quite clear. Thanks again for your help and time.