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?
|