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
|