LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging or Consolidating Data from Multiple Workbooks evieb Excel Discussion (Misc queries) 0 February 13th 07 06:13 PM
Consolidating a Row of data from many worksheets xlsuser42 Excel Worksheet Functions 0 August 22nd 06 02:28 PM
Consolidating data?? Louise Excel Worksheet Functions 2 November 8th 05 01:40 PM
Pivottable - consolidating data - winwinweb Excel Worksheet Functions 1 February 15th 05 01:18 AM
Consolidating data from different workbooks deadsxy692003 Excel Worksheet Functions 1 January 28th 05 12:21 PM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"