| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How t count by week whatever is with in the week (two criteria, ma
I have a Date Colum, its first row begins with 01 Oct 06 and ends with 01
Oct 08. I have another column Type of Work that has three types of work, SR, SO and WR I would like to draw a total number of Work Orders per week and type of work Order (results on the other sheet) e.e: Weekending SR SO WO 07-Oct-06 = 10 45 15 14-Oct-06 = 30 56 102 etc.. I tried with Pivot Table but I can cot brake them down by weeks. Is there other way of working this out please? Perhaps formula, PivotTable or maybe code? Thank you, Adnan -- Please post all your inquiries on this community so we can all benefit - Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| update week to week in excel. | Excel Worksheet Functions | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| Sum Count of Criteria Every 3rd Row | Excel Worksheet Functions | |||
| I need to count while using multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
