Forum Discussion
Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)
Depending on what your desired end goal is, those lists of account transactions--I'm assuming that you're looking at some summary or extraction of a defined sub-set of data from the comprehensive database--you might find it more suitable to use a few of the Dynamic Array functions. Let me direct your attention to FILTER, UNIQUE, SORT. Also, this probably could be used to create a "custom" Pivot Table, PIVOTBY. I haven't used this last function yet; I have used the first three extensively, and found it very easy to create custom extractions of data on the spot, with (yes) a lot more flexibility than the Pivot Table tool itself gives you.
Mathetes – I’ve been around long enough to have used Lotus 123 and WordStar. And I’ve know people at work that were big pivot table users, but I never had a need (at work, at least) to get any good at them. But I used them over the last five years for monthly treasury reports when I was treasurer of a non-profit, so I’ll start developing a new workbook for my monthly budget tracking using a database and pivot tables.
Question – do you change the expense numbers to ABS* -1 to change expenses that download as positive numbers to negatives?
NikolinoDE – I applied your formula to my workbook and it worked great. Thanks!