I'd like to be able to select a sequence of rows and automatically
have a cell in a specific column contain a numbers corresponding to
each row. The first row would have "1", second row "2", etc.
I'm trying to use this to fix a certain order in the spreadsheet
containing data does not respond to conventional sorting.

Dale Hoffman

try using =column() to put the column number in a cell.

hope this helps!
-chad

" wrote:

I'd like to be able to select a sequence of rows and automatically
have a cell in a specific column contain a numbers corresponding to
each row. The first row would have "1", second row "2", etc.
I'm trying to use this to fix a certain order in the spreadsheet
containing data does not respond to conventional sorting.

Dale Hoffman