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!
Bookmarks