Thanks Dave,

How could I do it Using a Macro as well Please.

Thanks in Advance.
All the Best.
Paul

Dave Peterson wrote:
> =IF(COUNTA(A1:A200)=SUMPRODUCT((A1:A200<>"")/COUNTIF(A1:A200,A1:A200&"")),
> "all the same","not all the same")
>
>
> =SUMPRODUCT((A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))
> will give the count of unique items
>
> =count(a1:a200) will count the number of numbers.
>
> Paul Black wrote:
> >
> > Hi Everyone,
> >
> > I have a Column where Numbers are Entered. There can be from 5 Numbers
> > to 200 or so Numbers. What I would like is to Check that there is NO
> > Duplicates in the Column Please.
> >
> > Thanks in Advance.
> > All the Best.
> > Paul
>
> --
>
> Dave Peterson