| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sequent number
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 תודה רבה |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sequent number
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 תודה רבה |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sequent number
thank you !!!
-- תודה רבה "KC Rippstein" wrote: 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 תודה רבה |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Number in a Column Using Arrays? | Excel Discussion (Misc queries) | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
