[ms office - 2010] Quick Excel question - as I'm not very good..

[MattHarwood]

Hi all!

 

I wondered if anyone knew the best way to do the following in Excel. We have a spreadsheet that is generated through the free Papercut software, showing who prints what and when.

 

Is there an easy way to get Excel to look at the Users column, and show which usernames appear most frequently please?

 

Thanks in advance

[clareq]

I would look at a a pivot table - I use one to find those staff who bypass the "no more than 5 copies off the printer then photocopy" rule by pressing print multiple times (pausing between them to get past that rule!)

[LosOjos]

I would look at a a pivot table

 

+1

 

Highlight your data, click "Insert Pivot Table", add username as your column and data field (it should automatically become a 'Count' field), then sort descending

[MattHarwood]

clareq, LosOjos - many thanks! Pivot tables were just what I was after. I've got the data just how I wanted it - how hadn't I seen these before?!

 

Thanks again!

[clareq]

Once you discover pivot tables you use them constantly. I have no idea how I managed without them!