Sort by five different criteria

  • Thread starter Thread starter Barney
  • Start date Start date
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
 
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
|
|
 
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
 
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
 
Back
Top