Return the unpaid amounts based on Customer Name

[Alaa_Ali]

Hello

I would like to Return the unpaid amount based on Customer Name

So if the amount is not on Paid Amount column "sheet 1" should be returned as a new row under Customer name in "Result sheet"

Also if this can be adjusted with dates would be awesome "So I can Tell the Period where this Payments are due"

Thanks in advance

 

[Marc L]

Hello,​

​

try an advanced filter !​

​

Introduction to Excel Advanced Filters - What are they & How to use them

Excel's Advanced Filters can filter a list based on a variety of conditions and copy the values elsewhere too. Learn about Excel Advanced Filters & How to use them. In this example, we will show you how to set up advanced filters so that you can filter data meeting multiple criteria. Also, you...

chandoo.org

Extract data using Advanced Filter and VBA » Chandoo.org - Learn Excel, Power BI & Charting Online

In this post we will learn how to use the Advanced Filter option using VBA to allow us to filter our data on a separate sheet. This has been requested by a lot of our readers and here is how we will use them.

chandoo.org

 

[p45cal]

Make a pivot table from your data, then add a slicer for the Paid Amount, and select only (blank) in that slicer:

Turn off subtotals if you want.