Pivot Table Hacks: Show Yes/No in a Pivot Table

In this video, I'll show you how to show Yes/No in a pivot table using a simple formula. This HACK is awesome for displaying results in a pivot table, without having to create a separate column for the answer!
If you're looking for a way to display results in a pivot table more efficiently, then this is the video for you! In this video, I'll show you how to use a simple formula to show Yes/No in a pivot table, without having to create a separate column for the answer. This HACK is awesome for displaying results in a pivot table, without having to scroll through a lot of data!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.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
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel

[@Bondoz007]

Nice little hack - great use of number formatting 👍🏼 thanks

[@DougHExcel]

Hi Lin, thanks for the comment!

[@nedalhamdan6977]

Thanks Doug H what a great video you created

[@DougHExcel]

Glad you enjoyed it & thanks for the kind words!

[@dinahany233]

thanks great vid.

[@DougHExcel]

Glad you enjoyed it!

[@shoaibrehman9988]

It will definitely be useful

[@DougHExcel]

Glad you think so!

[@nedalhamdan6977]

can you write the sign which you put it in custom because it's not clear

[@DougHExcel]

"Yes";"Credit";"No" is the input for the custom number format