help: filter by repeated code ??

[emadtira]

i have column contain codes and i want to make filter that show repeated codes only

for ex.

column A
Code
cc01
cc02
cc05
cc09
cc09
cc04
cc03
cc08
cc08
cc06

i want to filer to show only cc09 & cc08 that are repeated.

thankyou

 

[venkat1926]

suppose your data is from A1 to A11 in a sheet
in B2 copy this formula

=IF(COUNTIF(A2:$A$11,A2)>1,A2,"")

copy B2 down and see what you get