--- John C Bullas asked:
> Nice one,
> Now can you tell us the solution for if any of us are in a similar situation?
> Dr B
John,
I figured I sorta' did in that response. Perhaps Michael T will re-post what I sent him, also.
I reconstruct... since it doesn't look like I saved the email, cuz' it's so fundamental (for me).
It is actually very simple. I'm pretty sure this is recommended in the first uSoft Excel VBA book I still have.
You use serial sorts, that is, several sorts, one after the other. You can get the same result as later versions of Excel that have many sort keys by sorting on the lower level column sort keys first, then sort columns, one-at-a-time working your way up the sort key list.
Excel sorts are done in such a way that early sort order is not changed when later sorts have matching sort keys.
Say Colums are
A = Last
B = First
C = Middle
D = Birth Date
E = Death Date
If Last names same, put in first name order. AND
If First names same, put in Middle name order, AND
If Middle names same, put in Birth Order...
He wanted people with the same First, Last and Middle names sorted by birth date. IF they had the same Birth Date, he wanted them in order of Death Date.
So do single column sorts in this (upward) order: E, D, C, B, A.
I even took his sample data and did a sheet to demonstrate (which I did keep if someone wants to look @ it)
Better?
--
73, Steve, K9DCI
Guess I'll be saving it in that spreadsheet this time...
> On 2 January 2012 19:04, noskosteve <noskosteve@...> wrote:
> >
> >
> > Solved.
> > The conversion appears to be an unnecessary restriction on the true problem. All he wants is a unique sort order where there are matching names. I emailed Robert and advised him of a simple recommended solution; serial sorts. If done correctly previous sort order is not disturbed for identical later sort items.
> >
> > 73, Steve N.
> >
> > --- In ExcelVBA@yahoogroups.com, Michael Trombetta <mickey11030@> wrote:
> >>
> >> Perhaps the simplest solution to this sorting problem is to upgrade to Excel 2007 or later. In these newer releases you can sort up to 64 levels.
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > ----------------------------------
> > Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
> >
> > ----------------------------------
> > Visit our ExcelVBA group home page for more info and support files:
> > http://groups.yahoo.com/group/ExcelVBA
> >
> > ----------------------------------
> > More free tutorials and resources available at:
> > http://www.mousetrax.com
> >
> > ----------------------------------Yahoo! Groups Links
> >
> >
> >
>
>
>
> --
> ===========================
> http://uk.linkedin.com/in/drjohnbullas
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar