| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pick the first day in and the last day out in a PivotTabel?
I have created a PivotTable with datas looking like the following, i could
only manually pick out the first date received and the last date out, and sum the no of networkdays, however it involves a lot of work since there are many companies, wonder if anyone has a better idea. Thank you very much! Company Date Received Date Out No. of Networkdays ANY 10/12/2005 12/12/2005 0 12/12/2005 13/12/2005 1 15/12/2005 16/12/2005 1 BEG 02/12/2005 05/12/2005 1 05/12/2005 07/12/2005 2 08/12/2005 09/12/2005 1 12/12/2005 13/12/2005 1 The final result should look like ANY 10/12/2005 16/12/2005 2 BEG 02/12/2005 13/12/2005 5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTabel Templates in Excel 2003 | Excel Discussion (Misc queries) | |||
| pick top 5 out of 8 numbers | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Is there a way to pick the cells to add using sum? | Excel Worksheet Functions | |||
| Pick a row | Excel Programming | |||
Threaded Mode
