How do I compare two columns of text data that are not exact

[Guest]

I need to do a gap analysis on 2 sets of data attributes (text). Each list
(column) contains hundreds of attributes that I want Excel to sort through
and compare, identify the attributes that are an exact match and also
identify the attributes that may contain similar words.

Nate Perryman

 

[Guest]

You're not giving us much info.

=A1=A2 will return true/false (not case sensitive)
=EXACT(A1,A2) return true/false (case sensitive)

SEARCH & FIND return the number of the character at which a specific
character or text string is first found. (They locate text within text.)
SEARCH is not case sensitive, FIND is case sensitive.

MATCH Returns the relative position of an item in an array.