| 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 |
| 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 | |||
Threaded Mode
