GETPIVOTDATA Function
I am in the process of updating my Pivot Table course and decided that I take another look at the GetPivotData function. GET PIVOT DATA is an… Read More »GETPIVOTDATA Function
Misc Functions
AGGREGATE Function
The AGGREGATE Function The AGGREGATE function is a very powerful function for summarizing an array of data. It combines 19 different ways to summarize data… Read More »AGGREGATE Function
Ways to Sum Data with Errors
Excel Techniques to Sum Data with Errors There are times that you need to know the sum of numeric data even though there may be… Read More »Ways to Sum Data with Errors
The N() function. Comments Anyone?
Most people are familiar with Insert>Comment. Just right-click on a cell and select Insert>Comment. Very easy. Right-click on the comment to display it, edit it or… Read More »The N() function. Comments Anyone?