Two columns, e-mail addresses

  • Thread starter Thread starter Bungers
  • Start date Start date
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
(e-mail address removed) (e-mail address removed)
(e-mail address removed) (e-mail address removed)

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
 
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)
 
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...
 
Little shorter:

=A1=B1
--

HTH,

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

Thanks Tim, much appreciated!
 
Back
Top