List up cells problem

[ManuW]

Hello there,
Forum newbie here... In fact pretty much an excel newbie as well.I have a problem.
My excel sheet has data like this:

	A	B
1	a	aa
2	b	bb
3	a	ab
4	b	bb
5	a	aa

Now I want a formula that gives me all the values of column B that are in the same row like a and b: e.g something like that

	A	B	C	D	E
1	a	aa	ab	aa
2	b	bb	bb
3

And now I´ll come to the tricky part..
I also want a formula that checks if all the outputs contain the same text.
In my example it would check if B1:D1 contain the same text and therefore would say: "FALSE" because C1 contains "ab" instead of "aa"
But the same formula should check B2:D2 (don´t regarding empty cells) and should give me a "TRUE" because B2 and C2 contain the same text "bb"

	A	B	C	D	E
1	a	aa	ab	aa	FALSE
2	b	bb	bb		TRUE
3

I hope I have made it clear and you can help me.
Thank you very much!
Greeting Manú

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H
1	A	B
2	a	aa	a	aa	ab	aa		FALSE
3	b	bb	b	bb	bb			TRUE
4	a	ab
5	b	bb
6	a	aa
7
Master

Cell Formulas
Range	Formula
C2:C3	C2	=UNIQUE(FILTER(A2:A10,A2:A10<>""))
D2:F2,D3:E3	D2	=TRANSPOSE(FILTER(B2:B10,A2:A10=C2))
H2:H3	H2	=COUNTIF(D2#,D2)=COUNTA(D2#)
Dynamic array formulas.

 

[ManuW]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H
1	A	B
2	a	aa	a	aa	ab	aa		FALSE
3	b	bb	b	bb	bb			TRUE
4	a	ab
5	b	bb
6	a	aa
7
Master

Cell Formulas
Range	Formula
C2:C3	C2	=UNIQUE(FILTER(A2:A10,A2:A10<>""))
D2:F2,D3:E3	D2	=TRANSPOSE(FILTER(B2:B10,A2:A10=C2))
H2:H3	H2	=COUNTIF(D2#,D2)=COUNTA(D2#)
Dynamic array formulas.

Hey Fluff,

thank you for your fast reply!
You helped me a lot!
Is it possible that I will get only the unique cells?

	A	B	C
1	a	aa	ab
2	b	bb
instead of
	A	B	C	D
1	a	aa	ab	aa
2	b	bb	bb

In fact I want to delete duplicates!
I tried to use the data tool "remove duplicates" but I think it will only work on rows and not on my columns..
My third step, checking if the rows are containing the same text wouldnt be necessary if i would only get the unique cell texts.

Again: thank you very much for your help!
Greetings Manú

 

[Fluff]

How about

=TRANSPOSE(UNIQUE(FILTER(B2:B10,A2:A10=C2)))

 

[ManuW]

Perfect!
I could have thought of that too! Again thank you

 

[Fluff]

You're welcome & thanks for the feedback.