Prev: Excel columns are now numbered instead of lettered
Next: Printer Using USB Port Slows Page Setup
From: Whitney on 21 Apr 2010 19:06
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
From: Pete_UK on 21 Apr 2010 19:17
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

On Apr 22, 12:06 am, Whitney <Whit...(a)discussions.microsoft.com>
wrote:
> 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

From: Dave Peterson on 21 Apr 2010 19:21
If you never have any missing cells (or want to count the missing data as a
mismatch):

=COUNTIF(A2:D2,A2)=4

If the missing data should be ignored:

=COUNTIF(A2:D2,A2)=COUNTA(A2:D2)



Whitney wrote:
>
> 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

--

Dave Peterson
 | 
Pages: 1
Prev: Excel columns are now numbered instead of lettered
Next: Printer Using USB Port Slows Page Setup