How Can I Create A Dynamic List that Updates based upon certain Criteria?

[franswa3434]

Hi,

I am trying to create a dynamic list that automatically lists only both removes duplicates, as well as filters only by what is in the column next to it.

With my example below, I want all the blue and green items (blue as labeled in Column B) in Column A to be put into a list in Column E, and also remove all duplicates. This list also needs to be dynamic as more items are added to filter through and add only the "blue and green" items to the list.

Thank you anyone and everyone who is willing to help!

A</SPAN>	B</SPAN>	C</SPAN>	D</SPAN>	E</SPAN>
Item</SPAN>	Color</SPAN>			Blue and Green Items</SPAN>
Grass</SPAN>	Green</SPAN>			Grass
Water</SPAN>	Blue</SPAN>			Water
Fire</SPAN>	Red</SPAN>			Sky
Dirt</SPAN>	Brown</SPAN>			Go Light
Sky</SPAN>	Blue</SPAN>			Car
Go Light	Green
Car</SPAN>	Blue</SPAN>
water</SPAN>	Blue</SPAN>

<TBODY>
</TBODY>