Row numbering

**MandyKoo** · 05-25-2012, 10:19 PM

I have created a spreadsheet in which row 1 consists of the column headers, such as "page number", "body corporate number" and so on.

Row 2 currently starts with the first field of information, which runs for several hundred rows.

The person for whom I've created this spreadsheet does not want the header row being row 1, because the purpose of the spreadsheet is to show how many entries there are, and it's out by one with the way it is now.

Is there any way I can reset the value of row 1, so that the first row starts on what now is row 2?

I hope that makes sense.

**protonLeah** · 05-25-2012, 10:57 PM

No. Insert a new column A with header "Record", then in cell A2, put =IF(B2<>"",ROW()-1,""), copy down as far as the number of records you expect or alway to the bottom of the sheet. The formula will only put in the number of the cell in column B of that row has data.