VBA Listing Unique Data

[AndrewKent]

Hi there,

I have a column of codes. This column has duplicate codes within it and I want to write a macro that will make a list of all the unique codes within this column.

I have automated a pivot table (doing a count on the codes column so it shows mw how many times a unique code shows up) but is there an easier way to do this? Other than automating a pivot table I mean.

Many thanks,

Andy

 

[RoryA]

You could use the advanced filter - it has an option for unique entries only.

 

[AndrewKent]

That was much easier to build and maintain than a pivot table! Managed to get it all into one line too!

Cheers!

Andy