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

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
 
R

Roger Govier

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
 
N

Niel

Thanks Roger,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top