I am trying to find the way of making a formula that will auto generate the "id" number like we do in mySql auto-generate.
If I explain more, it would be like (number of A1 + 1).
You can try this formula,
=SUM((INDIRECT("A" & ROW() – 1)),1)
** Here A is the Column.
How it works:
You have to put a number on a cell of A coulumn then the very next row of that A column you will put this Formula. Then you should get the number + 1. Which will look like MySql auto generated id.
Then you can just grab the blue dot/point of the cell which is lower right of the cell, and expand it to lower of the A column, and it will generate numbers like MySql auto generated id.