RE: finding differences in a list of amounts

["Bryon Cook" <bryonc@xxxxxxxxxxx>]

Couldn't you just export your physical file to another excel spreadsheet
then sort both the lists (if you can get to the detail info on her list) by
amount, copy the data into one spreadsheet, create a formula & copy it down
the column, to show the difference?  

IE: In cell C1 =A1-B1, anything <> 0 is bad. 

Or you could do an 'if' test:

In cell C1 =IF(A1=B1,TRUE,FALSE) and a result of FALSE would show you the
bad data.

There are a lot of steps but it is easier than manually reading all the data
to check for discrepancies. 

Don't know if this helps but I hope so.  Good Luck!
-Bryon

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Bale
Sent: Friday, September 17, 2004 2:24 PM
To: midrange-l@xxxxxxxxxxxx
Subject: finding differences in a list of amounts

(Cross posting to midrange-l, rpg400-l)

Anybody know of a solution for this?

I have a user that tells me that a report she is getting has the wrong total
amount.  The report shows the detail (a lot of it) but her total that she
keeps track of in a spreadsheet is different from the report's.  Her
spreadsheet doesn't have the detail.  Here's what I have:

$384,582.91 = the report total
$371,448.26 = the user's total
-----------
$ 13,134.65 = difference

Unfortunately, I do not have a single amount of 13,134.65 in my detail.  So,
I must have multiple amounts that total to 13,134.65.

The solution I am looking for is to be able to try all the combinations in
the detail to see what turns up equal to a given total amount.  For example,
if I have the following detail:
     185.69
  11,134.60
     500.03
   4,841.65
   1,500.02
     419.85
etc.
A good tool would be able to find that the 2nd, 3rd, and 5th amounts add up
to the total amount I'm looking for.

Does Excel have a function for something like this?  Or is there to do it on
the 400?  SQL functions?

tia,
db

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.