+ Reply to Thread
Results 1 to 2 of 2

Find payment documents and payment amounts

Hybrid View

  1. #1
    Registered User
    Join Date
    07-22-2023
    Location
    Vietnam
    MS-Off Ver
    2019
    Posts
    17

    Find payment documents and payment amounts

    I have 2 sheets, one sheet is generated by the software, the other sheet is the result (I need to install the formula for the input list file).
    In the software sheet, column C is the VAT invoice number, column E is the number of documents created, column K is the total amount paid by the customer including VAT.
    In the results sheet, I have the VAT invoice number in column B, column T is the number of documents created
    I need to find the formula in column S and column U in the KQ sheet. Among Column U is equal to Sum from S4:S17 = 319,341,579, equal to cell J4 of the phan mem do ra sheet.
    Meaning find the cells and combine them in the KQ sheet to match the payment from the phan mem do ra sheet?
    Hope you can help
    Attached Files Attached Files
    Last edited by Hongnhung88; 10-10-2023 at 05:09 AM. Reason: add the figure

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Find payment documents and payment amounts

    If you CONSOLIDATE both sets of data, this will help match up the Single-invoice matchings. The multiple invoice may be more involved.
    if you use: Data/Consolidate then put checkmarks in both 1)Top row &2) Left Column; then put in the Range in the REFERENCE on both tables, your data will be consolidated and easier to match up.
    I hope this is a good start (ps you may need to NOT have Merged Cells in the Reference Range)

+ 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: 1
    Last Post: 10-10-2023, 04:18 AM
  2. Replies: 2
    Last Post: 02-14-2021, 12:49 PM
  3. Replies: 5
    Last Post: 03-07-2017, 02:52 AM
  4. Replies: 1
    Last Post: 02-04-2016, 01:03 PM
  5. formula to subtract payment amount on monthly payment date
    By restingdonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 03:39 PM
  6. Replies: 0
    Last Post: 08-24-2013, 11:43 AM
  7. Replies: 3
    Last Post: 07-29-2013, 11:31 AM

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