Sort by more than 4 criteria?

**creationracing** · 11-07-2007, 06:31 AM

Hello all,

I'm just wondering if there is a way to sort a range by more than four criteria?

Four is the maximum number you can select in excel and you can't seem to achieve it using VBA either, has anyone any ideas?

Thanks!!!

**sweep** · 11-07-2007, 06:42 AM

Hi,

This article explains it far better than I can...

http://articles.techrepublic.com.com...1-5745800.html

**davesexcel** · 11-07-2007, 06:42 AM

Originally Posted by creationracing

Hello all,

I'm just wondering if there is a way to sort a range by more than four criteria?

Four is the maximum number you can select in excel and you can't seem to achieve it using VBA either, has anyone any ideas?

Thanks!!!

you may have to sort a couple of times, but usually sort starting with the column of least importance