Hi Forum,
This was originally posted on another forum a few days ago and was unable to be resolved.
Due to large complex spreadsheet and calculations switched off looking for vba code if possible to populate column c.
<tbody>
</tbody>
If a Machine (column B) only produces one type of product (columnA) then looking for it to return the product in column A i.e. product C, If a machine produces more than one product then hoping for the code to return the word Mixed (i.e. Machine B produces two products A & B so it is mixed products). The same machine may have more than 1 occurance in column B, there is 8000+ rows and looking for vba code to populate C (hoping please to keep the spreadsheet as is, i.e. not remove duplicates in B or sort etc). I then intend to do a lookup based on the Machine in another sheet to find out if it only produces one or multiple products (this I can do).
If anyone can think of a solution that would be great
Thanks Forum
This was originally posted on another forum a few days ago and was unable to be resolved.
Due to large complex spreadsheet and calculations switched off looking for vba code if possible to populate column c.
Column A | Column B | Column C (code to return) |
ProductC | MachineA | ProductC |
ProductC | MachineA | ProductC |
ProductC | MachineA | ProductC |
ProductA | MachineB | Mixed |
ProductC | MachineB | Mixed |
etc | etc | etc |
<tbody>
</tbody>
If a Machine (column B) only produces one type of product (columnA) then looking for it to return the product in column A i.e. product C, If a machine produces more than one product then hoping for the code to return the word Mixed (i.e. Machine B produces two products A & B so it is mixed products). The same machine may have more than 1 occurance in column B, there is 8000+ rows and looking for vba code to populate C (hoping please to keep the spreadsheet as is, i.e. not remove duplicates in B or sort etc). I then intend to do a lookup based on the Machine in another sheet to find out if it only produces one or multiple products (this I can do).
If anyone can think of a solution that would be great
Thanks Forum
Last edited: