CODEWITHSUNDEEP
excel
vajredwards
vajredwards

Reputation: 1

In Excel, comparing a cell with text to see if it is contained in any cells of another column of text.

I have one column that has the first and last name of subscribers and a second column that just has the last name of the subscribers. I need to see if the last name in the second column is contained in any of the names in column 1. Is this possible in Excel?

Upvotes: 0

Views: 53

Answers (1)

Phylogenesis
Phylogenesis

Reputation: 7890

If the list of full names is in column A (in a firstname surname format) and the name you're checking is in cell B1, then you can use the formula:

=COUNTIF(A:A,"* "&B1)

Upvotes: 2

Related Questions