Automatic Sequential numbers
I believe you want consecutive numbers with blanks in Col A if Col B is
blank...
You can do this but with a helper column... Say Col Z
enter 10 in Z1
and this in Z2
=IF(B2<0,Z1+1,Z1)
and copy down
Now enter this in A1
=IF(B1<"","TC/0"&Z1,"")
and copy down...
"Neni" wrote:
I need to create a formula that will fill in automatically the sequential
number FC/010, FC/011, FC/012 on the cell next to the one where I insert
information.
Ex.
Contract number Contract title
TC/010 Supply of uniforms
TC/011 Courier services
TC/012 Supply of cleaning services
Supply of paper
As I type the contract title on cell B the contract number should fill in
automatically on cell A
So far I've only managed to get a logical formula that does the function but
filling sequential numbers without letters, 1,2,3,4
=IF(ISTEXT(B2),ROW()," ")
I've also searched the excel help tool, and I found that it would be
possible through using VBA functions which I have no idea how to do. Far too
advanced for me...
Any easier solution?
--
Greetings from Australia
|