Help with a formula please
 

I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks

=COUNTIF(A:A,"the text")

--
HTH

Bob Phillips

"Matt Stone" wrote in message
...
I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks

hi matt,
try this...

=countif(A1:A50000,"yourtext")

works in xl2k. lookup countif in xl help.
Adjust the formula to fit your data.

regards

FSt1

"Matt Stone" wrote:

I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks

If in Range a1:a100 you say have abc appearing 5 times
Try in cell C1 =Countif(A1:A100,D1)
where A1:A100 is all your text
Enter into D1 abc
C1 should bring back 5


"Matt Stone" wrote in message
...
I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks

Assuming your data is in column A from cell A1 downwards,

in B1 enter

=IF(COUNTIF(A$1:A$8,A1)2,"More than two "&A1,"")

using CTRL/Shift/Enter to enter an array formula, then formula-drag
this to the bottom of your data.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390147

With your given data in A1:A11 in cell B1 enter:
=COUNTIF($A$1:$A$11,A1)
and Copy (B1) down to B11.
Note amts greater than 1 !!



"Matt Stone" wrote in message
...
Perhaps I did not explain it right. I have a column of different text of
which contain 3 characters (Approx 11 rows). I need to make sure that of
these none of them appear more than two times:

Example.

Column A
che
man
ars
mcy
eve
asv
ars
bir
whu
wba
liv

I need a sum to make sure the above text does not appear more than twice.
Bearing in mind I have multiple columns with different text in each.

Thanks

"Jim May" wrote in message
news:JWoFe.92$MZ6.55@lakeread01...
If in Range a1:a100 you say have abc appearing 5 times
Try in cell C1 =Countif(A1:A100,D1)
where A1:A100 is all your text
Enter into D1 abc
C1 should bring back 5


"Matt Stone" wrote in message
...
I need to count a number of text cells to find out if an exact same
occurance occurs more than twice.
I Use Excel 2003

Any ideas

Thanks