H
Hardy
Is there a way of getting a autonumber column to start at a particular value?
eg 950
eg 950
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
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
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
H
Hardy
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?
the formula is =IF(A2<>"",ROW(B1),"") whish starts the autonumbers at 1 but
they would like it to start at 950?
R
Roger Govier
Hi
Then just add 949 to the start value.
=IF(A2<>"",ROW(B1)+949,"")
Regards
Roger Govier
Then just add 949 to the start value.
=IF(A2<>"",ROW(B1)+949,"")
Regards
Roger Govier
G
Gord Dibben
Hardy
=IF(A2<>"",ROW(B950),"")
Gord Dibben Excel MVP
=IF(A2<>"",ROW(B950),"")
Gord Dibben Excel MVP