Can I sort by more than 3 columns?
Note that the above logic is only efficient when the character count in
the target columns is stable. For example, if a column holds only five
characters, it will be efficient. If it holds 5 and 6 character
values, it will not be consistent in its sort.
Stable items would include phone number, social security numbers,
account numbers. Dates, money and names have the potential of being
unstable.
Good Luck
xlsweetspot
|