You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
pivot
This has literally changed my life. (along with discovering you can import data from a webpage).
I feel like I may need to take some sort of online xls. course as I'm clearly overusing formulas.
If anyone knows of a particularly good series on YouTube, etc. please let me know.
EDIT: fwiw I'm actually using LibreOffice Calc, which seems to be pretty similar.
hugo7-
I feel like pivots are a kind of anti pattern in excel - though that's a personal observation and I suspect not widespread. As chalfie says above, you can't audit a pivot, and it's very easy to use stale data, or have a super complex pivot hide some data inadvertently.
That said, I've seen some wizards do stuff with them much quicker than I could a formula...
christianSpaceman
Would a pivot have solved this?