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
Bookmarks