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]

Yes, there is a comma

 

[Fluff]

Ok, so that's not the problem. If you type =Le into a cell, is LET one of the options?

 

[RodneyC]

Yes you do. If you type =SUM( into a cell, look at the tool tip, what does it show separating the arguments?

Yes, there is a comma =SUM(number1,number2, and so on.

 

[RodneyC]

Ok, so that's not the problem. If you type =Le into a cell, is LET one of the options?

No LET is not one of the options. I have LEFT and LEN

 

[Fluff]

Ok, that's the problem.
Before I try & re-jig the formula do you have the UNIQUE function?

 

[RodneyC]

Ok, that's the problem.
Before I try & re-jig the formula do you have the UNIQUE function?

I typed =UN and UNIQUE is not an option UNICHAR and UNICODE are.

 

[Fluff]

In that case it sounds as though you are not using xl 365. In which case I would advise updating your profile to show the version that you are using.

 

[Fluff]

Another option for older versions of Excel

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	COLOR	GROUP			Group 1	Group 2	Group 3
2	Green	1			Green	Yellow	Black
3	Blue	1			Blue	Orange	White
4	Yellow	2			Red	Tangerine	Silver
5	Orange	2			Purple	Magenta	Lime
6	Tangerine	2				Brown	Banana
7	Red	1
8	Black	3
9	Magenta	2
10	Brown	2
11	White	3
12	Silver	3
13	Purple	1
14	Lime	3
15	Banana	3
16
Data

Cell Formulas
Range	Formula
E2:G8	E2	=IFERROR(INDEX($A$2:$A$15,AGGREGATE(15,6,(ROW($A$2:$A$15)-ROW($A$2)+1)/($B$2:$B$15=COLUMNS($E$2:E$2)),ROWS(E$2:E2))),"")

 

[RodneyC]

That worked and profile updated to show Excel 2016, THANK YOU SO MUCH for your help.

 

[Fluff]

You're welcome & thanks for the feedback.