Posts by johnny001

    Thanx for your help Brandtrock.
    I looked through the data, and it seems the pivot table is not correct in the totals field.
    i.e. for station 16.08.01 it should be 20 days, not 13

    Also, regarding the new formatting, looks simple enough to do, however I have over 6000 entries for which i'd have to apply this new formatting to.

    I am thus thinking maybe it should be somehow done by formulas? To simply this process, I am now only looking for summarys by workstation.

    So ideally, for each workstation, I would be able to look at how many days it was used.
    Any ideas?




    I have been working on sorting through loads of data, and fianlly i have it down to manageable size. I am now focusing on 3 columns:

    -A: this is a location of the workstation, it is a series of numbers separated by dots, ie. 16.05, 16.54.87 and so on
    -B This is the name of the staff that was located at the workstation
    -C The length of the booking for each person at each workstation

    Now the formating of this file may seem strange, but it is due to the way it was extracted from Lotus. Now for what I need:

    I have to summarize the amount of time spent by:
    1) workstation
    2) Person

    So the output column(s) should look something like this:
    for 1)
    16.05 20 days
    16.08.01 18 days

    for 2) Jane Smith 20 days
    Bob Dole 4 Days

    Any help would be much appreciated, as I have yet to figure out how to start this out. ( when i tried pivot table, it won't let me create it due to an error message regarding pivottable name).

    I have attached a sample file for a better explanation