98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Pivot tables
Resolved · Low Priority · Version 2007
Tue 19 Jul 2011, 16:11Delegate Mark said...
Mark has attended:
Excel Advanced course
Pivot tables
When using Pivot tables I often need to take one cell reference from another. This works fine for one of formulas but when I try and drag the formula down it doesn't flow as a normal formula would. Is there a way to correct this?
Thanks
Mark
Tue 19 Jul 2011, 19:49Trainer Rodney said...
RE: Pivot tables
Hello Mark,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding PivotTable formulas.
I'm not sure what you are trying to achieve and would appreciate if you could email a sample file with the added formula in the PivotTable. I will examine this and come back to you with an answer.
Email me at: rl@stl-training.co.uk
I look forward to your reply.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted. |
