On Wed, 23 Jan 2008 13:47:03 -0500, "Meebers" wrote:


"Ron Rosenfeld" wrote in message
.. .
On Wed, 23 Jan 2008 11:22:05 -0500, "Meebers" wrote:

Excel 07 doing advanced filtering. I have a column of numbers, some are
repeated, and I want to filter out unique numbers only. So as a test,
starting in A1 and going down, I input 1,2,3,1,2,3. Under advanced
filtering, I selected the range, a1:a6, want it copied to another location
,
B1, checked unique records only and expect the result to = 1,2,3. The
result is 1,2,3,1. It seems like if the top number (a1) is repeated
anywhere else in the column it will repeat it as a unique number. If I
changed the data to say 1,2,2,3,3,2 the expected result is 1,2,3 and it
is.
Bug or approach or ?? TIA


I'm not sure about Excel 07, but perhaps the first line is being
interpreted as
a label, and not as part of the data.

In 03, the advanced filter depends that the first row be a row of labels.
--ron

I had tested this as well. First in a1 = "Label" a2:a7 = 1,2,3,1,2,3.
When I selected a2:a7 to filter, I got the same answer 1,2,3,1. When I
changed the List range to = a1:a7, I get the error msg "The extract range
has a missing or illegal field name"


In XL2003, you will get that message if there is no label, or if the label that
is present is not allowable to be used as a label (e.g. if the label were
something like F1).

The criteria range can be left blank
--ron