Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 365

Femi has attended:
Excel Advanced course
Excel Advanced course

Pivot tables

getting the top 5 value filters using the alternative/ quicker method

RE: Pivot tables

Hi Femi,

I hope that you are fine.

Thank you for the forum question.

I am not sure what you mean by "getting the top 5 value filters using the alternative/ quicker method"

The only method is the one we did on the course.

What I did after you did the Pivot Table "Bottom Five". I just copied the Pivot Table "Top Five" and changed the filter to "Bottom Five"



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Toggle Formulas and Results

Ctrl + 'The key above Tab with the

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.