[ms office - 2003] processing paper cut print logger logs help

[Geoff]

I have the csv log as produced by papercuts print logger and have imported it into Excel 2003. I have setup the worksheet as a List. I have frozen the top row and used it as the field names.

 

Now although I can set the sorts and filters on a per field basis and see who printed what, when and where, I also need to produce usage totals on a user per printer basis. I don't know how to do that with the standard excel tools. Do I need to start doing some VBA or have I just missed something obvious?

[JOrdan01070]

I think a pivot table should do this for you.

[OutToLunch]

Some nice instructions here - cribbed them for use myself on sorting ours out...

 

http://www.edugeek.net/forums/educational-software/16438-calling-all-excel-gods.html#post163822

[Geoff]

cheers, yes a pivot table is the solution I wanted and the info in the other thread was helpful.