G
Gavin Jones
hi All
I have a parcel tracking system which outputs a csv file daily for
accounting purposes. I refer to this file as the packageset file. in the
package set file each line conatins the relevant information for each
parcel, or set of parcels delivred under a specific reference number.
a typical packageset file contains the following;
Pickup Date,Store No.,Store Name,Delivery Note No.,Manifest Count,Delivered
Date,Delivered Count,Signatory,Frieght Sticker No.
28/08/2003 ,4600 ,ABERDARE,
,1,29/08/2003 ,1 ,C J P ,C3263341
28/08/2003 ,4600 ,ABERDARE,
,1,29/08/2003 ,1 ,C J P ,C3263341
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
My question is this, can I in Excel, group the lines by store number giving
each store just one line with a combined total so in the example this would
reduce to 2 lines and aberdare would show as delivered count 2 and
accrington would show as delivered count 6.
All Ideas gratefully appreciated
Regards
Gavin
I have a parcel tracking system which outputs a csv file daily for
accounting purposes. I refer to this file as the packageset file. in the
package set file each line conatins the relevant information for each
parcel, or set of parcels delivred under a specific reference number.
a typical packageset file contains the following;
Pickup Date,Store No.,Store Name,Delivery Note No.,Manifest Count,Delivered
Date,Delivered Count,Signatory,Frieght Sticker No.
28/08/2003 ,4600 ,ABERDARE,
,1,29/08/2003 ,1 ,C J P ,C3263341
28/08/2003 ,4600 ,ABERDARE,
,1,29/08/2003 ,1 ,C J P ,C3263341
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
28/08/2003 ,4633 ,ACCRINGTON,
,1,29/08/2003 ,1 ,M O ,b8027562
My question is this, can I in Excel, group the lines by store number giving
each store just one line with a combined total so in the example this would
reduce to 2 lines and aberdare would show as delivered count 2 and
accrington would show as delivered count 6.
All Ideas gratefully appreciated
Regards
Gavin