I have three columns with entries like below. Column B (Courtview
(Original)) is hidden from view in my final version. Column A has the
following formula so that I can compare Column A to Column C.
The formula is: =LEFT(B2,4)&MID(B2,6,2)&RIGHT(B2,6)
This produces the FIle Numbers without any spaces. (The entries originate
from two different programs, thus the slightly different formats) Using
conditional formatting each entry that appears in Column A but not in Column
C is highlighted in color, and visa versa. (I have placed some brackets
around a few entries to indicate a highlighted or colored entry) I have
4,601 entries in column A and 2,367 in column C.


COURTVIEW COURTVIEW (Original) TRACKMAN
[1988MM000449] 1988 MM 000449 1994MM000614
1994MM000614 1994 MM 000614 1995MM002194
[1995MM000984] 1995 MM 000984 1995MM002194
1995MM002194 1995 MM 002194 1995MM002194
1995MM002459 1995 MM 002459 [1995MM0021940]
1995MM002653 1995 MM 002653 [1995MM0021940]


What I would like to accomplish now is a seperate list (It could be anywhere
- a seperate column, Worksheet, workbook, doesn't matter) of the unique
entries. However, everything that I have tried will not put the unique
entries at the top of any columns due to the formula in Column A. The
desired result would look like this:

COURTVIEW TRACKMAN
[1988MM000449] [1995MM0021940]
[1995MM000984] [1995MM0021940]

When I try I get:

COURTVIEW TRACKMAN
[1988MM000449]

[1995MM000984]

[1995MM0021940]
[1995MM0021940]

Thank you for any help.

Tim James

P.S. Special thanks to Bob Phillips & David Biddulph for their help on an
earlier question. They provided great answers! Kudos guys!