Dino wrote...
One problem is that I have to re-sort according to different criteria
constantly. I have many other columns in the spreadsheet that I have
to sort
by. So the solution would have to be one that would not be affected by
the
names being ungrouped.

If you'd be resorting constantly, would you be expecting the numbers
corresponding to the names to vary after each sort? If not, sort by
name and use Alan Beban's original formula, then copy the range of
numbers and paste special as values onto itself to 'freeze' those
numbers. If you need the numbers constantly changing, see the formulas
in my later posts in this thread.