Sort Problem

A

andyp161

Is is possible to sort a table according to the date of say A or
(rather than A then B) so that a table is essentially sorted by the th
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 bracket
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 thank
 
R

Richard Buttrey

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
Click to expand...

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
__________________________
 
Top