I have 40K rows in sheet1 column C but only ~75 unique values/strings in that column.
I need the unique list to be copied to Sheet2 row 1.
I would prefer not to copy all/sort by unique, rather copy only unique values, ie. look in sheet1 column C, get unique values and copy to sheet2, starting at column A row 2.
Has to be VBA (macro).
Thanks in Advance,