|
|
|
|
#1
10-21-2014, 07:00 AM
|
|||
|
|||
You can do it easily with a pivot. I did one in about 2 minutes using your example. Do you know how to do that? I would attach my own but for some reason the attachment manager isn't working for me.
The key is to group the dates by Month/Year and then set up the Time value as average. 
|
|
#2
10-21-2014, 07:06 AM
|
|||
|
|||
|
hi there!
My compliance manager does not want a table. Here is my sheet. do you know of a formula, besides a pivot table? B2, B3, B4 - I wish to populate with the average times in each month the pricing was complete.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 formula for monthly sum
|
paulys | Excel | 1 | 08-23-2014 09:44 AM |
| How do I keep graph sizing and location for reuse on a monthly basis | lynchbro | PowerPoint | 0 | 06-09-2014 08:06 AM |
| No monthly view | letitbe | Outlook | 1 | 09-05-2013 10:25 AM |
| manipulating borders of a table on a per-border basis | gib65 | Word | 3 | 05-21-2012 12:40 AM |
|
Activating Signature on an ad hoc basis
|
HowardC | Outlook | 2 | 03-13-2012 09:20 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode