Multiple sorting

[Mr D]

Is there a way I can perform a sort on more than 3 fields at the same time?

 

[Mark W.]

1. You could record a macro.
2. You could create and sort on a concatenated field.

 

[Mr D]

Thanks very much - the concatenate option looks good.

 

[Mark W.]

On 2002-04-03 08:24, Mr D wrote:
Thanks very much - the concatenate option looks good.

If your field items are of varible length I'd recommend that you include an appropriate delimiter in concatenated field. For example...

=CONCATENATE(A:A,",",B:B,",",C:C)