REPORT NEEDED TO COMPLETE USING EXCEL TOOLS

[nm1009]

I have some problems with doing these reports, can anyone help me?

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

onedrive.live.com

The report must be done with some condition mapping following the mapping rules which I have added it in the first sheet ("Requirement" Sheet) . In my opinion, I think it can be done by the JOIN formula in this case. Any opinions?
And about the "Deposit" Report, I must filter it from the data source only the positive numbers , and the "Loan" Report, I must filter it from the data source only the negative numbers?
Anyone can help me complete it and explain it for me so that I can understand? Really appreciated!
Thank you

 

[alansidman]

Windows says the file is too big and will not open. Suggest you trim down to a representative example. We really don't need to see the whole file.

 

[sandy666]

If you know what to do what do you want from us?
you did nothing in your file - do you want us to do everything instead of you?
btw. don't use merged cells - less troubles

 

[nm1009]

From these data source ( 03_Data source detail.xlsx ) , complete these reports ( 02_Report_temp.xlsx ) filtering with these mapping conditions ( 01_Requirement and Logic report .xlsx).
I’m kinda not sure about the solutions, and plus that I can’t do the conditions about the last conditions (contains 42** but not 42*2)

 

[nm1009]

And I’m using the Pivot table to filter step by step from the outside. Don’t know if i’m doing this right or wrong

 

[sandy666]

I downloaded your REPORT_MAI and don't want download next
Your description sayin' - nothing
with Excel 2007 you don't have much choice to "JOIN" something