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

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

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

see:

http://www.cpearson.com/excel/duplicat.htm#Replacing
--
Gary''s Student
gsnu200703


"ghost" wrote:

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

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

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)


"Gary''s Student" wrote:

see:

http://www.cpearson.com/excel/duplicat.htm#Replacing
--
Gary''s Student
gsnu200703


"ghost" wrote:

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

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

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


"ghost" wrote in message
...
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)


"Gary''s Student" wrote:

see:

http://www.cpearson.com/excel/duplicat.htm#Replacing
--
Gary''s Student
gsnu200703


"ghost" wrote:

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