|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?