Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have got a problem where I need to work out how many deliveries were made
in a month of sales. I am doing this by if the postcode and the date of delivery are the same on two separate orders they have gone together on one van and it is counted as one delivery. Example POSTCODE DATE POSTCODE ORDERS DELIVERYS A 1 A 2 1 A 1 B 2 2 B 1 C 4 2 B 2 C 3 C 1 C 3 C 3 I want to get the second table from the first table, I have tried using pivot tables but not got very far. Can anyone help? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combining fields on a pivot table | Excel Worksheet Functions | |||
Combining Pivot Table Source Data | Excel Worksheet Functions | |||
Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |