ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numbering Rows (https://www.excelbanter.com/excel-discussion-misc-queries/133053-numbering-rows.html)

[email protected]

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


chad

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