Re: Formula that recognizes duplicates

This solution does not allow me to check for existing numbers. Lets say that
I have a list of numbers but change a number somewhere near the top. Data
Validation does not check that number.

"JE McGimpsey" wrote:

> Take a look here:
>
> http://cpearson.com/excel/duplicat.htm
>
> and
>
> http://cpearson.com/excel/NoDupEntry.htm
>
>
> In article <2CF9490B-BADF-4C42-A4FB-66F93ABBE5B3@xxxxxxxxxxxxx>,
> "Courtneyf04" <Courtneyf04@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > I need a formula that tells me if there is a duplicate within the same
> > column. I have no idea how to go about this. I am wanting to enter in
> > Product ID numbers and if there is a duplciate I need to be warned. I would
> > appreciate any help anyone can give - Thanks!
>
.

Relevant Pages

  • Formula that recognizes duplicates
    ... I need a formula that tells me if there is a duplicate within the same ... I am wanting to enter in ... Product ID numbers and if there is a duplciate I need to be warned. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formula that recognizes duplicates
    ... > I need a formula that tells me if there is a duplicate within the same ... I am wanting to enter in ... > Product ID numbers and if there is a duplciate I need to be warned. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: read ahead or before
    ... Notice there is a duplicate "333". ... In minimalist awk format, that's ... $0!= Prev {print} ... Abbreviations for SI prefixes for units larger than kilo are all upper ...
    (comp.lang.awk)
  • Re: read ahead or before
    ... Notice there is a duplicate "333". ... In minimalist awk format, that's ... $0!= Prev {print} ... Abbreviations for SI prefixes for units larger than kilo are all upper ...
    (comp.lang.awk)
  • PvI TC 2006: T3 Selections
    ... there are good reasons for ... wanting to change your team. ... Vijay ... Prev by Date: ...
    (rec.sport.cricket)
Loading