| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column of Data - Set Next Column Value Conditionally
Column A contains text data ... unlimited set of values. Column B contains a limited set of values, depending on the value of column A. The Column B values are pre-set by another program. I would like to _change_ the value of a column B cell if the column A value equals a certain value. Otherwise the column B value should stay as is. How can I do that? Example Data Set COL-A COL-B AAA horse BBB cow CCC donkey DDD dog BBB cow MMM cat Situation If COL-A value = DDD, would like to change value in COL-B from donkey to mule -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=542932 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
