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