Auto arrange dates formula

[Tarun123]

Hi,

I have a set of dates and data linked to each other. Eg:


Column A Column B Column C Column D
02/01/17 AAB 01/01/17 AAD
04/01/17 AAC 02/01/17 AAB
01/01/17 AAD 03/01/17 AAE
03/01/17 AAE 04/01/17 AAC


So on and so forth. The dates input in column A would keep changing every week, as a input by me.i.e AAB linked to 02/01/17 might change to 02/03/17, AAC linked to 04/01/17 might change to 03/03/17.

1) I would like to write a formula to arrange the dates from the oldest to newest date to appear in Column C & corresponding data from B to Column D(aab etc data).

I don't want to use the sort function since that rearranges the Column C & D every time I sort Column A from oldest to newest.

Any ideas/solutions would be much appreciated?

Thanks.

 

[Gary's Student]

Because dates are really numerical values, it is easy to sort them by formula. In C1 enter:

=MIN(A:A)

In C2 enter the Array Formula:

=MIN(IF(A:A>C1,A:A))

and copy down. This effectively sorts column A. Finally in D1 enter:

=INDEX(B:B,MATCH(C1,A:A,0))

and copy down.

 

[Tarun123]

Hey. Thanks, this works perfectly.

What do i need to change if there are 2 or more dates in Column A which are the same?

 

[Gary's Student]

See my answer here:

excel - List top n items in column, which have highest sum in second column - Stack Overflow