Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adv Filter - Unique Items NOT working
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adv Filter - Unique Items NOT working
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adv Filter - Unique Items NOT working
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adv Filter - Unique Items NOT working
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Num of Unique items in col ? | Excel Worksheet Functions | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Filter for Unique Values not working | Excel Discussion (Misc queries) | |||
Sumif only unique items | Excel Discussion (Misc queries) | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) |