Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Consolidating data?
My accounts package produces listings in form of CSV files. Typically the
listings are dates and (invoice)values. The dates are in order but non sequential -in otherwords there are gaps. Some dates are repeated (think 'date, invoice value' where theres more then one invoice per day) I regularly need to merge/consolidate two/more such listings into one so that I end up with a dates list (without repeats) and value being the sum of all invoice values for the (unique) dates referenced. Note the dates and values differ from list to list but the dates are ordered as above (increasing). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging or Consolidating Data from Multiple Workbooks | Excel Discussion (Misc queries) | |||
Consolidating a Row of data from many worksheets | Excel Worksheet Functions | |||
Consolidating data?? | Excel Worksheet Functions | |||
Pivottable - consolidating data - | Excel Worksheet Functions | |||
Consolidating data from different workbooks | Excel Worksheet Functions |