The Column E formula counts the number of times each cell in Column D (b) appears in
Column C (a).
A count of 0 indicates no match. So you have...
ColumnA and ColumnB unchanged and a new column that flags mismatches with a zero.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles: lists or removes unused styles & number formats - in the free folder)
"GARY" <
[email protected]>
wrote in message
Oops! Col A has 4,841 cells so I changed your formula for Col D
accordingly.
In Col C, I pasted =LEFT(A1,19) in C1 thru C4841
In Col D, I pasted =LEFT(B1,19) in D1 thru D18513
In Col E, I pasted =COUNTIF($C$1:$C$4841,D1) in E1 thru E18513
After completing your instructions, how do I interpret the results?
Also, only the first 19 characters of each cell is displayed; I need
all of the characters displayed.