ExcelBanter - How do I combine 2 data sets using date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I combine 2 data sets using date? (https://www.excelbanter.com/excel-worksheet-functions/448611-how-do-i-combine-2-data-sets-using-date.html)

bob23

How do I combine 2 data sets using date?

Hi,

I hope someone can help me. I have two sets of data with different dates and I want excel to automatically sort the data in date order.

e.g here is an example of the data I have

A B C D

16-Apr-13 200 29-Apr-13 200
09-Jul-13 190 29-Jul-13 190
01-Oct-13 170 29-Oct-13 180
24-Dec-13 100 29-Jan-14 170
18-Mar-14 90 29-Apr-14 160

Cheers

Spencer101

Quote:

Originally Posted by bob23 (Post 1611273)

Could you provide an example of what you want it to look like AFTER sorting too?

MyVeryOwnSelf[_3_]

How do I combine 2 data sets using date?

I have two sets of data with different dates
and I want excel to automatically sort the data in date order.

e.g here is an example of the data I have

A B C D

16-Apr-13 200 29-Apr-13 200

09-Jul-13 190 29-Jul-1 190

01-Oct-13 170 29-Oct-13 180

24-Dec-13 100 29-Jan-14 170

18-Mar-14 90 29-Apr-14 160

In the example, chronological order is:
A1,C1,A2,C3,A3,C3, ...
Is this always the case?

All times are GMT +1. The time now is 12:28 PM.