|
|
#1
11-12-2013, 09:45 AM
|
|||
|
|||
Week by week report
Hi All,
I have a spreadsheet which works great but I want to add some additional formulas and need a little help? There are 2 tabs with this spreadsheet. The first tab is raw data which shows name, date of audit and audit score. This data contains all audit scores for all members of staff . The second tab actually shows an average audit score of the data week by week for each person. Is there a way to add another column next to the percentage to show the number of audits completed? So this would be a count of the entries rather than an average? So for example, column D would not show the amount of audits completed. Eg Derek Spenser between 30th Sept and 4th Oct = 4 I have attached another example. Hope this makes sense? Many thanks Craig 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| send an email every week. | devilonline | Outlook | 0 | 08-03-2012 10:30 AM |
 5 days/week during planning & 7 days/week during implementation
|
sanlen | Project | 1 | 06-25-2012 04:17 PM |
|
Conditional Formatting per Week
|
mrgy05 | Excel | 2 | 06-07-2012 10:38 AM |
|
How to reorder the days of the week
|
Mosey | Outlook | 2 | 10-31-2011 06:47 AM |
|
Calander work week
|
cfawcett22 | Outlook | 1 | 08-06-2011 01:46 PM |
Windows XP 
Office 2003
Threaded Mode