I have names of people in one Excel column and next to it, a column named "Notes." The notes contain something like "Phone checked out to XXX" or "Phone owned by XXX", etc. I would like to count all the names of the people that have "checkout" in their "notes" column. I tried to do a combination of the Count and If functions, to no avail.
I would appreciate your help in solving this issue.
Great suggestion in the right direction! This returns, however, every person whose notes contain any character of the word "checkout".... is there any way to make it only return those people that have the whole word "checkout" in their notes column?
hmmm something is not working. the exact field i'm looking at (column name) is "Billing Title" so i changed the formula to this and changed match to mixmatch because the the formula needs to NOT be case sensitive --