Excel for Mac sort question

  • Thread starter Thread starter garagecapital
  • Start date Start date
G

garagecapital

Is there an add-in or easy way to sort by seven columns rather than by
just three columns?
 
Nope.

You could sort 3 times in reverse order of importance.

Or maybe you could record a macro when you do the 3 sorts and then just rerun
that macro when you need the same sort.

I don't use Mac's. Can you still record macros in your version of excel?
 
Hi,

Here are 3 solutions if you don't want to do use a macro:

1. Sort the three least important columns with the Data Sort command, then
sort the next 3 least import columns, and finally sort the most import.
2. Click in the least important column and click the Ascending or
Descending sort button, move to the next most important column and sort, do
this for all 7 columns working from the least important to the most important.
3. (sort of kidding) Use Excel 2007 for the PC - it allows 64 levels of
sorting
4. If you are using 2004 you can record a macro to do #1 or #2 above. In
2008 you need to write Apple Script, and I don't have any idea about that.
 
Nope.

You could sort 3 times in reverse order of importance.

Or maybe you could record a macro when you do the 3 sorts and then just rerun
that macro when you need the same sort.

I don't use Mac's.  Can you still record macros in your version of excel?
Click to expand...

Doesn't sound like what I wasn't to go through. I wonder why just
three sorts?
 
I'm sure that they _knew_ that nobody would ever want to sort on more than 3
keys.
 
You can sort up to three fields at a time, so basically sort 1, then
sort 3, then sort 3 = three sorts.

Depending on your data, you could concatenate some fields together in
a helper column and use this combined field within your sort.

Hope this helps.

Pete
 
Back
Top