Jay has attended:
Excel Intermediate course
Excel Advanced course
Purchase numbers
say you was buying items and you wanted to give each one a purchase number in order or entering a new item
so lets say you had entered in 1-9 purchase numbers in so:
1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred
i want it so when i filled in number 9 number 10 appeared
so it would look like
1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred
10
if i started to enter in fred on 10 then a 11 would appear like :
1 fred
2 fred
3 fred
4 fred
5 fred
6 fred
7 fred
8 fred
9 fred
10 f
11
so therefore i dont have to drag down and it prevents errors
and its allways in order from the last one which before was Blank
regards
Jay
RE: Purchase numbers
Hi Jay
Thanks for getting in touch. Excel has no built-in ability to create Autonumbers. Any solution will be formula-driven and require dragging down. Here are some suggestions:
http://superuser.com/questions/130274/autonumbering-a-column-in-excel
One way to avoid dragging down would be to convert the data into a Table (Home > Format as Table) but there may be some other properties of the table you don't want (such as formatting or structured reference formulas).
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
