peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Count Blank Cells in Pivot Table Source Data

Sometimes there are blank cells in a pivot table's source data, and you might want to show a count of those blank cells in the pivot table. In this example there's an Employee field in the source data, and some of the records have no employee name entered. In the pivot table, you'd like to [...]

Related Posts Plugin for WordPress, Blogger...