In A1 enter =ROW()

Copy down a bunch of rows.

When you sort on the name column, the 1, 2, 3 in Column A will remain the
same.


Gord Dibben MS Excel MVP

On Wed, 3 Dec 2008 11:46:46 -0800, Gary
wrote:

I have a list of names and have column a set up as a number series 1 ....
designating their number in the list. When i enter a new name I would like
to sort the list but not sort the 1 .... numbers so the new list will show
each person's correct place in the list.