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