[Joyce]

Hello,

I'm applying an advanced filter, in place, unique values only.

However, it returns doubles. I have used Trim and have also created IF
statements checking if two of the duplicates are the same, cell by cell, and
they are.

Any ideas?

Thanks

[Dave Peterson]

If there is only one duplicate--and it's the top row of the range and another
row of the range, then I bet you don't have headers and excel is using that top
piece of data as the header.

Add headers if you don't have them.

If that doesn't help, you may want to share some snippets of data and your exact
steps when you run the advanced filter (along with the version of excel).

ps. If you're filtering a field that consists of numbers/digits, then make sure
that all your fields are the same type--either text or real numbers.

(And changing the number format isn't enough to ensure this!)

If you need help changing this data, explain what you want to do (text to real
numbers or numbers to text).

Joyce wrote:

Hello,

I'm applying an advanced filter, in place, unique values only.

However, it returns doubles. I have used Trim and have also created IF
statements checking if two of the duplicates are the same, cell by cell, and
they are.

Any ideas?

Thanks

--

Dave Peterson

[Joyce]

Hi Dave,

No, all columns have headers and the duplicates are in the middle of the
filtered data. I'm using XL 2003 and have used Advanced Filters for years.
Can't understand why this particular one won't work.

As always, I have copied and pasted the headings that I wish to filter by,
entered the criteria beneath them, for example:

Date Answer Name
=""&INDEX(QstnaireDate,1,1) Y Jim Smith

I apply the filter, ensuring the data range is correctly selected, the
criteria is the range as above and Unique Records Only is selected.

I filter in place.

Thanks

"Dave Peterson" wrote:

If there is only one duplicate--and it's the top row of the range and another
row of the range, then I bet you don't have headers and excel is using that top
piece of data as the header.

Add headers if you don't have them.

If that doesn't help, you may want to share some snippets of data and your exact
steps when you run the advanced filter (along with the version of excel).

ps. If you're filtering a field that consists of numbers/digits, then make sure
that all your fields are the same type--either text or real numbers.

(And changing the number format isn't enough to ensure this!)

If you need help changing this data, explain what you want to do (text to real
numbers or numbers to text).

Joyce wrote:

Hello,

I'm applying an advanced filter, in place, unique values only.

However, it returns doubles. I have used Trim and have also created IF
statements checking if two of the duplicates are the same, cell by cell, and
they are.

Any ideas?

Thanks

--

Dave Peterson
.

[Dave Peterson]

But you didn't share any of the original data and you didn't share what was
returned--or the value of that firstcell in the qstnairdate named range.



Joyce wrote:

Hi Dave,

No, all columns have headers and the duplicates are in the middle of the
filtered data. I'm using XL 2003 and have used Advanced Filters for years.
Can't understand why this particular one won't work.

As always, I have copied and pasted the headings that I wish to filter by,
entered the criteria beneath them, for example:

Date Answer Name
=""&INDEX(QstnaireDate,1,1) Y Jim Smith

I apply the filter, ensuring the data range is correctly selected, the
criteria is the range as above and Unique Records Only is selected.

I filter in place.

Thanks

"Dave Peterson" wrote:

If there is only one duplicate--and it's the top row of the range and another
row of the range, then I bet you don't have headers and excel is using that top
piece of data as the header.

Add headers if you don't have them.

If that doesn't help, you may want to share some snippets of data and your exact
steps when you run the advanced filter (along with the version of excel).

ps. If you're filtering a field that consists of numbers/digits, then make sure
that all your fields are the same type--either text or real numbers.

(And changing the number format isn't enough to ensure this!)

If you need help changing this data, explain what you want to do (text to real
numbers or numbers to text).

Joyce wrote:

Hello,

I'm applying an advanced filter, in place, unique values only.

However, it returns doubles. I have used Trim and have also created IF
statements checking if two of the duplicates are the same, cell by cell, and
they are.

Any ideas?

Thanks

--

Dave Peterson
.


--

Dave Peterson