I have a single column in an Excel sheet with around 25,000 cells (numbers). Most of them are identical that in the end there are only - I guess - maybe 200 different numbers.
Is there a way to extract them? In the end, I want a list with every entry only occurring once:
... 15745 15746 15748 ...
I played around with a lot of Excel features, including the new grouping option - but most of them only work with tables of two or more columns.
I have Excel 2013, Excel 2007 and Libre Office Calc 3.6 available. Any ideas?
Update: Yes, I want that list in an Excel sheet or similar tools. Anything that allows further tabular processing. CSV would be okay, too.