Inconsistent Results: Advanced Filter Unique Records Only

K

KB

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?
 
D

Dave Peterson

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
 
Top