Complex sorting

I have 2 excel files that I want to merge. Each has 2 columns, one of which is dates and one of which is dollar amounts. Within each sheet, the dates are in order, but are basically random, meaning that some dates are skipped and some have more than one entry.

I want a resulting merged sheet to have all the dates in order, but to keep the dollar amounts in separate columns.


For example:


Sheet 1

June 3, 2008    146.56
June 3, 2008    256.47
June 7, 2008    585.29
June 11, 2008  127.27

Sheet 2

June 3, 2008    426.90
June 8, 2008    155.53
June 10, 2008   22.79
June 12, 2008   187.99

Resulting sheet

June 3, 2008    146.56
June 3, 2008    256.47
June 3, 2008                      426.90
June 7, 2008    585.29
June 8, 2008                      155.53
June 10, 2008                      22.79
June 11, 2008  127.27
June 12, 2008                    187.99

Admittedly, a strange request, but I have good reason for whanting to do it this way.

By: David

586 thoughts on “Complex sorting

  1. Bed assembly

    Hey There. I found your blog using msn. This is a really well written article. I will be sure to bookmark it and return to read more of your useful info. Thanks for the post. I will certainly comeback.

  2. HD channels

    Thank you for this article. I might also like to express that it can end up being hard when you are in school and just starting out to create a long credit standing. There are many college students who are only trying to pull through and have a long or good credit history are often a difficult matter to have.

  3. african people

    I simply couldn’t go away your site prior to suggesting that I extremely loved the standard information an individual supply on your guests? Is gonna be again incessantly in order to check up on new posts

  4. DMV African

    Hey There. I found your blog using msn. This is a very well written article. I’ll make sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will definitely return.

  5. gallbladder rupture

    Hi there would you mind sharing which blog platform you’re working with? I’m looking to start my own blog soon but I’m having a tough time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something completely unique. P.S Sorry for getting off-topic but I had to ask!

  6. hermes belt

    My husband and i were now cheerful that Raymond managed to deal with his researching out of the precious recommendations he obtained from your very own blog. It is now and again perplexing to just be making a gift of procedures which the rest have been selling. And now we acknowledge we need the website owner to thank for this. Most of the illustrations you have made, the straightforward website menu, the relationships you make it possible to foster – it’s got most powerful, and it’s assisting our son in addition to the family reckon that this subject matter is entertaining, and that’s quite mandatory. Thanks for the whole thing!

  7. lupus rash

    Hey there! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no backup. Do you have any solutions to prevent hackers?

  8. Book my Mantra

    An attention-grabbing dialogue is value comment. I believe that you must write more on this matter, it may not be a taboo topic however typically people are not sufficient to talk on such topics. To the next. Cheers

  9. Wholesale CBD Oil

    Woah! I’m really enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between user friendliness and visual appearance. I must say you’ve done a great job with this. In addition, the blog loads extremely fast for me on Firefox. Exceptional Blog!

  10. Kitchener

    Heya i am for the first time here. I found this board and I to find It truly helpful & it helped me out a lot. I am hoping to offer one thing again and aid others like you aided me.

  11. Anibal Doubrava

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something informative to read?

Leave a Reply

Your email address will not be published. Required fields are marked *