M
Mr. Low
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
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