Hello,

First time poster here. I am hoping someone can help me with adding to or modifying a formula. I currently have a formula that builds a list of items for me that fall under a certain criteria, but includes duplicates. I am looking to see if I can add to this formula, so that duplicate values do not show up.

Here's my current formula (you will see I am referencing 2 tabs in a single Excel file):
=INDEX('Product Roadmap'!$B$7:$B$1107, SMALL(IF('Component Roadmap'!$A$3='Product Roadmap'!$A$7:$A$1107, ROW('Product Roadmap'!$A$7:$A$1107)-ROW('Product Roadmap'!$A$7)+1), ROW(1:1)))

So instead of the list ending up looking like:

apples
bananas
peaches
bananas

I want the final list to look like:
apples
bananas
peaches

Hope I provided enough info!