charmallan
New Member
- Joined
- Nov 14, 2015
- Messages
- 3
Hi. Sorry, new to this. Need to find a way to semi process some data. Perhaps easier to demo with a table.
My data is column A has changing values, ie site names is not a constant, but the rest of the text is. I have about 50 of these statements. Each of these statements can be associated with a specific keyword. What i would like to do, is ensure that column A is in the correct format. (Perhaps this can reference a list with set values to match ?) Then i need the data from column a to do something like, if a ="-Business Area - Type - Air Compressors" and Column B contains "air compressor" or Compressor", then Column C = Air compressor. Can this be done ? I'm trying to read up on these if , then and if else statements, but I cant get anything to work. Please help ?
<tbody>
</tbody>
My data is column A has changing values, ie site names is not a constant, but the rest of the text is. I have about 50 of these statements. Each of these statements can be associated with a specific keyword. What i would like to do, is ensure that column A is in the correct format. (Perhaps this can reference a list with set values to match ?) Then i need the data from column a to do something like, if a ="-Business Area - Type - Air Compressors" and Column B contains "air compressor" or Compressor", then Column C = Air compressor. Can this be done ? I'm trying to read up on these if , then and if else statements, but I cant get anything to work. Please help ?
A | B | C | D | E |
Site- Area - Type - Air Supply | Air Compressor | Air Compressor | ||
ST - Area - Type - Vents | Vent | Vent | ||
Site- Area - Type - x | Compressor, air | Air Compressor | ||
<tbody>
</tbody>