Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column

PivotTable to Count How Many of Each Item There Are In a Column

[excelisfun]

Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column 

[dirtyydan]

I spent an hour trying to figure out how to do this, and you taught me in 52 seconds. Thank you so much.

[favourokoro]

Genius! Spent hours trying to figure this out and just found your video. Thank you!

[xyvann]

This man became my savior at work, kudos to you sir from 9 years later

[borkotoko]

So simple, thank you dude saving me so much time

[joseraimundo]

thank bro. Quick, honest and straight to the point

[ExploringExcelAmey]

Nice video again... this shows that pivot table can do anything what you need. I am creating a video on fail in pivot table and how to fix it... have a great day..

[nailskorner]

Great trick... It seems like "Count" is the default setting in pivot table. Can I ask whether I can change it into "Sum" instead? I use "Sum" more often in my work. Thank you. 

[aansuwandi]

Hi..can you tell me how to calculated no of pivot table row please....something like group by in access..thx