How can I make an Array Formula search for a word in a cell
Posted by Jim Rickel on March 29, 2000 4:08 PM
Howdy Everyone
I have an Array Formula. I want it to look for a particular word in a cell, rather than selecting the entire contents of the cell. The E column of the Outlook sheet contains multiple single word states. One of those states is "note". I want to find the word "note" regardless of it's position in the cell and count that occurance. Is there a way to do this?
Where is my Formula , thanks to Mr. Excel for alot of help with it.
=SUM(IF(Outlook!$C$2:$C$6=$C2,IF(Outlook!$E$2:$E$6=E$2,1,0),0))
Thanks
jim
jrickel@fusionone.com