Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
I am trying to import categorical data into a spreadsheet. I need the
categorical data to import as numerical values (i.e. white = 1, black = 2, hispanic = 3, etc.) Is there a way to do this using conditional formatting? If not, please offer a different suggestion. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
Nope, theres nothing you really can do with conditional formatting for this.
The only thing I can think of is just import the data, then in a new column write out the formula to change those text values to numbers... like If(A1="white",1,If(A1="black",2,etc or you can put the numerical values next to the colors and use vlookup up, such as Vlookup(A1,array,2,FALSE) Where the array is the list of colors and there values. "KSP" wrote: I am trying to import categorical data into a spreadsheet. I need the categorical data to import as numerical values (i.e. white = 1, black = 2, hispanic = 3, etc.) Is there a way to do this using conditional formatting? If not, please offer a different suggestion. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting.... | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |