View Full Version : Solved: Counting Substring Presence in Range
flea333
08-25-2010, 12:16 PM
I want to count how many cells contain a substring in a range using a worksheet cell function. I know countif, mid, etc but I don't know how to use mid in countif.
Bob Phillips
08-25-2010, 01:16 PM
TRy
=COUNTIF(the_range,"*data*")
flea333
08-25-2010, 01:22 PM
duh, I forgot about that.
Thanks!
flea333
09-02-2010, 05:44 PM
Actually, the problem is that I am referencing another cell for the data and it isn't a hard string. So I tried A12&"*" but that doesn't seem to work.
Problem is that I have a name, ie Smith, John, however my list I'm searching for may or may not have a status appended to the name, ie "Smith, John (note)". I need to ignore the "(note)" part of just find the Smith, John part.
Bob Phillips
09-03-2010, 01:04 AM
That should work
=COUNTIF(the_range,A12&"*")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.