Forum Discussion
Select the x accounts who are visited the longest time ago with extra filters
Hi all, I want to make a report in excel that gives me a list of the (by example) 20 accounts who are visited the longest time ago. That works fine with the following formula: =INDEX('10 Acc...
Dennis Depoorter Does this pivot table work as expected?
This does what it has to do (but I forgot 1 thing), but I forgot to tell you I'm allergic to pivots *smiley*🙂
Dennis Depoorter That is an allergy you should be addressing! 🙂
Seriously, pivot tables have a lot of advantages over putting things in formulas. Efficiency and less risk of error are the two most significant ones.
I only use them to quickly show some data, but not for permanent reports... just a feeling / opinion 🙂
