Inconsistent Results: Advanced Filter Unique Records Only
A range contains 1 through 6, followed by 1 through 8, followed by 1 through 7.
"Advanced filter, unique records only" returns some duplicates. Why? |
My guess is that some of the "numbers" are text and some are real numbers.
If you insert a column, you can verify it with: =isnumber(a1) and drag down (if your range is in column A) One quick way to convert all "text numbers" to "number numbers" is to: copy an empty cell select your range to convert edit|paste special|check add KB wrote: A range contains 1 through 6, followed by 1 through 8, followed by 1 through 7. "Advanced filter, unique records only" returns some duplicates. Why? -- Dave Peterson |
All times are GMT +1. The time now is 07:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com