Populate a column based on values in two other columns

[RodneyC]

I have a list of items in $A$2:$A$15 In column $B$2:$B$15 there is a for the corresponding value in A. The value in column B allows me to define what “group” the item in column A belongs to.

In column E, I want a list of items in each group. From the screen shot below, you can see the idea. I’ve color coded this simply for ease of explanation, no coloring is needed when finished. I’m thinking I may need separate codes for each group. The values in column B are likely to change over time... if I change B2 to 3 instead of 1 as it currently is, it would automatically be moved out of Group 1 into Group 3 in column E

I'm needing something in E2:E5 that looks for items in column B with the value “1” and if it’s there, populate the cells with the appropriate value in column A. I would need a similar formula would be needed for Group 2 and so on.

Thinking ahead, it’s not important what order these are displayed in, I’m assuming it would do it based on the order these are displayed on column A.

Thank you in advance

 

[RodneyC]

What does the red code refer to?

=IFERROR(INDEX($A$5:$A$18,AGGREGATE(15,6,(ROW($A$5:$A$18)-ROW($A$5)+1)/($B$5:$B$18=COLUMNS($D$5:D$5)),ROWS(D$5:D5))),"")

 

[Fluff]

The 15 tells the aggregate function to act like the small function & the 6 tells it to ignore errors.

 

[RodneyC]

Thank you

 

[Fluff]

You're welcome.