Remove duplicates across multiple columns

This should do it

Please Login or Register  to view this content.

Dear fellow Excellers and Readers,

Please note the code differences above.

Both will remove duplicates - BUT - will offer different results.

Note 1: djbomaha Code only removes duplicates from any ONE column, i.e. despite the number of columns in your 'range', the code will look down each columns (despite referring to 'Rows') and will remove duplicates in each column....then moves onto the next column and so on and so forth. This code set is rigid insofar as the user must change values for i and j according to their individual worksheet or problem. This is EXCELLENT code should you wish to control a set within a smaller area of your worksheet.

Note 2: mike7952 Code removes ALL duplicates from the entire range. So.....If you have say, a number 12 located in "A1", and "B3", and "AZ23"....it will remove all but one of those entries.

Personally, I prefer Mikes code purely because it appears to have answered the question a little more thoroughly. Having said that, both Code Examples should be excellent examples for learning the differences between results when using For-Next loops.

The only thing missing from each of the code sets offered above are code execution speed enhancements....but there are thousands of posts across the web on just that topic.....so, move on.

Mike - simple, nice, clean - well done!

H.