Forum Discussion
Excel outline question
I have an Excel spreadsheet covering many columns and rows, mostly of text rather than numbers. Is there a way I can outline my entries so that what begins as Sport Team Division Netball ...
A formula can do this but may be more trouble than it's worth. Attached is a Pivot solution.
Thanks, Patrick. I will have a look at the pivot solution and see if I can still do my printouts as required. My audience doesn't have direct access to the document.