Re: Simple Formula?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <aristotle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D33A137E-0486-495A-B32C-D9E27B05124B@xxxxxxxxxxxxxxxx
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?action=getinfo&userid=22499
> View this thread: http://www.excelforum.com/showthread.php?threadid=394615
>
>


.

Quantcast