It sounds like you should set up your data as a list. Just go to Data -
Create List. Then using A2:A10 as an example of your current list of ID's,
you could do two things:
Give A2:A10 a name like ID_List and then show the latest ID at the top
using =LOOKUP(2,1/(ID_List<""),ID_List).
In A10, put =A9+1. Whenever you add a new entry to the list (where the
blue asterisk is) this formula automatically carries down (to A11, A12, etc.).
The problem with that is if you override that automated number to type one
in of your own, then the formula is lost in the last row and will no longer
carry down. If you are going to override the number occasionally, you need
to have a helper column called OverrideID (maybe in column B). Then you can
put in A10 =IF(B10="",A9+1,B10).

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"יריב החביב" wrote:

hello,
is there any kod wich will give us as defult
the sequnt 'id' number of the 'id' number in the latest record ?
--
thank you

תודה רבה