rolling document number

  • Thread starter Thread starter Guest
  • Start date Start date
Dear Alan: I have a small solution for you if it works and you need it this
way.

Let's assume that you us A column for autonumbrer, B Column for Name and C
Colomn is for position or whatever as your last entry column, use the
following formula and copy in cell A2:

=IF(AND(A2="",C2=""),"",IF(C2="","",A2+1))

You can lock column A by protecting your sheet to not select lock cells then
if you want. I hope this would help you.
Best,
Daoud Fakhry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column 2 to transpose using column 1 as reference 2
Automatically update a number when printed 1
Help to build a table 5
how to filter by the first digit of list 1
Identifying missing numerical values in a series 6
Sorting with empty cells 5
Repeated Nos 1
Macro Help 4

Back
Top