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? Please note that in teh date column there is a date not a number, I just put a number here to make it a bit easier to understand Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting in a pivot table | Excel Discussion (Misc queries) | |||
Conditional Formatting in Pivot Table | Excel Worksheet Functions | |||
pivot table conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting in pivot table | Excel Discussion (Misc queries) | |||
Conditional Format and Pivot Table | Excel Discussion (Misc queries) |