🌟 Every Other Day Excel Challenges No.60🌟 by Omid Motamedisedeh
🌟 Every Other Day Excel Challenges No.60🌟 by Omid Motamedisedeh
Difficulty: ⭐ ⭐ ⭐ ⭐
Topic: Match Payments!
The customer receipt costs and their payments are provided in Question Tables 1 and 2. We want to match the payments with the receipts based on the date, as shown in the result table. Receipts that are not paid will be marked as "NP" (Not Paid).
🔍For example, Payment ID P1 is used to pay for receipts C1 to C3.
📂 Link of Excel file= https://lnkd.in/g4JJPDSj
Live file https://1drv.ms/x/s!Ak8Fla2fCeo6g98Ca...
Link of Excel file https://lnkd.in/g7-ES7Ue
Thanks to https://www.linkedin.com/posts/omid-m...