Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i define data by another
hello, please i want to know how can i set a categories for example to
another data example; i want when to write red in a cell in a column the number 1 appears automatically in another column and when to write yellow number 2 apears ....etc thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i define data by another
=IF(A1="red",1,IF(A1="yellow",2, etc.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rasha" wrote in message ... hello, please i want to know how can i set a categories for example to another data example; i want when to write red in a cell in a column the number 1 appears automatically in another column and when to write yellow number 2 apears ...etc thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |