View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niel
 
Posts: n/a
Default 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