Remove duplicates loop through columns

**closerb4** · 02-03-2011, 04:11 PM

I am looking to get a macro to remove duplicates from individual columns, doing so until it's finished with all the columns. I imagine this would be easy-ish for you Excel wizards!

Example:

A B C
Cat Cat Cat
Dog Cat Bird
Bird Dog Bird

Goes to:

A B C
Cat Cat Cat
Dog Dog Bird
Bird

Any help please? You guys did an amazing job last time, so I figured I'd try my luck again.

**MarvinP** · 02-03-2011, 04:53 PM

Hi closerb4,

In Excel 2010 you can do this easily.
First Select the entire B Column and then click on the Data Tab.
Find and click on the Remove Duplicates.
Click the Radio Button of "Continue with the current selection" and
Click "Remove Duplicates..."

Do the above with each individual Column and you have it.

If you want VBA code that does the above Please respond witht the request.

**stnkynts** · 02-03-2011, 05:11 PM

To add to MarvinP, if you have a lot of columns that you need to do this for, you could do it quickly with a macro. Try this:

Please Login or Register  to view this content.

You may need to adjust the columns range to match your range.

**MarvinP** · 02-03-2011, 05:13 PM

Hi,
Here is the code

BUT

be careful as this will remove all relationship between data in a single row. This is very dangerous code as it could mess up your entire data structure.

Please Login or Register  to view this content.

Only use the above if you can lose your data (or know exactly what it does).

**watersev** · 02-03-2011, 05:22 PM

see old-fashioned way, run macro "Un", result on sheet 2

**closerb4** · 02-07-2011, 03:30 PM

Thank you, I will try these out. There is no horizontal relationship between the data. Each column is for a new "Person" and all the rows come to me as things they've selected. So it doesn't matter if the rows don't correspond between columns, I just need something that will go out to many columns, often into the FF range.