Unique data

Hi,

I have data in a particular column that could potentially repeat itself down the colum. I'd like to get the column to copy and paste unique data from that column into another. So far, I have sorted the original data in ascending order and autofiltered but then the data at the top of the column does not come out to be unique. However, all the other data become unique after auto filter. Can you think of a way to make my data completely unique? I am trying to automate this via VBA

Pls let me know if you need clarification on anything.

thanks

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion