Match formula

[Whitney]

I have a spreadsheet with 4 columns, each with a list of names. The names are
mostly the same, from 4 different resources, but some are mispelled. I would
like the 5th column to say True/False or Y/N if any of the names in a row
do/do not match, assuming blank cells as a match.

Ex.
DB Cisco Attendance Outlook Match?
Amy Smart Amy Smart Amy Smart Amy Smart Y or True
Bob Smith Bib Smith Bob Smith Bob Smith N or False

 

[Pete_UK]

Try this in E2:

=AND(A2=B2,B2=C2,C2=D2,A2<>"")

and copy down as far as you need. This will return TRUE or FALSE, as
appropriate.

Hope this helps.

Pete

 

[Dave Peterson]

If you never have any missing cells (or want to count the missing data as a
mismatch):

=COUNTIF(A22,A2)=4

If the missing data should be ignored:

=COUNTIF(A22,A2)=COUNTA(A22)