Two columns, e-mail addresses

Giganews Newsgroups
Subject: Two columns, e-mail addresses
Posted by:  Bungers (bunge…@mailinator.com)
Date: Thu, 2 Oct 2003

Hi all...

I'm doing a datacleanse on our system, and I've got a
worksheet with two colums of e-mail addresses, both from
different sources. See below:

Column a              Column B
b…@mailinator.com    b…@mailinator.com
be…@mailinator.com  be…@mailinator.com

In row 2 the mail address is different. I need a formula
that I can type in Column C that will check that the data
is the same in both columns. The columns are formatted as
text. Please help!

Thanks, in advance.

Ben

Replies