Results 1 to 4 of 4

List data into table

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2008
    Location
    Cheltenham, UK
    Posts
    2

    List data into table

    Help! I'm struggling with something that should be really simple

    I have data in a list of sales people and dates of their sales calls. What I want to do is transform the list into a table as shown in the attachment.

    Then I want to calculate the number of days between the first and last sales call. This part is easy using date formatting and min/max I guess. What I can't do is get the table arranged. I have used a pivot table to count the number of calls per sales person but pivot table wont just display the dates in a table format, it will only sum or count etc.

    Hope this makes sense. Any help gratefully received!!

    Thanks
    Tom
    Attached Files Attached Files
    Last edited by VBA Noob; 11-10-2008 at 05:18 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1