Simple formula I think

**grant862** · 08-13-2007, 05:09 PM

I have a list in Column A that i want to associate numbers to. Its about 2000 entries(rows) long. and the list starts on row 11. So for my first entry in row 11 I want to associate 1 to that entry and row 12, the number 2 and so on....so essentially i need a formula to equal [row 233 + 11 equals 244]

I want to create this formula so i dont have to type 233,234,235,236,237... for every entry i have. Thanks

picture below to show what im talking about

or if theres a easier way to do this as well that would be greatly appreciated. Thank you

**oldchippy** · 08-13-2007, 05:29 PM

In B10 type 21, in B11 type

=B10+1, then with the cell selected double click on the bottom right hand corner of the cell when your cursor changes to a black cross. This will auto-fill column B as long as you have data in the adjacent column A