Extract Unique Values

[YasserKhalil]

Hello everybody
I have data in range (A1:A5) the value A and in range(A6:A10) the value B and in range(A11:A15) the value C

Three values in column A : A,B and C

In column B different values

A	s
A	f
A	d
A	d
A	f
B	r
B	q
B	u
B	t
B	x
C	n
C	m
C	k
C	p
C	p

<tbody>
</tbody>

I want to extract unique values of Column A to Column E
The result should be :
E1 : A E2: B E3: C

In F1 ,G1 and H1 the values should be : s f d
In F2 , G2 ,H2, I2 and J2 the values should be : r q u t x
In F3,G3,H3 and I3 the values should be: n m k p

I want the solution to be in formulas

Thanks advanced

 

[YasserKhalil]

I have inserted a row at first row and the formulas' results vanished
I tried to edit the formula but it's no use..

 

[YasserKhalil]

I have inserted a row at first row and the formulas' results vanished
I tried to edit the formula but it's no use..

Will I have to get rid of the first row agian to solve the problem or there is a solution? Please Help

 

[Aladin Akyurek]

Hello everybody
I have data in range (A1:A5) the value A and in range(A6:A10) the value B and in range(A11:A15) the value C

Three values in column A : A,B and C

In column B different values

A	s
A	f
A	d
A	d
A	f
B	r
B	q
B	u
B	t
B	x
C	n
C	m
C	k
C	p
C	p

<TBODY>
</TBODY>

I want to extract unique values of Column A to Column E
The result should be :
E1 : A E2: B E3: C

In F1 ,G1 and H1 the values should be : s f d
In F2 , G2 ,H2, I2 and J2 the values should be : r q u t x
In F3,G3,H3 and I3 the values should be: n m k p

I want the solution to be in formulas

Thanks advanced

E1, control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$1:$A$30,SMALL(IF(FREQUENCY(IF($A$1:$A$30<>"",
  MATCH($A$1:$A$30,$A$1:$A$30,0)),ROW($A$1:$A$30)-ROW($A$1)+1),
  ROW($A$1:$A$30)-ROW($A$1)+1),ROWS(E$1:E1))),"")

 

[royUK]

from what I see, he hasn't got headers, so i dont think it'd work...

A little time setting up the data correctly would make the task easier