Hi
I have 2 colums of excel data with computer network names in both.
Most entries appear in both columns but I would like do some sort of
comparison which finds and stores unique entries in both columns, in a
separate column.

Can anyone help me do this please. See sample below, the original has
about 3000 rows

Thanks in advance

Rhett

Machines1 Machines2
1ZL6J1S 16MNL1S
2KRMB1S 465WK1S
2KZ2L1S 474JK1S
5T5ML1S 55L2L1S
6BTML1S 5T5ML1S
6T5ML1S 5WD2L1S
84XQK1S 6BTML1S
85YNN1S 6T5ML1S
8FJGM1S 84XQK1S
9N57L1S 85YNN1S
ABADMIN02 89STL1S
ANTISTHENES 8WD2L1S
ARETHUSA 9WD2L1S
ASTRAEA ADTECH-STUD6
BAGHEERA ARETHUSA
BBTML1S ASTRAEA
BN57L1S BBTML1S
BRICKONE BILLS-D-NOTE
CBL7CPJJ1S BOB-JONES
CCT-108001 BRF-37265
CCT-108002 CAD10
CCT-108003 CAD11
CCT-108004 CADFIVE
CCT-108005 CAV-G19001
CCT-108006 CAV-G19A001
CCT-108007 CBB110-8RR1P1S
CCT-108008 CBB129A-FPB1P1S
CCT-108009 CBS-CHUTE
CCT-108010 CCALTIRIS
CCT-108011 CCH335C-BWWYN1S
CCT-108012 CCH344-JFZKN1S
CCT-108013 CCT-108001
CCT-108014 CCT-108002
CCT-108015 CCT-108003
CCT-108016 CCT-108005
CCT-108017 CCT-108006
CCT-108018 CCT-108007
CCT-108019 CCT-108008
CCT-108020 CCT-108009
CCT-109001 CCT-108010
CCT-109002 CCT-108011
CCT-109003 CCT-108012
CCT-109004 CCT-108013
CCT-109005 CCT-108014
CCT-109006 CCT-108015
CCT-109007 CCT-108016
CCT-109008 CCT-108017
CCT-109009 CCT-108018
CCT-109010 CCT-108019
CCT-109011 CCT-108020
CCT-109012 CCT-109001
CCT-109013 CCT-109002
CCT-109014 CCT-109003

Hi Rhetto,

See Chip Pearson at:

Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm#

See particularly the sections entitled:

Extracting Unique Entries

and

Extracting Values On One List And Not Another



---
Regards,
Norman




wrote in message
ups.com...
Hi
I have 2 colums of excel data with computer network names in both.
Most entries appear in both columns but I would like do some sort of
comparison which finds and stores unique entries in both columns, in a
separate column.

Can anyone help me do this please. See sample below, the original has
about 3000 rows

Thanks in advance

Rhett

Machines1 Machines2
1ZL6J1S 16MNL1S
2KRMB1S 465WK1S
2KZ2L1S 474JK1S
5T5ML1S 55L2L1S
6BTML1S 5T5ML1S
6T5ML1S 5WD2L1S
84XQK1S 6BTML1S
85YNN1S 6T5ML1S
8FJGM1S 84XQK1S
9N57L1S 85YNN1S
ABADMIN02 89STL1S
ANTISTHENES 8WD2L1S
ARETHUSA 9WD2L1S
ASTRAEA ADTECH-STUD6
BAGHEERA ARETHUSA
BBTML1S ASTRAEA
BN57L1S BBTML1S
BRICKONE BILLS-D-NOTE
CBL7CPJJ1S BOB-JONES
CCT-108001 BRF-37265
CCT-108002 CAD10
CCT-108003 CAD11
CCT-108004 CADFIVE
CCT-108005 CAV-G19001
CCT-108006 CAV-G19A001
CCT-108007 CBB110-8RR1P1S
CCT-108008 CBB129A-FPB1P1S
CCT-108009 CBS-CHUTE
CCT-108010 CCALTIRIS
CCT-108011 CCH335C-BWWYN1S
CCT-108012 CCH344-JFZKN1S
CCT-108013 CCT-108001
CCT-108014 CCT-108002
CCT-108015 CCT-108003
CCT-108016 CCT-108005
CCT-108017 CCT-108006
CCT-108018 CCT-108007
CCT-108019 CCT-108008
CCT-108020 CCT-108009
CCT-109001 CCT-108010
CCT-109002 CCT-108011
CCT-109003 CCT-108012
CCT-109004 CCT-108013
CCT-109005 CCT-108014
CCT-109006 CCT-108015
CCT-109007 CCT-108016
CCT-109008 CCT-108017
CCT-109009 CCT-108018
CCT-109010 CCT-108019
CCT-109011 CCT-108020
CCT-109012 CCT-109001
CCT-109013 CCT-109002
CCT-109014 CCT-109003