Hi
I need some help on a formula to generate a reference number.
Basically, I need a formula that looks if there is a value other than 0 in collum A and then creates a reference number in collum A that is 1+ the previous value.
So if there is a value that is not 0 in D3 A3 has to have a reference number like A3 has FEB001
If for example the value in D is 0 like in D5 A should be empty like A5 is
But if Example D5 had a value of not 0 then A5 should be FEB003 and A14 will then be FEB004 and so on
I need some help on a formula to generate a reference number.
Basically, I need a formula that looks if there is a value other than 0 in collum A and then creates a reference number in collum A that is 1+ the previous value.
So if there is a value that is not 0 in D3 A3 has to have a reference number like A3 has FEB001
If for example the value in D is 0 like in D5 A should be empty like A5 is
But if Example D5 had a value of not 0 then A5 should be FEB003 and A14 will then be FEB004 and so on