Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. Here's an Excel #shorts video to show you how.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ exceltraining101.com/p/training.html
📚 Excel Books & Tech Gear ➜ amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
- Get Distinct Count (Ignore Duplicates) in Pivot Table - Excel #Shorts ( Download)
- Count Unique Values in PivotTables in Excel ( Download)
- Excel Distinct Count with a PivotTable ( Download)
- Enable Distinct Count for Pivot Tables ( Download)
- How to Count Only Unique Values Excluding Duplicates in Excel ( Download)
- 2 Quick Ways To Calculate Distinct Count With Pivot Tables ( Download)
- Find Out Unique Data by Using Pivot Table | Use of Distinct Count Function ( Download)
- How to count unique values Excel ( Download)
- Distinct Count with a PivotTable #shorts ( Download)
- How To Count Unique Items In Pivot Table In Excel ( Download)
- Finding Duplicates In Excel - Method 05 of 05 : Pivot Tables #Shorts ( Download)
- Distinct count in pivot table | how to find unique count in pivot table ( Download)
- Excel: How to Count Unique Values Without Using a Pivot Table ( Download)
- How to get Distinct Count in Pivot Table Ms Excel 2013, 2016 and Excel 360 ( Download)
- Pivot Table - Duplicate Value Count ( Download)