Matching Two Text Strings to see if Like

[Guest]

Hope this will be my last time to have to ask a question of you experts.

I have an individual name that I am trying to see if it is in a particular
column, if it is then just put a one, or what ever number of times it
appears. Sometimes there are two columns that I need to check if the name
appears, and then just add up all of the occurrences.

Example:

A B C D E
1. T. Bodie J. Lang None
2. T. O'Connell T. Bodie T. Spurgeon
3. M. Lalonde N. Martz
4. T. Spurgeon B. Geisler J. Lang
5. S. Slonina T. O'Connell B. Hodge

So what I want to do is see how many times say a J. Lang appears. And put
this number in a different spot on my spreadsheet.

Any help,

Thanks

Steve

 

[Guest]

Hi,

Try using countif(A:A,"J. Lang")

 

[Guest]

Another thought ..

Assuming the source range is A1:E5

Try in say, F1:
=SUMPRODUCT(--ISNUMBER(MATCH(A1:E5,{"J. Lang"},0)))

Or, pointing to an input cell for the name, say in G1: J. Lang
=SUMPRODUCT(--ISNUMBER(MATCH(A1:E5,G1,0)))

 

[Max]

Again as usual you guys come through.
thanks works just great.

Good to hear that, Steve ..

---