N
Niel
I am trying to create a list of references in Column B based on values in
Column A. If the value in row 1 of Column A is not equal to zero I want it to
be "A", then if Row2 is not equal to zero I want it to be "B", if Row 3 is =
zero it must remain "B".
In other words it must only increment if the Row in Column A is not equal to
zero.
I manged to do that with numbers by adding 1 to the previous value if Column
A is not equal to zero, but I need it to be A,B,C not 1,2,3
Column A. If the value in row 1 of Column A is not equal to zero I want it to
be "A", then if Row2 is not equal to zero I want it to be "B", if Row 3 is =
zero it must remain "B".
In other words it must only increment if the Row in Column A is not equal to
zero.
I manged to do that with numbers by adding 1 to the previous value if Column
A is not equal to zero, but I need it to be A,B,C not 1,2,3