I have a large amount of data (about 1,000,000 rows of data). What is the fastest way to find unique values for one column?
[Edit] I am not sure about how data repeats a lot or there are many unique values. I only want unique. Can remove duplicate values in original set. Or take the unique set and copy to column next to it.
Yes, 1,000,000 rows is a lot, but I cannot use any database to help out. [/Edit]
I know the Data ribbon, Advanced option. It is slow and seems looping for sometime.
My excel is 2013 version.