Excel Forum

Excel Name Trick #5: Names for Pivot Tables & more...

See how to use names with Pivot Tables, Data Validation & the VLOOKUP & COUNTIF functions and formulas.

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).

Pivot Table Pivot Tables PivotTables, COUNTIF, VLOOKUP, Data Validation and NAMES! Functions, Pivot Tables and Formulas.

Got a Question? Ask it Here in the Forum.