Compare two text files
 

open them both in excel

use a formula like

In B1 of text1
=countif([text2.txt]Text2!A:A,A1)

drag fill down the column

in B1 of Text2
=countif([text1.txt]Text1!A:A,A1)

drag fill down the column

formulas that produce zero are the rows you want.

--
Regards,
Tom Ogilvy

"LostinTransportation"
wrote in message ...
Have two text files that contain one column of one word names. Need to
find
the easiest way for a non-technical end-user to compare the two reports
and
find exceptions (i.e. any items that are on list A and not on list B, or
any
items that are on list B and not on list A).
--
TIA!