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