+ Reply to Thread
Results 1 to 2 of 2

Finding what numbers equal another number

  1. #1
    Registered User
    Join Date
    06-26-2008
    Location
    Denver
    Posts
    1

    Finding what numbers equal another number

    Alright, so here is a question that has been nagging me for some time now:

    Is there a way in excel to find what combination of numbers in a list equals a preset number.

    Example: I have $575,000 in sales from one system but only $565,000 is showing up in another system. I am trying to find out which sales transactions are missing. I want to know what combination of the sales transactions could total this variance exactly. The issue is I do not know if it is a single transaction (of course i can eyeball this) or even 23 or 33 transactions.

    I would expect that more than one answer to occur based on the data but at least this would narrow down the possible errors....

    any help would be appreciated

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    Suppose the sales data from 1st system has 2 filed sales_id and amount and sales data from 2nd system also has 2 fileds sales_id and amount.

    Copy the data from first system in new sheet at column A and B. Copy the data from second system at column C and D.

    Now..... in column F2 type "=B2<>D2"

    Now apply Advance Filter..

    Put the cursor anywhere in the data.
    click on data--> Filter --> Advance Filter.
    For Criteria field select "F1:F2".

    Click ok..............

    It will filter out all the row where sales amount from first system is not matching the sales amount from second system...


    Hope this will help you....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1