Comparing columns for duplicates/differences

Giganews Newsgroups
Subject: Comparing columns for duplicates/differences
Posted by:  Jan C (ja…@fallonagency.com)
Date: Tue, 21 Oct 2003

I have a spreadsheet that contains 2 columns of
information containing numbers.  It was created by the
query function from my AS400, saved in an excel
spreadsheet, sent to a 3rd party for verification and then
returned in a comma delimited format with the updated
information (the first column being the info I provided,
the second being the info that was returned). I then saved
the worksheet in an excel format before running the test.
I've tried comparing the information for discrepancies
using the 'Worksheet Formula' method without success.  I
have also determined that if I enter the information
manually and then use the formula, it works.  What am I
missing?  Is there another way to compare the data?

Replies