Count Unique Values in PivotTables in Excel

Опубликовано: 16 Февраль 2015
на канале: Computergaga

163,287

1.1k

Count unique values in PivotTables in Excel using the new Distinct Count function.

When working with PivotTables the Count function will count all occurrences of a value. However, you may be trying to answer how many unique products were sold in a country, or how many unique customers are in that country.

This video looks at answering such questions by using the Distinct Count function in Excel PivotTables.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1