Problems Sorting Grouped records

H

HJ

You might get a couple of responses on this, some using VB
code.

My solution seems to work pretty well, ASSUMING that cells
in column A (the name column) are blank except for the
first name record in a set.

If so...
1. Add two columns to the record set, say column E and
F. If data starts in A1, set E1 =A1 (the person's name)
and set F1=1.
2. In E2 enter: =IF(A2="",E1,A2). In F2 enter: =IF
(A2="",F1+1,1)
3. Copy E2 and F2 down to the end of the data. You
should see an echo of the person's name and a sequence
number for each record in that person's record set. The
sequence starts over with a new name when the name changes
from blank to the next name in column A.
4. CRITICAL STEP - When you get the correct results in
columns E and F, do a copy and Paste Special of the values
in Columns E and F. You must do this to replace the
formulas with hard values!
5. You can now sort the entire data set on columns E and
F.

Let me know if you need more explanation. Hope this works
for you.

HJ
 
Top