+ Reply to Thread
Results 1 to 2 of 2

To find exact invoices from list that matches receipt amount.

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    pune ,india
    MS-Off Ver
    Excel 2007
    Posts
    16

    To find exact invoices from list that matches receipt amount.

    Hi,

    We have supplied material to one of our customer , details of Invoices are as below,

    INVOICE NO AMOUNT
    PTP45801 286,978.66
    PTP45753 653,391.70
    PTP45754 132,385.16
    PTP45469 163,511.45
    PTP45470 162,443.62
    PTP45471 249,908.94
    PTP45742 128,218.78
    PTP45743 654,864.16
    PTP45752 327,289.85
    PTP45755 242,887.11
    PTP45800 648,262.09
    PTP45802 281,682.79
    PTP45803 249,908.94

    Now Customer had made payment of Rs 3111938.88/-

    We would like to settle above amount from invoices given in above list , customer had not given Invoice no.

    can any budy help how to find Invoices that exact matches with receipt amount.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: To find exact invoices from list that matches receipt amount.

    Look at this link for how to use the built in Solver for this situation

    http://www.get-digital-help.com/2010...lver-in-excel/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-06-2015, 09:15 PM
  2. [SOLVED] Find Exact matches on 2 sheets and export results to 3rd Sheet
    By gadrummer65 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-27-2014, 01:41 PM
  3. Need Macro to find match for invoices. With the Amount
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-22-2012, 08:03 AM
  4. Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  5. Replies: 4
    Last Post: 03-17-2010, 11:10 AM
  6. Function to find only exact matches in spreadsheets?
    By Pam1288 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2006, 02:25 PM
  7. Use of the DSUM formula to find exact matches in datatables
    By Rob Henson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 11:06 PM

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