I was trying to set yp a formula that will automaticaly extend a series.
I mean will add a sequential number to the one above.
If I have in cell A1: CD001
I want to place a formula that will show me: CD002 in cell A2.
I tried n function but it only converts it to the number and comes uout as 0.
I don't know which one to use if there is any.
Answer to the first question I will probably be asked:
No I cannot drag it down with a mouse as I will place it in the conditional function afterall.
If anyone has any idea please help me out.
Thanks for reading this thread.