Example: I have a table with multiple rows like below
| Fruit | Type | Attributes |
|---|---|---|
| Apple | Ambrosia | Sweet, Crisp |
| Orange | Valencia | Sweet, Thin skin |
| Apple | PaulaRed | Tart |
| Pear | Bartlett | Sweet, Soft |
| Apple | Pink Lady | Sweet, Crisp |
What I'm trying to do (using VBA) is loop through the first column (Fruit). Find every cell that contains 'Apple'. Then from there check the 'Attributes' column (for only Apple!) and store the attributes of Apples (I'm assuming in an array? but key thing is to not store the attribute if it is already in the array, I need one instance of each attribute it finds). From there I'm trying to display those unique attributes in another table.
I'm new to VBA so let me know if you have any ideas, insight, or useful resources. Thank you in advanced.