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.