How to Add Automatic Sequential Numbers When Typing Data in Google Sheets | Google Sheets tutorials
The steps for adding serial numbers automatically when typing data in Google Sheets are as follows:
1. Prepare the columns or arrangement of data to be created, for example, such as column numbers and names,
2. Click or select the column that will be used to make serial numbers, for example in column A2,
3. Type the formula =IF(B2＜＞"",ROW()-ROW($A$1),"")
4. Press Enter,
5. Copy the formula by dragging or dragging it from column A2 down according to the amount of data you want to create,
6. Done.
As info, the written formula contains the information "B2" and "$A$1". B2 is the column of the first name data or to the right of the first number column, namely A2. $A$1 is column A1 which has been locked after selecting it by manually typing ($) or pressing the F4 key after selecting column A1. The information for B2 and A1 itself can be adjusted according to the data that you will create.
Hope it is useful.