How to get unique records?

[brett]

I tried doing this to get unique numeric entries out of a column but it
didn't work:

- Select the column to filter.
- From the Data menu, choose Filter, Advanced Filter.
- Choose 'Copy to another location'.
- Leave the Criteria Range blank.
- Click the little box to the right on the "Copy to:" part and select
the copy to column in Excel.
- Click the same little box to get back to the filter.
- Add a check mark to the Unique records only box.
- Click OK.

Here are the entries I'd like to sort:
200.00
1001.00
1222.00
1001.00
2544.00
2154878.00
1222.00
6555.00

Here's what I get
1001.00
1222.00
1001.00
2544.00
2154878.00
6555.00

You can see 1001 is repeated. Any suggestions as to why this happens?

Thanks,
brett

 

[Pete_UK]

You need to have a header in the top cell, something like "Data" or
"Numbers". As you didn't have one, the Advanced filter assumed that the
top cell was the header, and as it also appeared later in the list you
got two of them. Notice that you don't have the value 200.00 in your
list - I suspect that you had omitted this from the highlighted list.

Hope this helps.

Pete

 

[brett]

You need to have a header in the top cell, something like "Data" or
"Numbers". As you didn't have one, the Advanced filter assumed that the
top cell was the header, and as it also appeared later in the list you
got two of them. Notice that you don't have the value 200.00 in your
list - I suspect that you had omitted this from the highlighted list.

Thanks. That works. 200 was omitted because in the filter box, it
started at row 2 and I didn't notice.

brett

 

[Pete_UK]

Thaks for feeding back. I used to get the same problems when I first
started using Advanced Filter, so I'm glad it worked for you.

Pete