How can I find the same numbers in whole sheet and delete them

G

ghost

Hi,
I have two rows with many numbers
What I want is how can make a command or something like that to find the
same numbers and delete them.
Your help is highly appreciated
 
G

ghost

Hi
I am still facing a problem with the formula
Can you clarify more please?
The problem with the "Range1"
=IF(COUNTIF(Range1, A5)>1,TRUE,FALSE)
 
L

L. Howard Kittle

Perhaps you can change the formula to something like this.

=IF(COUNTIF(Range1, A5)>1,"Duplicate","")

Enter and fill down as far as your number list goes. You will Duplicate in
the cell or nothing.
If you leave the formula unchanged and fill, each TRUE represents a
duplicate, and each FALSE indicates a unique number.

HTH
Regards,
Howard
 
Top