| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autonumber
Is there a way of getting a autonumber column to start at a particular value?
eg 950 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autonumber
I'm guessing that you are asking a MS Access question....
If that's true...I think this site has what you're looking for: http://www.databasedev.co.uk/reset_autonumber.html Does that help? *********** Regards, Ron "Hardy" wrote: Is there a way of getting a autonumber column to start at a particular value? eg 950 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autonumber
No the person wants it in excel (for some strange reason!)
the formula is =IF(A2<"",ROW(B1),"") whish starts the autonumbers at 1 but they would like it to start at 950? "Ron Coderre" wrote: I'm guessing that you are asking a MS Access question.... If that's true...I think this site has what you're looking for: http://www.databasedev.co.uk/reset_autonumber.html Does that help? *********** Regards, Ron "Hardy" wrote: Is there a way of getting a autonumber column to start at a particular value? eg 950 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autonumber
Hi
Then just add 949 to the start value. =IF(A2<"",ROW(B1)+949,"") Regards Roger Govier Hardy wrote: No the person wants it in excel (for some strange reason!) the formula is =IF(A2<"",ROW(B1),"") whish starts the autonumbers at 1 but they would like it to start at 950? "Ron Coderre" wrote: I'm guessing that you are asking a MS Access question.... If that's true...I think this site has what you're looking for: http://www.databasedev.co.uk/reset_autonumber.html Does that help? *********** Regards, Ron "Hardy" wrote: Is there a way of getting a autonumber column to start at a particular value? eg 950 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autonumber
Hardy
=IF(A2<"",ROW(B950),"") Gord Dibben Excel MVP On Thu, 24 Nov 2005 07:46:30 -0800, "Hardy" wrote: =IF(A2<"",ROW(B1),"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autonumber column in excel | Excel Discussion (Misc queries) | |||
| How can I autonumber in excel? | Excel Discussion (Misc queries) | |||
| how to autonumber excel worksheets as 'Page X of Y' | Excel Discussion (Misc queries) | |||
| Autonumber in Forms while printing | Excel Discussion (Misc queries) | |||
| autonumber values | Excel Worksheet Functions | |||
Linear Mode
