If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the actual ...
Excel isn't hard, just learn the right tricks early enough.
How-To Geek on MSN
Why I'm swapping my PivotTables for the PIVOTBY function in Excel
PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel professional.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results