Remove duplicates from each column one at a time

[smokinbadger]

Hi, I have a sheet that contains multiple columns of data. Each column is unique and must stand alone. I need to remove the duplicates from each column individually (meaning removing the duplicates from column A can't affect column B, but then I need to remove duplicates in column B, then C, then D, ETC...). I do not know how to write macros and am currently doing this one column at a time.

I am using MS Excel 2013.

Go Badgers!!!

[JieJenn]

Please Login or Register  to view this content.

[smokinbadger]

Thanks JieJenn, however, it isn't working. It's not doing anything (that I can tell).

Go Badgers!!!

[JieJenn]

Can you attach your file?

[smokinbadger]

JieJenn, Thank you! I didn't realize your macro was only built for certain columns. I was able to modify your original macro to fit my needs.

Thanks Again!

Go Badgers!!!

[MarvinP]

Hi smoking,

See if this code does what you want:

Please Login or Register  to view this content.