Hi, I am hoping someone can help me with 3 complex look up formulas please.
Attached is a file with 2 active sheets. The are 3 columns I am trying to fill in the 'SUMMARY' sheet based on data in the 'Transactions' sheet.
All lookups are based on the Account # (which is 'Acc #' in the 'SUMMARY' sheet and 'accno' in the 'Transactions' sheet).
1. 'Trans Count' - # of transaction listed in the 'Transactions' sheet (so in the case of account 35 there is 3 transactions)
2. 'Last Trans Date' - date of the most recent transaction listed in the 'Transactions' sheet (so in the case of account 35 it is 1st Aug 2016 - this is column D)
3. 'Last Trans Value' - value of the most recent transaction listed in the 'Transactions' sheet (so in the case of account 35 it is $569.8 - this is column N)
If someone is able to put these calculations directly into the spreadsheet I have attached I would be extremely grateful!