Joining multiple Excel files but make sure only latest information will be in the output

[ulrich_schumann]

Hi all,

I have multipe Excel sheets (one per year) which are containing ongoing project data. All files contain all ever used IDs and the corresponding project name. Each file contains all detail data for this year and last year and the ID/name for all the older entries. Project details are therefore listed in at least 2 files.

Now I want to merge all the files into one big file showing all the data details but I need to make sure that only the the latest data set is used.

What do I need to do to join all the souces and having the latest available project details (and only the lalest) in one big file?

Thanks for your help.

[pcatterson · Accepted solution]

This can be accomplished with a sort then a unique assuming your data has an applicable date field. 

[ulrich_schumann]

Thanks, the suggest solution is working. Could this also be solved by using a kind of 'join if'?