Hello everyone
In my sample workbook I have two sheets .. Data sheet and the Expected Results sheet ..
In Data sheet I have clients that have specific totals (that should be paid) in column D .. and in column G the amounts that is paid ..
I need in the Expected Results sheet to prepare a report for those who didn't pay all the Total only .. as for who paid the total amount I didn't need to extract them ..
In other words if the value in column G is less than the value in column D then to deal with that row ..
For example :
The ID process 189 in second row of table has a total 90.000 and in column G there is a value 80.000 so he didn't pay all the total amount ..
and the same ID process pay another (second paid) in row 3 , he paid 5000 so the total is still unpaid completely
I have attached the expected results to illustrate the form of the report needed
Thanks advanced for help
Bookmarks