| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Quote:
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine two sets of overlapping Date/Time data into 3 columns. | Excel Worksheet Functions | |||
| How do I combine 2 sets of dates using concatenate function? | Excel Worksheet Functions | |||
| Combine 2 sets of data | Excel Discussion (Misc queries) | |||
| is it possible to combine data sets, eliminating duplicates? | Excel Worksheet Functions | |||
| How to combine two data sets with one category of variable in com. | New Users to Excel | |||
Linear Mode
