Two columns, e-mail addresses

B

Bungers

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
[email protected] [email protected]
[email protected] [email protected]

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
 
T

Tim Brouwers

quite simple,
sugest that column C shows 'TRUE' when addresses are the
same and 'FALSE' when they are not the same.
type the following in C1: =if(a1=b1,TRUE,FALSE)
 
B

bungers

Thanks Tim, much appreciated!
-----Original Message-----
quite simple,
sugest that column C shows 'TRUE' when addresses are the
same and 'FALSE' when they are not the same.
type the following in C1: =if(a1=b1,TRUE,FALSE)
.
Click to expand...
 
R

RagDyer

Little shorter:

=A1=B1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Thanks Tim, much appreciated!
 
Top