RE: Simple Formula?
- From: aristotle <aristotle@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Aug 2005 08:29:41 -0700
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
>
>
.
- Follow-Ups:
- Re: Simple Formula?
- From: RagDyeR
- Re: Simple Formula?
- References:
- Simple Formula?
- From: pauldaddyadams
- Simple Formula?
- Prev by Date: Re: How do you ignore hidden rows in a countif() function
- Next by Date: Re: Adding numbers to several cells at one time
- Previous by thread: Simple Formula?
- Next by thread: Re: Simple Formula?
- Index(es):
Relevant Pages
|
