how can i find samelest number and delete them

G

ghost

hi,
i have multi rows with numbers, what i need is to compare between them and
the same numbers will be deleted
thx.
 
B

Bernard Liengme

Suppose you numbers are in A1:C20
In E1 enter =IF(COUNTIF($A$1:$C$20,A1)>1,A1,"")
Copy this across to G1 and then copy E1:G1 down to row 20
If a number in A1:C20 is unique the corresponding cell in E1:G20 will be
blank, otherwise it will display the number
Something to get started with?
best wishes
 
G

ghost

hi,
i did it but there is nonthing change
should i change any name of the cells in the funcetion
IF(COUNTIF($A$1:$C$20,A1)>1,A1,"")
 
Top