Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Totals of variable data (2003)

    Hi All,
    I have a workbook that I request some help with. (Sample data attached) The workbook has three columns in it.

    What I am trying to achieve is a list where each combination of data amongst the three columns is listed and a quantity for the amount of times each combination appears. For example the final list should look a little like:

    1BI UNI P

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Totals of variable data (2003)

    You could sort and count the data by putting it into a pivot table with the data field either as a count of items or the sim of a dummy value set to one for each data point - see attached. If you prefer you can drag the "Type" button to the left column of labels to get the single-column format you specified - this was just more compact. I had to delete some of the data to get the zip file to fit on the Lounge - it was right at 100KB when I tried to post it the first time.

    By the way, there were some "P" "F" (etc) values that were distinguishable by leading or trailing spaces. I removed them with a "Trim" function - if this is correct you will have to do the same with your data file...

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals of variable data (2003)

    Dean - Thanks so much for your help.

    Much appreciated.

    Bill

Posting Permissions

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