Hmmm. Don't think that works, either
Maybe:
=IF(COUNTIF($A$20:A2,A2)>2,"Dup","Ok")
"RagDyeR" wrote:
> Believe you have a typo?!?!
>
> =IF(COUNTIF($A$2:A2,A2)>2,"Dup","Ok")
>
> --
>
> Regards,
>
> RD
> ----------------------------------------------------------------------------
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> ----------------------------------------------------------------------------
> -------------------
>
> "aristotle" <[email protected]> wrote in message
> news:[email protected]...
> Hi,
>
> Assume the entries are within A2:A20
>
> e.g. B2=IF(COUNTIF($A$2:A2,A2)>1,"Dup","Ok")
> and copy down to B20
>
> Regards,
> A
>
> "pauldaddyadams" wrote:
>
> >
> > Hi,
> >
> > I have a problem which I need someone to look at. I have a list of 11
> > teams and I need a formula to check the data and for it to identify an
> > error message if more than two of the same teams are listed.
> >
> > e.g.
> > Arsenal
> > Aston Villa
> > Liverpool
> > Chelsea
> > Arsenal
> > Wigan
> > West Brom
> > Arsenal
> > Arsenal
> > Birmingham
> > Liverpool
> >
> > I would need a cell to highlight the error that there are two many
> > arsenal entries as only two are allowed
> >
> > Can anyone help?
> >
> > Regards
> >
> > Paul
> >
> >
> > --
> > pauldaddyadams
> > ------------------------------------------------------------------------
> > pauldaddyadams's Profile:
> http://www.excelforum.com/member.php...o&userid=22499
> > View this thread: http://www.excelforum.com/showthread...hreadid=394615
> >
> >
>
>
>
Bookmarks