ranking data and keeping

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Ranking data and keeping the other data on the same row linked t

Ranking data and keeping the other data on the same row linked t

· Low Priority · Version 365

Annanda has attended:
Excel Intermediate course
Personal Resilience course
Excel Advanced course

Ranking data and keeping the other data on the same row linked t

How to work with the pivot table and make sure the values don't 'change' rows. I have done a pivot table and ranked some data but the name assigned to the data haven't moved with it.

RE: Ranking data and keeping the other data on the same row link

Hi Annanda,

Thankyou for your forum question.

Please can give some more details to the problem you want to solve.

Also, can you send a sample of your data to info@stl-training so it's easier to understand

Kind regards
Martin
(IT Trainer


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.07 secs.