I have a list generated by a SQL script. The list is a date and number per line.
Ex: 10-02-04,3234
10-03-04,280
10-04-04,9843
The problem is I need something to compare the date from line 1 to line 2 and if there are the same add the number from line 2 to line 1. The end result should be no duplicate dates and all numbers totaled for each date. I'm sure there is an easy fix I just can't think of it right now. Thanks is advance....
Ex: 10-02-04,3234
10-03-04,280
10-04-04,9843
The problem is I need something to compare the date from line 1 to line 2 and if there are the same add the number from line 2 to line 1. The end result should be no duplicate dates and all numbers totaled for each date. I'm sure there is an easy fix I just can't think of it right now. Thanks is advance....