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

franswa3434

Board Regular
Joined
Sep 16, 2014
Messages
69
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>
 
Last edited:

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,109,005
Messages
5,526,233
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top