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

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

On Jan 25, 8:33 pm, "brett" wrote:
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

On Jan 25, 12:40 pm, "Pete_UK" wrote:
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

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


On Jan 25, 8:50 pm, "brett" wrote:
On Jan 25, 12:40 pm, "Pete_UK" wrote:

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