Assuming all your phone numbers are in column A:
In a blank column:
=IF(MAX(COUNTIF(A:A,A:A))1,"Duplicate","Non Duplicate")
Copy this formula down the column.
If you need more help with this, post back.

George Gee

"kbkst via OfficeKB.com" <u18755@uwe wrote in message
news:5bfb1768fac9c@uwe...
I am doing a copy and paste with phone numbers on my spreadsheet. I then
manually have to search for duplicates. I there a way that excel can do
that
for me?

Also, When I copy phone numbers, I must copy one number, go to
spreadsheet
and paste. Back & forth. Is there a way to highlight and copy all of the
numbers I need on the page in one shot and then paste to my spreadsheet?
Can't scroll down because they are far apart from eachother.

Hope someone can help.
kbkst

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200602/1