VBA - Arrange Data in chronological order referencing 3 seperate columns

[Mikeymike_W]

Hi,

I am trying to create a macro that will arange my data in chronological order from oldest to newest.

I have 3 seperate columns (G, I & K) which contain dates, although some of the cells may be blank or contain dates in each column.
Is it possible to find the earliest date in each row, referencing these columns, and then have the rows arraged chronologically?

Many thanks for any help

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

You could add a helper column with the minimum value in it and then sort by it?

Excel 2013
	G	H	I	J	K	L
1	x7	x8	x9	x10	x11	x12
2	11/01/2012		16/10/2011		10/04/2012	16/10/2011
3	10/01/2012		31/10/2011		29/02/2012	31/10/2011
4	07/01/2012		07/11/2011		14/02/2012	07/11/2011
5			20/11/2011		05/01/2012	20/11/2011
6	01/01/2012		21/11/2011		11/02/2012	21/11/2011
7	08/01/2012		24/11/2011		14/04/2012	24/11/2011
8	05/01/2012		05/12/2011		28/02/2012	05/12/2011
9	03/01/2012		27/12/2011			27/12/2011
10	06/01/2012		27/12/2011		30/03/2012	27/12/2011
11	04/01/2012		30/12/2011		12/02/2012	30/12/2011
12	09/01/2012				21/01/2012	09/01/2012
Sheet1

Cell Formulas
Range	Formula
L2	=MIN(G2,I2,K2)

 

[Mikeymike_W]

Of course, such a simple solution. Thanks very much Rick it worked a great, much appreciated!

 

[RickXL]

No problem, I am pleased it is solved now.

Regards,