Can I sort by 4 Criteria's

's Computer Specifications

The sort box gives three, can there be 4 (through an Add-In or
something)? Thank you for your consideration.

John

's Computer Specifications

Highlight the sort range and sort by your lowest three criteria. Then
sort again choosing your highest (main) criteria.

Alternatively, you can join two or more fields together in a temporary
column, and include this in your sort range as one of the sort fields.

Hope this helps.

Pete

John13 wrote:

> The sort box gives three, can there be 4 (through an Add-In or
> something)? Thank you for your consideration.
>
> John

's Computer Specifications

John13 wrote:
> The sort box gives three, can there be 4 (through an Add-In or
> something)? Thank you for your consideration.
>
> John
>
and Excel 2007 will increase the number of sort levels when it's
available next year.

Bill

's Computer Specifications

Thanks Pete - It worked just the way I needed.

And Bill - I'm looking forward to 2007 (heard some neat things.......)

John

Pete_UK wrote:
> Highlight the sort range and sort by your lowest three criteria. Then
> sort again choosing your highest (main) criteria.
>
> Alternatively, you can join two or more fields together in a temporary
> column, and include this in your sort range as one of the sort fields.
>
> Hope this helps.
>
> Pete
>
> John13 wrote:
>
> > The sort box gives three, can there be 4 (through an Add-In or
> > something)? Thank you for your consideration.
> >
> > John

's Computer Specifications

Thanks for the feedback, John.

Pete

John13 wrote:

> Thanks Pete - It worked just the way I needed.
>
> And Bill - I'm looking forward to 2007 (heard some neat things.......)
>
> John
>
>
> Pete_UK wrote:
> > Highlight the sort range and sort by your lowest three criteria. Then
> > sort again choosing your highest (main) criteria.
> >
> > Alternatively, you can join two or more fields together in a temporary
> > column, and include this in your sort range as one of the sort fields.
> >
> > Hope this helps.
> >
> > Pete
> >
> > John13 wrote:
> >
> > > The sort box gives three, can there be 4 (through an Add-In or
> > > something)? Thank you for your consideration.
> > >
> > > John

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort by more than 3 criteria	Kim	Microsoft Excel Programming	2	7th Nov 2007 12:32 PM
Sort by five different criteria	Barney	Microsoft Excel Discussion	3	3rd Jul 2007 11:17 PM
Saving Sort Criteria (or Sort Lists)	=?Utf-8?B?SmltIEou?=	Microsoft Excel Worksheet Functions	1	25th Jul 2006 10:55 AM
Sort By Using Two Criteria	Karl Burrows	Microsoft Access Forms	2	27th Feb 2005 08:51 AM
Sort More than 3 criteria	=?Utf-8?B?TWF0dA==?=	Microsoft Excel Programming	2	10th Dec 2004 03:02 PM