Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Postleitzahlen

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.

share|improve this question
    
you want a list where? in excel? in a single cell as strings? –  Solemnity Jan 24 '13 at 7:16
    
yes in excel. updated the question and added clarification. –  vertoe Jan 24 '13 at 7:19

1 Answer 1

up vote 4 down vote accepted

Have you seen Filter for unique values or remove duplicate values?

  • Select the range of cells, or make sure the active cell is in a table.
  • On the Data tab, in the Sort & Filter group, click Advanced.

enter image description here

  • In the Advanced Filter dialog box, do one of the following:

    1. To filter the range of cells or table in place, click Filter the list, in-place.
    2. To copy the results of the filter to another location, do the following:
      • Click Copy to another location.
      • In the Copy to box, enter a cell reference.
      • Alternatively, click Collapse Dialog Button image to temporarily hide the dialog box, select a cell on the worksheet, and then press Expand Dialog Button image.
  • Select the Unique records only check box, and click OK.

The unique values from the selected range are copied to the new location.

share|improve this answer
    
got it, thanks! –  vertoe Jan 24 '13 at 8:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.