Multiple sorting

Mr D · Apr 3rd, 2002, 08:06 AM

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

Mark W. · Apr 3rd, 2002, 08:54 AM

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

Mr D · Apr 3rd, 2002, 09:24 AM

Thanks very much - the concatenate option looks good.

Mark W. · Apr 3rd, 2002, 10:14 AM

Quote:

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 08:06 AM	#1
Mr D New Member Join Date: Apr 2002 Location: Uttoxeter, England Posts: 38	Is there a way I can perform a sort on more than 3 fields at the same time?

Apr 3rd, 2002, 08:54 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	1. You could record a macro. 2. You could create and sort on a concatenated field.

Apr 3rd, 2002, 09:24 AM	#3
Mr D New Member Join Date: Apr 2002 Location: Uttoxeter, England Posts: 38	Thanks very much - the concatenate option looks good.