Sort Problem
 

Is is possible to sort a table according to the date of say A or B
(rather than A then B) so that a table is essentially sorted by the the
earliest date in 2 or more columns, e.g. if:

Column A
R2: 2/10/05
R3: 8/10/05
R4: 9/10/05

Column B
R2: 14/10/05
R3: 01/10/05
R4: 12/10/05

I would want the table to be sorted as follows (row numbers in brackets
representing former row numbers):

Column A
R2 (R3): 08/10/05
R3 (R2): 02/10/05
R4 (R4): 09/10/05

Column B
R2 (R3): 01/10/05
R3 (R2): 14/10/05
R4 (R4): 12/10/05

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=401880

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
wrote:


Is is possible to sort a table according to the date of say A or B
(rather than A then B) so that a table is essentially sorted by the the
earliest date in 2 or more columns, e.g. if:

Column A
R2: 2/10/05
R3: 8/10/05
R4: 9/10/05

Column B
R2: 14/10/05
R3: 01/10/05
R4: 12/10/05

I would want the table to be sorted as follows (row numbers in brackets
representing former row numbers):

Column A
R2 (R3): 08/10/05
R3 (R2): 02/10/05
R4 (R4): 09/10/05

Column B
R2 (R3): 01/10/05
R3 (R2): 14/10/05
R4 (R4): 12/10/05

Many thanks

I'd use a 'helper' formula in Column C.

i.e in C2 put the formula =Min(A2:B2)

Copy it down column C and then sort on column C.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________