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