Odyrus
07-12-2011, 05:21 AM
Good day all,
I have an on-open macro that auto sorts 2 fields in my data table. I'm running into some issues wit the sort on the second field and am looking for a creative, non-tedious solution.
Here is the issue:
The first field that's sorted contains either one or two names, for example Smith or Smith, Jones.
The second field that's sorted contains a number, 1 or 2.
If there are multiple Smiths with a few Smith, Jones the second sort field looks at the Smiths as if they are separate from the Smith, Jones, as I suppose the sorting logic should do. How do I suppress this so that if all the Smiths are grouped together, including some Smith, Jones, it will sort the second column as if all the Smiths were one group?
Hopefully that's not confusing. Is this possible without laborious work?
Appreciate any advice!
Cheers!
I have an on-open macro that auto sorts 2 fields in my data table. I'm running into some issues wit the sort on the second field and am looking for a creative, non-tedious solution.
Here is the issue:
The first field that's sorted contains either one or two names, for example Smith or Smith, Jones.
The second field that's sorted contains a number, 1 or 2.
If there are multiple Smiths with a few Smith, Jones the second sort field looks at the Smiths as if they are separate from the Smith, Jones, as I suppose the sorting logic should do. How do I suppress this so that if all the Smiths are grouped together, including some Smith, Jones, it will sort the second column as if all the Smiths were one group?
Hopefully that's not confusing. Is this possible without laborious work?
Appreciate any advice!
Cheers!