Chip Pearson has some formulas and methods to flag duplicates.
http://www.cpearson.com/excel/Duplicates.aspx
See also at the bootom of the page about "preventing duplicates"
Gord Dibben MS Excel MVP
On Fri, 15 Feb 2008 20:05:31 -0500, "Robert11" <(E-Mail Removed)> wrote:
>Hello:
>
>Anyone have a link to a simple add-on that I can use to determine (easily)
>if any numbers in a column are duplicates ?
>
>Would like the duplicate numbers to be flagged as such; perhaps brought out
>to a separate listing, or...
>
>Thanks,
>Bob
>