Hi,

I have the following table:

A B C
1 Code Date Amount
2 A6 XXX XXX
3 A6
4 B7
5 B7
6 K4
7 K4
250 Z6

252 Code

256 Code
A6
B7

I would like to filter table $A$1:$C$250 where the Code in column A is unique.

I go to Data Filter Advance Filter , highlight the table as my first
parameter, than set criteria of filtering ias A252 (Code), choose copy the
filtered data to A 260, check at Unique data and click OK. I tried that many
times however it does not work. Neither it works if if I first filter unique
codes to A256 and use it a a criteria for filtering. May I know the correct
way of getting what I wish ?

Thanks

Low
--
A36B58K641