Has anyone here yet had a play with the “QUERY” function in Google Sheets? You can unleash some real power with it.
It’s a neat little way to do all sorts of filtering / searching of your data - without getting any Pivot Tables out. You can really customise the order and structure of data quite well with it.
Here’s a nice primer:
Anyway, I needed to have one Cell that showed the Latest Direct Debit to [Merchant] in it, and this was a nice neat way to do it without varying degrees of vlooksups and countifs.