April 25th, 2007, 10:57 PM
I need of help from a Excell or Access Guru
Im in need of help from someone knowledgeable in excell or access.
In the attachement below I have a list of users. I also have an Identifier for those users "Pen ID".
Im trying to great a graph to show how many times the users appear in the list .
If anyone knows how I can do this then please let me know
April 26th, 2007, 09:44 AM
You need a pivot table.
I made something similar with a DB for password changes. List of user (unique) then date, time, location. What you can do is make a pivot table, drag the username into the left hand column then drag the total into the top left square (as I recall). Let me just check.
Yeah, what I did was drag the username into rows, then drag ANY other field into the top of the username and it gives you a list of users and a frequency.
This is in excel 2003, pivot tables are in the data menu.
Last edited by Aardpsymon; April 26th, 2007 at 09:51 AM.
If the world doesn't stop annoying me I will name my kids ";DROP DATABASE;" and get revenge.
By cheyenne1212 in forum Miscellaneous Security Discussions
Last Post: February 1st, 2012, 01:51 PM
By ThePreacher in forum Miscellaneous Security Discussions
Last Post: December 14th, 2006, 08:37 PM
By gore in forum Newbie Security Questions
Last Post: December 29th, 2003, 07:01 AM
By collis113 in forum Site Feedback/Questions/Suggestions
Last Post: November 9th, 2002, 08:57 AM
By Noble Hamlet in forum AntiOnline's General Chit Chat
Last Post: March 17th, 2002, 08:38 AM