Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to time | Excel Discussion (Misc queries) | |||
convert letters to numbers | Charts and Charting in Excel | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |