Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Data Comparison (Excel 97)

    Hi bootz47. It's hard to give you useful advice because the answer could depend on the layout of your workbook and so forth. If you could attach a censored sample of your WB (i.e. with customers named Micky Mouse, Donald Duck, etc. and bogus amounts) to your post, perhaps we can be more helpful. I can speculate that you can use one of the LOOKUP(,,) or MATCH() functions to compare paid to billed, but that's as far as I can get.
    -John ... I float in liquid gardens
    UTC -7ąDS

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Data Comparison (Excel 97)

    Is "Customer ID & Date" the equivalent to an invoice number or is there a separate invoice number? Do you want to handle payments (and consequently underpayments) on an invoice specific basis, or an all-invoice cumulative basis where any payment is applied to the earliest unpaid invoice?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Comparison (Excel 97)

    I am working with a spreadsheet Invoice and comparing it to payment I need to match customer information to both and subtract the Invoice amount from the payment amount giving me the total paid in addition if the client did not pay for something on the invoice I need to include that in the summary.
    On summary I needit to say 400.00 owed for Mickey 350.00 Owed for Donald 800.00 Owed for Daisy and
    Minnie 200.00 owed for Feb and (200.00) January. It is a customer identification there is a separate invoice number for each customer.

Posting Permissions

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