Convert numbers 1,2,3,etc to A,B,C,etc.
 

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

Convert numbers 1,2,3,etc to A,B,C,etc.
 

Hi Niel

Provided you could accept a space " " as opposed to null "" in the event
of A1 being zero, then in B1
=IF(A1=0," ","A")
and in B2
=IF(A2=0,B1,CHAR(MAX(64,CODE(B1))+1))
and copied down as far as required


--
Regards

Roger Govier


"Niel" wrote in message
...
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

Convert numbers 1,2,3,etc to A,B,C,etc.
 

Thanks Roger,

The CHAR and CODE functions is what I was looking for.
Works like a charm.

"Roger Govier" wrote:

Hi Niel

Provided you could accept a space " " as opposed to null "" in the event
of A1 being zero, then in B1
=IF(A1=0," ","A")
and in B2
=IF(A2=0,B1,CHAR(MAX(64,CODE(B1))+1))
and copied down as far as required


--
Regards

Roger Govier


"Niel" wrote in message
...
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