GET Unique, From Vertical to Horizontal

**ionelz** · 10-28-2019, 09:14 AM

In Column A, starting A1 :

L1
L1
L6
L6
L1
L6

I want : in B1:C1 to have L6 L1 (C1=L1, B1=L6)

**AliGW** · 10-28-2019, 09:16 AM

What's the logic here? Why should L6 come before L1?

**ionelz** · 10-28-2019, 09:22 AM

That is how I need it !

Or maybe more simple :
In Column A, B
A B

X L1
X L6
Y L1
Y L8
Z L2
Z L6

If C1=X then D1=L6, E1=L1

**AliGW** · 10-28-2019, 09:25 AM

This doesn't answer my question. Why should L6 come before L1? In the original list L1 is before L6.

**ionelz** · 10-28-2019, 09:26 AM

That is how I need it, from Right to Left !

**AliGW** · 10-28-2019, 09:28 AM

OK - that makes sense now that you have said "from right to left" - this was the crucial bit of information you failed to give before.

**KOKOSEK** · 10-28-2019, 01:12 PM

	A	B	C	D	E
1	X	L1	X	=IFERROR(INDEX($B$1:$B$6,AGGREGATE(14,6,IF($A$1:$A$6=$C$1,ROW($A$1:$A$6),""),COLUMN()-3)),"")	=IFERROR(INDEX($B$1:$B$6,AGGREGATE(14,6,IF($A$1:$A$6=$C$1,ROW($A$1:$A$6),""),COLUMN()-3)),"")
2	X	L6
3	Y	L1
4	Y	L8
5	Z	L2
6	Z	L6

Sheet: Sheet1

into D1:

Please Login or Register  to view this content.

is array formula so have to be accept with Ctrl+Shift+Enter not just Enter.
Then drag it right as needed.

Re: GET Unique, From Vertical to Horizontal