Sort by five different criteria

B

Barney

I have a sheet that I need to sort by 5 critera (columns) not the limit of
three as is in my Excel 2002. Can that be done?

Barney
 
N

Niek Otten

Hi Barney,

From Dave Peterson:

You can sort multiple times. Just sort by the 3 least important and work your

way to the 3 most important.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a sheet that I need to sort by 5 critera (columns) not the limit of
| three as is in my Excel 2002. Can that be done?
|
| Barney
|
|
 
B

Bill Ridgeway

Barney said:
I have a sheet that I need to sort by 5 critera (columns) not the limit of
three as is in my Excel 2002. Can that be done?

Barney
Click to expand...

You could do this if you had a helper column with data from the five fields
concatenated (added together)
=A1&B1&C1&D1&E1
Data in the helper column is treated as a string so this doesn't work if any
of the fields need to be sorted in descending order or if numbers are in
'text' format. For that you could concatenate all the fields that can be
treated as text and sort on 'helper column' (ascending) and 'column X'
(descending).

Regards.

Bill Ridgeway
Computer Solutions
 
B

Barney

Thanks Nick and Bill. I used Nick's suggestion and it worked.... even as a
macro. I think s Bill's idea would work too. Very clever.

Barney
 
Top