| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
autonumber column in excel
Can anyone help me out? One column should auto number starting from 1 as I
enter data on the second coulmn of the spread sheet. |
|
#2
|
|||
|
|||
|
If you're going to enter data in Column B, starting in B2,
Enter this formula in A2: =IF(B2<"",ROW(A1),"") And copy down as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Shan" wrote in message ... Can anyone help me out? One column should auto number starting from 1 as I enter data on the second coulmn of the spread sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel XP - 2 Column Pages | New Users to Excel | |||
| Excel: is it possible to move column contents into a line | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Linear Mode
