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. The first step that must be taken is to prepare a worksheet that contains data, for example a simple worksheet with column data for number and name,
2. Click or select the cell that will be used to create serial number data, for example in cell A2,
3. Type the formula =IF(B2＜＞"",ROW()-ROW($A$1),"") , then press the Enter key on the keyboard,
5. Copy the formula that was created earlier by dragging or dragging it from cell 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 cell of the first name data or to the right of the first cell number, namely A2. Meanwhile $A$1 is cell A1 which has been locked after selecting it by manually typing the sign ($) or by pressing the F4 key on the keyboard after selecting cell A1. The descriptions for B2 and A1 can be adjusted according to the data you will create.
Also, as additional info, when you delete data randomly, later the serial numbers generated using the formula above will still look sequential or not random.
Hope it is useful.