| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining a Text field based on its condition
I have a db with customer names that have not been populated the same way in
each field. I would like to be able to look @ the name in the field and in another field in another column give it an identifier or group id. The logic statement needs to check the condition and determine what to populate in the "new column" based on what is in the "existing column" Example Existing Column New Column ABC Co Team #1 XYZ Inc Team #2 abc co Team #1 XYZ Team #2 thanks, C.Hirsch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
