👉 Up4Excel Downloads Library: »» ml.up4excel.com/library ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
📗 Download Your Practice Workbook: »» cutt.ly/up4v1930MFD 🎯 They'll never know YOUR stylish report is really a Pivot Table - Learn to create professional looking Pivot Table Reports every time!
Thanks John. Some nice tips in there. I like how you created the headers. I've solved that before with VBA, but sometimes you don't want to distribute a workbook with code. So, thanks for the tips. Will definitely use them in the future. Thumbs up!!
Glad it helped Wayne. As a bonus tip I've subsequently realised you can add filters to the new headers. Basically, don't leave a gap between the new headers and the pivot table, select the cell one to the right of the new headers and click autofilter.
I have a formulas playlist ruclips.net/p/PL_DVYti-Y1H0OfLBPi5uBbz6Ozq0p04p0 but don't have anything on IF statements yet. The format for using AND or OR within IF is =IF(AND(A1=test1,A2=test2), action if true, action if false). Hope that lot helps, plenty of other tips in the playlist 👍
Reduce your working hours with my personal coaching. Details at ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
📗 Download Your Practice Workbook: »» cutt.ly/up4v1930MFD
🎯 They'll never know YOUR stylish report is really a Pivot Table - Learn to create professional looking Pivot Table Reports every time!
Thanks John. Some nice tips in there. I like how you created the headers. I've solved that before with VBA, but sometimes you don't want to distribute a workbook with code. So, thanks for the tips. Will definitely use them in the future. Thumbs up!!
Glad it helped Wayne. As a bonus tip I've subsequently realised you can add filters to the new headers. Basically, don't leave a gap between the new headers and the pivot table, select the cell one to the right of the new headers and click autofilter.
@@Up4Excel Nice! Thanks for that tip :))
@@wayneedmondson1065 👍
Thanks John. Very good tips!! :) :)
My pleasure John 👍
What video do you have that helps with formulars, if statements, use of OR, AND...
I have a formulas playlist ruclips.net/p/PL_DVYti-Y1H0OfLBPi5uBbz6Ozq0p04p0 but don't have anything on IF statements yet. The format for using AND or OR within IF is =IF(AND(A1=test1,A2=test2), action if true, action if false). Hope that lot helps, plenty of other tips in the playlist 👍
@@Up4Excel let look through, will let you know. Thank you.
How do you unprotected it then?
I'm not sure what you are referring to Matthew when you talk about unprotecting it. Can you clarify?
@@Up4Excel sorry that comment was meant for another channel. 🤔
Ok, no worries then