I am trying to create a column (column C) that contains values only
when the cell contents of column A and the cell contents of column B
are EXACT matches.

The characters in BOTH columns contain names of companies so there are
both alpha and numeric values.

The first FIVE characters (including spaces) of each line already
match EXACTLY... see example below.

I want column C to show a value only when ALL of the characters in the
cell in column A match EXACTLY to all of the characters in the cell in
column B.

I am running excel 2007 but could run an older version if needed.
....

The first five characters of each line are EXACT but the characters
after character number 5 MAY not be exact.
i.e.
Column A: Column
B: Column C:
MICROSOFT.PUBLIC.EXCEL MICROSOFT.PUBLIC.WORD
Able Body Labor Able Real Estate Usa, Inc.
ABN AMRO Abn Amro Inc.
Integrity Windows and Doors Integrity Windows and Doors
Integrity Windows and Doors
Central DuPage Hospital Centron Industries Inc.

As you can see in this example the first five characters of each
column match, but the rest of the cell characters do not match so
there is not a value in Column C. Except for Integrity Windows and
Doors. The characters in the cell in column A match EXACTLY to the
characters in the cell in column B so there is now a value in Column
B. This is a COMPLETE and EXACT match.

I apologize for the length of this post and am open for clarification
question.
Thank you in advance.

On May 26, 6:56 am, GVinIL <gronent...@visanow.com> wrote:
> I am trying to create a column (column C) that contains values only
> when the cell contents of column A and the cell contents of column B
> are EXACT matches.
>
> The characters in BOTH columns contain names of companies so there are
> both alpha and numeric values.
>
> The first FIVE characters (including spaces) of each line already
> match EXACTLY... see example below.
>
> I want column C to show a value only when ALL of the characters in the
> cell in column A match EXACTLY to all of the characters in the cell in
> column B.
>
> I am running excel 2007 but could run an older version if needed.
> ...
>
> The first five characters of each line are EXACT but the characters
> after character number 5 MAY not be exact.
> i.e.
> Column A: Column
> B: Column C:
> MICROSOFT.PUBLIC.EXCEL MICROSOFT.PUBLIC.WORD
> Able Body Labor Able Real Estate Usa, Inc.
> ABN AMRO Abn Amro Inc.
> Integrity Windows and Doors Integrity Windows and Doors
> Integrity Windows and Doors
> Central DuPage Hospital Centron Industries Inc.
>
> As you can see in this example the first five characters of each
> column match, but the rest of the cell characters do not match so
> there is not a value in Column C. Except for Integrity Windows and
> Doors. The characters in the cell in column A match EXACTLY to the
> characters in the cell in column B so there is now a value in Column
> B. This is a COMPLETE and EXACT match.
>
> I apologize for the length of this post and am open for clarification
> question.
> Thank you in advance.

Further example:
Column A: Column B: Column C:
abc1234 abc1233
123ert 123ern
4 5ngw 4 5ngw 4 5ngw
hl8 gi hl8 xi
n82 ./! n82 ./! n82 ./!

Hope this clears things up a bit. The first example I gave was too
long for the site and wrapped the text,

On 26 May 2007 04:56:47 -0700, GVinIL <(E-Mail Removed)> wrote:

>I am trying to create a column (column C) that contains values only
>when the cell contents of column A and the cell contents of column B
>are EXACT matches.
>
>The characters in BOTH columns contain names of companies so there are
>both alpha and numeric values.
>
>The first FIVE characters (including spaces) of each line already
>match EXACTLY... see example below.
>
>I want column C to show a value only when ALL of the characters in the
>cell in column A match EXACTLY to all of the characters in the cell in
>column B.
>
>I am running excel 2007 but could run an older version if needed.
>...
>
>The first five characters of each line are EXACT but the characters
>after character number 5 MAY not be exact.
>i.e.
>Column A: Column
>B: Column C:
>MICROSOFT.PUBLIC.EXCEL MICROSOFT.PUBLIC.WORD
>Able Body Labor Able Real Estate Usa, Inc.
>ABN AMRO Abn Amro Inc.
>Integrity Windows and Doors Integrity Windows and Doors
>Integrity Windows and Doors
>Central DuPage Hospital Centron Industries Inc.
>
>As you can see in this example the first five characters of each
>column match, but the rest of the cell characters do not match so
>there is not a value in Column C. Except for Integrity Windows and
>Doors. The characters in the cell in column A match EXACTLY to the
>characters in the cell in column B so there is now a value in Column
>B. This is a COMPLETE and EXACT match.
>
>I apologize for the length of this post and am open for clarification
>question.
>Thank you in advance.


=IF(EXACT(A2,B2),A2,"")


--ron

On May 26, 7:13 am, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
> On 26 May 2007 04:56:47 -0700, GVinIL <gronent...@visanow.com> wrote:
>
>
>
>
>
> >I am trying to create a column (column C) that contains values only
> >when the cell contents of column A and the cell contents of column B
> >are EXACT matches.
>
> >The characters in BOTH columns contain names of companies so there are
> >both alpha and numeric values.
>
> >The first FIVE characters (including spaces) of each line already
> >match EXACTLY... see example below.
>
> >I want column C to show a value only when ALL of the characters in the
> >cell in column A match EXACTLY to all of the characters in the cell in
> >column B.
>
> >I am running excel 2007 but could run an older version if needed.
> >...
>
> >The first five characters of each line are EXACT but the characters
> >after character number 5 MAY not be exact.
> >i.e.
> >Column A: Column
> >B: Column C:
> >MICROSOFT.PUBLIC.EXCEL MICROSOFT.PUBLIC.WORD
> >Able Body Labor Able Real Estate Usa, Inc.
> >ABN AMRO Abn Amro Inc.
> >Integrity Windows and Doors Integrity Windows and Doors
> >Integrity Windows and Doors
> >Central DuPage Hospital Centron Industries Inc.
>
> >As you can see in this example the first five characters of each
> >column match, but the rest of the cell characters do not match so
> >there is not a value in Column C. Except for Integrity Windows and
> >Doors. The characters in the cell in column A match EXACTLY to the
> >characters in the cell in column B so there is now a value in Column
> >B. This is a COMPLETE and EXACT match.
>
> >I apologize for the length of this post and am open for clarification
> >question.
> >Thank you in advance.
>
> =IF(EXACT(A2,B2),A2,"")
>
> --ron- Hide quoted text -
>
> - Show quoted text -

i'll be darned! It worked! Thank you!

On 26 May 2007 11:17:44 -0700, GVinIL <(E-Mail Removed)> wrote:


>
>i'll be darned! It worked! Thank you!

You're welcome. Glad to help.

One caveat: EXACT means exactly that. =EXACT("A","a") --> FALSE

If you want your comparison to be case-INsensitive, then use something like:

EXACT(UPPER(A1),UPPER(B1))


--ron

or just
=a1=b1

Ron Rosenfeld wrote:
>
> On 26 May 2007 11:17:44 -0700, GVinIL <(E-Mail Removed)> wrote:
>
> >
> >i'll be darned! It worked! Thank you!
>
> You're welcome. Glad to help.
>
> One caveat: EXACT means exactly that. =EXACT("A","a") --> FALSE
>
> If you want your comparison to be case-INsensitive, then use something like:
>
> EXACT(UPPER(A1),UPPER(B1))
>
> --ron

--

Dave Peterson

On Sat, 26 May 2007 14:04:32 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>or just
>=a1=b1

Simpler wins, in my book :-))
--ron

Ron Rosenfeld wrote:

> On Sat, 26 May 2007 14:04:32 -0500, Dave Peterson <(E-Mail Removed)>
> wrote:
>
>
>>or just
>>=a1=b1
>
>
> Simpler wins, in my book :-))
> --ron

We say "elegant solution"! ;-)