-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
borrower
-
R
Dashboard Using Dates, Date Ranges and an Aging Matrix
I need some help. I have a spreadsheet that has two sides. A shortages side and a Surplus side. The numbers on the two sides two will always remain seperate Basically a Debits and Credits Accounting type setup. Each side of the spreadsheet is an every growing and shrinking with the number...- richmcgill
- Thread
- amount borrower date days interest
- Replies: 2
- Forum: Excel Questions
-
G
Need help with Count excluding duplicates when using a table
I have a table of data that contains the following columns. I am trying to count the number of loans each officer has made. In order to have a slicer on the dashboard to switch between combinations of New/Refi funds some loans can be duplicates. Can someone help me with a formula to count the...- Golfpro1286
- Thread
- borrower count duplicates loan officer
- Replies: 1
- Forum: Excel Questions
-
J
How do I pull multiple information from the same MainID (foreign key) in Excel?
Hi, I am working for a company which acquires SME/retail Non Performing Loans (Say Borrower Code B_0001 to B_1000)- of which each Borrower Code may contain multiple Loans (ie B_0001 may have 2 LoanIDs (L_0001, L0002... and the running number goes on with the next Borrower. These are the...- Jangster
- Thread
- borrower b_0001 formula l_0001 respective
- Replies: 6
- Forum: Excel Questions
