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

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________

On Mon, 5 Sep 2005 04:30:58 -0500, andyp161
<andyp161.1uvrqd_1125914722.2033@excelforum-nospam.com> 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
__________________________