I need of help from a Excell or Access Guru
Results 1 to 2 of 2

Thread: I need of help from a Excell or Access Guru

  1. #1
    Member
    Join Date
    Oct 2003
    Posts
    81

    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

    thanks
    Attached Files Attached Files

  2. #2
    Senior Member Aardpsymon's Avatar
    Join Date
    Feb 2007
    Location
    St Annes (aaaa!)
    Posts
    434
    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.

    <edit>

    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 10:51 AM.
    If the world doesn't stop annoying me I will name my kids ";DROP DATABASE;" and get revenge.

Similar Threads

  1. Windows Error Messages
    By cheyenne1212 in forum Miscellaneous Security Discussions
    Replies: 7
    Last Post: February 1st, 2012, 02:51 PM
  2. Port List
    By ThePreacher in forum Miscellaneous Security Discussions
    Replies: 17
    Last Post: December 14th, 2006, 09:37 PM
  3. Tcp/ip
    By gore in forum Newbie Security Questions
    Replies: 11
    Last Post: December 29th, 2003, 08:01 AM
  4. cant istall dsl softwr installshield access denied
    By collis113 in forum Site Feedback/Questions/Suggestions
    Replies: 2
    Last Post: November 9th, 2002, 09:57 AM
  5. The Worlds Longest Thread!
    By Noble Hamlet in forum AntiOnline's General Chit Chat
    Replies: 1100
    Last Post: March 17th, 2002, 09:38 AM

Posting Permissions

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