when field contains

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

Hi smart people -

I have a list I'm trying to wade through.

What I need is the command to countif whatever street name is in the field;
and I'm not looking for matches throughout the whole field, only where the
street name is contained in the field. Does that make sense?
Thanks!
Tammy
 
hi

Assuming streetname (criteria) to be searched is in cell C2 and the
range to be looked up is full column A, the following formula is
placed in cell D2:

COUNTIF(A:A,"*"&TEXT(C2,"general")&"*")

If street name is "pal", u may also use sthg like:

=COUNTIF(A:A,"*pal*")

But the first one is more flexible and recommended.

Let me know if this was found helpful.

Pal.
 
Back
Top