George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column C
starting with row 2 and going down the page. I went into column D2 and typed
the formula changing the A's to C's. But how do I copy this formula into my
numbers in the previous column?
Thanks,
kbkst

George Gee wrote:
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

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
[quoted text clipped - 9 lines]
Hope someone can help.
kbkst

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