Hi guys,
I need to sort Column "C" in Descending while Columns "H", "E", and "D" in Ascending Order with a macro. Is there a way around the 3 Key limit?
Thank you!
Hi guys,
I need to sort Column "C" in Descending while Columns "H", "E", and "D" in Ascending Order with a macro. Is there a way around the 3 Key limit?
Thank you!
Any combined sort can be done by sequential one column sorts.
For example, a triple sort of by Name, then on State and then on City, can be done by
Sort on City
then Sort on State
then Sort on Name
Doing 4 (or more) one column sorts is equivalent to doing a single quadruple (or more) sort.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
If Mike's suggestion seems a little counterintuitive, it is because Excel performs stable sorts: the relative order of records having the same key is unchanged.
Entia non sunt multiplicanda sine necessitate
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks