danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
Invoice Number | Payment Date |
1001 | 7/01/2019 |
1001 | 7/25/2019 |
<tbody>
</tbody>
Hello,
I have instances where a customer will pay one invoice split into multiple payments.
E.g.
Half of invoice 1001 was paid on 1 July.
Other half was paid on 25 July.
In this example, I want to be able to search for invoice 1001 and have a formula that shows me the payment dates corresponding to that invoice number.
How do I go about this?
Thank you