|Subject:||Re: Comparing columns for duplicates/differences|
|Posted by:||DavidP (d.pro…@ntlworld.com)|
|Date:||Tue, 21 Oct 2003|
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
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
(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
On Tue, 21 Oct 2003 11:23:06 -0700, "Jan C." <ja…@fallonagency.com>
>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?
Comparing columns for duplicates/differences posted by Jan C on Tue, 21 Oct 2003