+ Post New Thread
Results 1 to 5 of 5
Office Software Thread, Quick Excel question - as I'm not very good.. in Technical; Hi all! I wondered if anyone knew the best way to do the following in Excel. We have a spreadsheet ...
  1. #1

    Join Date
    Jan 2012
    Location
    Luton
    Posts
    121
    Thank Post
    22
    Thanked 15 Times in 12 Posts
    Rep Power
    8

    Quick Excel question - as I'm not very good..

    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

  2. #2
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    674
    Thank Post
    51
    Thanked 179 Times in 116 Posts
    Rep Power
    85
    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!)

  3. Thanks to clareq from:

    MattHarwood (23rd May 2013)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by clareq View Post
    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

  5. Thanks to LosOjos from:

    MattHarwood (23rd May 2013)

  6. #4

    Join Date
    Jan 2012
    Location
    Luton
    Posts
    121
    Thank Post
    22
    Thanked 15 Times in 12 Posts
    Rep Power
    8
    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!

  7. #5
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    674
    Thank Post
    51
    Thanked 179 Times in 116 Posts
    Rep Power
    85
    Once you discover pivot tables you use them constantly. I have no idea how I managed without them!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 6
    Last Post: 23rd December 2010, 06:54 PM
  2. Quick Excel Question
    By karldenton in forum Windows
    Replies: 2
    Last Post: 8th September 2009, 04:16 PM
  3. Quick WSUS Question
    By mattx in forum Windows
    Replies: 3
    Last Post: 10th May 2007, 03:14 PM
  4. A 64bit question. To be or not to be?
    By CM786 in forum Windows
    Replies: 14
    Last Post: 11th May 2006, 01:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •