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