help with Sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maju - 28 May 2008 17:51 GMT

Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6

I am trying to sorting 6 different column/row in ascending order.

if so, i need hep with the code.

Thanks

Reply to this Message

Jim Cone - 28 May 2008 18:16 GMT

Run the sort twice, keys 4,5,6 first then keys 1,2,3.

Signature

Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - two dozen ways to sort with Special Sort)

"maju" <maju@discussions.microsoft.com>
wrote in message
Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6
I am trying to sorting 6 different column/row in ascending order.
if so, i need hep with the code.
Thanks

Reply to this Message

Joel - 28 May 2008 18:22 GMT

You can do multiple sorts, but only three at a time. Do the less precedence
first

If you were sorting the number 6 5 4 3 2 1. One digit in each columns A - F.
sort D E F first. Then repeat using columns A B C.

> Can sorting go up to 6 keys? Key1, key2, key3, key4 …key6
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

maju - 28 May 2008 19:45 GMT

Thanks guys

> You can do multiple sorts, but only three at a time. Do the less precedence
> first
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message

maju - 28 May 2008 21:31 GMT

how do i determine the last cell and then sort the information. i dont wand
to hard code the ranges. because datas changes.

> You can do multiple sorts, but only three at a time. Do the less precedence
> first
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message