![]() |
Numbering Rows
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 |
Numbering Rows
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 |
All times are GMT +1. The time now is 07:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com