Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help tidying up a report
I have a report generated every morning. And I need to sum it all up to look more 'tidy' as the boss puts it. Can anyone help or give me ideas. Here's an example of the copy and paste from the CSV file created. Ref No Received(EST) Scheduled(EST) Delivered(EST) Cost Pages #Success #Failed Bill Code 77187001 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 2 MA 77187002 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 248 NH 77187004 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 192 NH 77187005 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 229 NH 77187006 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 87 NH 77187008 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 251 NH 77187010 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 1242 NH 77187011 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 442 NH 77187041 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 896 NH 77187044 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 240 NH 77187046 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 134 NH 77210557 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:57 $19.83 1 661 334 CO 77210559 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 19:03 $22.50 1 750 395 CO 77210560 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:58 $14.04 1 468 338 CO 77210561 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:53 $2.73 1 91 72 CO 77210562 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 11 CO 77210582 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:57 $39.42 1 1314 617 CO 77210609 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $5.58 1 186 147 CO 77210613 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.03 1 1 4 CO 77210614 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.12 1 4 0 CO 77210615 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:58 $18.96 1 632 392 CO 77210616 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.09 1 3 2 CO 77210617 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 3 CO 77210618 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $1.08 1 36 31 CO 77210662 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.50 1 50 31 CO 77210663 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO 77210664 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.12 1 4 0 CO 77210666 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.35 1 45 40 CO 77210667 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.18 1 6 0 CO 77210668 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.21 1 7 6 CO 77210670 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.06 1 2 3 CO 77210671 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:37 $0.09 1 3 0 CO 77210672 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $0.30 1 10 11 CO 77210675 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 19:02 $24.03 1 801 514 CO 77210676 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO 77210677 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.56 1 52 53 CO 77210683 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.30 1 10 5 CO 77210694 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:51 $0.00 1 0 3 CO 77210695 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO 77210696 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:54 $0.60 1 20 6 CO 77210697 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.45 1 15 8 CO 77210698 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:53 $0.93 1 31 15 CO 77210700 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.36 1 12 6 CO 77210701 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.60 1 20 14 CO 77210702 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.18 1 6 14 CO 77210703 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.63 1 21 22 CO 77210704 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $7.83 1 261 147 CO 77210706 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.84 1 28 17 CO 77210707 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 8 CO 77210708 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.54 1 18 16 CO 77210773 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 1 CO 77210775 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:53 $1.05 1 35 27 CO 77210778 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:43 $0.36 1 12 6 CO 77210779 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $1.23 1 41 29 CO 77210780 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.03 1 1 2 CO 77210781 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $5.01 1 167 118 CO 77210782 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $4.95 1 165 104 CO 77210783 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.11 1 37 42 CO 77210784 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $0.87 1 29 36 CO 77210785 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.06 1 2 5 CO 77210786 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 3 CO 77210787 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $3.93 1 131 118 CO 77210794 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $13.44 1 448 329 CO 77210795 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.35 1 45 24 CO 77210796 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $9.21 1 307 213 CO 77210799 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.29 1 43 17 CO 77210800 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $2.19 1 73 54 CO 77210801 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 74 CO 77210810 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $1.32 1 44 30 CO 77210823 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 8 CO 77210825 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.21 1 7 2 CO 77210826 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $1.53 1 51 47 CO 77210827 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:54 $0.33 1 11 12 CO 77210828 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:57 $2.04 1 68 63 CO 77210829 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 4 CO 77210837 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $0.75 1 25 21 CO 77210845 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO 77210862 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 96 CO 77210863 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:43 $0.06 1 2 2 CO 77210864 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:53 $6.09 1 203 149 CO 77210865 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:49 $0.54 1 18 8 CO 77210924 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.94 1 98 17 KS 77210929 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.37 1 79 17 KS 77210951 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:11 $41.19 1 1373 176 KS 77210952 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:05 $0.42 1 14 1 KS 77211013 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 6 KS 77211015 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 5 KS 77211016 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.24 1 8 1 KS 77211018 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 8 KS 77211019 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.78 1 26 6 KS 77211020 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS 77211021 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.24 1 8 3 KS 77211022 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $1.17 1 39 9 KS 77211024 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $0.24 1 8 4 KS 77211027 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:09 $5.88 1 196 59 KS 77211029 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $3.03 1 101 23 KS 77211031 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 4 KS 77211032 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.26 1 42 8 KS 77211033 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.56 1 52 17 KS 77211036 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.63 1 21 4 KS 77211037 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.27 1 9 7 KS 77211038 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.36 1 12 7 KS 77211039 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 6 KS 77211041 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.15 1 5 2 KS 77211043 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:01 $0.03 1 1 1 KS 77211044 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.27 1 9 1 KS 77211053 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:53 $0.27 1 9 0 KS 77211065 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS 77211070 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.93 1 31 5 KS 77211071 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS 77211072 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:58 $0.81 1 27 0 KS 77211074 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.09 1 3 0 KS 77211076 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $1.14 1 38 5 KS 77211080 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.57 1 19 1 KS 77211090 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.51 1 17 4 KS 77211096 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.39 1 13 12 KS 77211097 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.51 1 17 1 KS 77211098 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS 77211100 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.63 1 21 7 KS 77211101 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.87 1 29 8 KS 77211102 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:54 $0.24 1 8 2 KS 77211105 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.45 1 15 2 KS 77211107 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $3.69 1 123 22 KS 77211108 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.48 1 16 3 KS 77211113 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.27 1 9 4 KS 77211114 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:03 $0.54 1 18 3 KS 77211115 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $6.51 1 217 43 KS 77211117 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $11.13 1 371 103 KS 77211119 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.30 1 10 2 KS 77211120 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:09 $0.57 1 19 2 KS 77211121 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 17:53 $0.36 1 12 2 KS 77211130 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.84 1 28 6 KS 77211140 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.33 1 11 5 KS -- alexm999 ------------------------------------------------------------------------ alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918 View this thread: http://www.excelforum.com/showthread...hreadid=518210 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help tidying up a report
We need to know what has to be summed.
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "alexm999" wrote in message ... I have a report generated every morning. And I need to sum it all up to look more 'tidy' as the boss puts it. Can anyone help or give me ideas. Here's an example of the copy and paste from the CSV file created. Ref No Received(EST) Scheduled(EST) Delivered(EST) Cost Pages #Success #Failed Bill Code 77187001 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 2 MA 77187002 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 248 NH 77187004 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 192 NH 77187005 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 229 NH 77187006 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 87 NH 77187008 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 251 NH 77187010 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 1242 NH 77187011 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 442 NH 77187041 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 896 NH 77187044 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 240 NH 77187046 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 134 NH 77210557 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:57 $19.83 1 661 334 CO 77210559 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 19:03 $22.50 1 750 395 CO 77210560 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:58 $14.04 1 468 338 CO 77210561 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:53 $2.73 1 91 72 CO 77210562 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 11 CO 77210582 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:57 $39.42 1 1314 617 CO 77210609 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $5.58 1 186 147 CO 77210613 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.03 1 1 4 CO 77210614 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.12 1 4 0 CO 77210615 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:58 $18.96 1 632 392 CO 77210616 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.09 1 3 2 CO 77210617 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 3 CO 77210618 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $1.08 1 36 31 CO 77210662 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.50 1 50 31 CO 77210663 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO 77210664 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.12 1 4 0 CO 77210666 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.35 1 45 40 CO 77210667 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.18 1 6 0 CO 77210668 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.21 1 7 6 CO 77210670 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.06 1 2 3 CO 77210671 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:37 $0.09 1 3 0 CO 77210672 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $0.30 1 10 11 CO 77210675 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 19:02 $24.03 1 801 514 CO 77210676 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO 77210677 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.56 1 52 53 CO 77210683 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.30 1 10 5 CO 77210694 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:51 $0.00 1 0 3 CO 77210695 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO 77210696 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:54 $0.60 1 20 6 CO 77210697 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.45 1 15 8 CO 77210698 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:53 $0.93 1 31 15 CO 77210700 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.36 1 12 6 CO 77210701 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.60 1 20 14 CO 77210702 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.18 1 6 14 CO 77210703 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.63 1 21 22 CO 77210704 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $7.83 1 261 147 CO 77210706 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.84 1 28 17 CO 77210707 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 8 CO 77210708 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.54 1 18 16 CO 77210773 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 1 CO 77210775 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:53 $1.05 1 35 27 CO 77210778 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:43 $0.36 1 12 6 CO 77210779 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $1.23 1 41 29 CO 77210780 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.03 1 1 2 CO 77210781 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $5.01 1 167 118 CO 77210782 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $4.95 1 165 104 CO 77210783 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.11 1 37 42 CO 77210784 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $0.87 1 29 36 CO 77210785 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.06 1 2 5 CO 77210786 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 3 CO 77210787 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $3.93 1 131 118 CO 77210794 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $13.44 1 448 329 CO 77210795 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.35 1 45 24 CO 77210796 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $9.21 1 307 213 CO 77210799 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.29 1 43 17 CO 77210800 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $2.19 1 73 54 CO 77210801 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 74 CO 77210810 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $1.32 1 44 30 CO 77210823 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 8 CO 77210825 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.21 1 7 2 CO 77210826 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $1.53 1 51 47 CO 77210827 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:54 $0.33 1 11 12 CO 77210828 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:57 $2.04 1 68 63 CO 77210829 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 4 CO 77210837 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $0.75 1 25 21 CO 77210845 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO 77210862 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 96 CO 77210863 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:43 $0.06 1 2 2 CO 77210864 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:53 $6.09 1 203 149 CO 77210865 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:49 $0.54 1 18 8 CO 77210924 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.94 1 98 17 KS 77210929 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.37 1 79 17 KS 77210951 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:11 $41.19 1 1373 176 KS 77210952 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:05 $0.42 1 14 1 KS 77211013 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 6 KS 77211015 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 5 KS 77211016 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.24 1 8 1 KS 77211018 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 8 KS 77211019 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.78 1 26 6 KS 77211020 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS 77211021 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.24 1 8 3 KS 77211022 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $1.17 1 39 9 KS 77211024 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $0.24 1 8 4 KS 77211027 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:09 $5.88 1 196 59 KS 77211029 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $3.03 1 101 23 KS 77211031 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 4 KS 77211032 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.26 1 42 8 KS 77211033 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.56 1 52 17 KS 77211036 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.63 1 21 4 KS 77211037 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.27 1 9 7 KS 77211038 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.36 1 12 7 KS 77211039 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 6 KS 77211041 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.15 1 5 2 KS 77211043 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:01 $0.03 1 1 1 KS 77211044 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.27 1 9 1 KS 77211053 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:53 $0.27 1 9 0 KS 77211065 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS 77211070 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.93 1 31 5 KS 77211071 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS 77211072 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:58 $0.81 1 27 0 KS 77211074 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.09 1 3 0 KS 77211076 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $1.14 1 38 5 KS 77211080 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.57 1 19 1 KS 77211090 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.51 1 17 4 KS 77211096 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.39 1 13 12 KS 77211097 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.51 1 17 1 KS 77211098 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS 77211100 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.63 1 21 7 KS 77211101 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.87 1 29 8 KS 77211102 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:54 $0.24 1 8 2 KS 77211105 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.45 1 15 2 KS 77211107 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $3.69 1 123 22 KS 77211108 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.48 1 16 3 KS 77211113 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.27 1 9 4 KS 77211114 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:03 $0.54 1 18 3 KS 77211115 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $6.51 1 217 43 KS 77211117 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $11.13 1 371 103 KS 77211119 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.30 1 10 2 KS 77211120 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:09 $0.57 1 19 2 KS 77211121 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 17:53 $0.36 1 12 2 KS 77211130 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.84 1 28 6 KS 77211140 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.33 1 11 5 KS -- alexm999 ------------------------------------------------------------------------ alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918 View this thread: http://www.excelforum.com/showthread...hreadid=518210 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help tidying up a report
The is to be summed: Everything is centered on the Billing code which is an abbreviation of a state. (CO, VT, MA, etc...) Then to be summed and broken up a State, Delivery Date and Time, Success, Failed and cost. I don't mind having the CSV file opened, but in a different excel file, i need to sum up the above mentioned. Hope this helps. -- alexm999 ------------------------------------------------------------------------ alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918 View this thread: http://www.excelforum.com/showthread...hreadid=518210 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying only report sheets | Excel Discussion (Misc queries) | |||
Pivot Table Report Parameters to be named and saved like 'View' na | Excel Discussion (Misc queries) | |||
How do I create a push report in Excel? | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |