Comparing columns for duplicates/differences

  • Thread starter Thread starter Jan C.
  • Start date Start date
J

Jan C.

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?
 
I suspect that 1 of your columns is in as text even though it looks
like numbers. probably the imported AS400 info. Various ways to
ensure that all are true numbers. Try this one provided by Steve
Aprahamian

Simple four click solution:
The simple four click solution below will change the format from a
"text string" to a "value" which can be sorted..

(1) Left click the column header to highlight the entire column.
(2) Left click the "Data" menu, across the top, so it drops down.
(3) Left click "Text To Columns" on the "Data" menu which dropped
down.
(4) Left click the "Finish Button" on the bottom right of the window.

After these four clicks, it may appear as if nothing has changed, but
behind the Excel scenes the data has been changed from "text strings"
to "values", which makes them sort properly. There are several ways
to convert "text strings" into "values" but this is the quickest and
easiest.
 
Back
Top