extract data using formula

[smallxyz]

Excel 2010
	A	B	C	D	E	F	G	H
1	B	28		A	6		B	28
2	B	6		A	7		B	6
3	B	6		A	4		B	6
4	A	6		A	66		B	45
5	A	7		A	32		B	3
6	B	45		A	79
7	A	4
8	A	66
9	A	32
10	A	79
11	B	3
Sht

Col A-B is the original data.
Col D-E and Col G-H are results to be output using formula.
How should the formula be set?
Thanks!

 

[oldbrewer]

what are your rules - why is A6 the first selected

at present I can see you wish to separate the A's and B's

do you wish them to remain in their current order ?

is a macro solution acceptable ?

 

[AliGW]

Like this:

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F
1	B	28	A	6	B	28
2	B	6	A	7	B	6
3	B	6	A	4	B	6
4	A	6	A	66	B	45
5	A	7	A	32	B	3
6	B	45	A	79
7	A	4
8	A	66
9	A	32
10	A	79
11	B	3
Sheet3

Cell Formulas
Range	Formula
C1	{=IFERROR(INDEX(A:A,SMALL(IF($A$1:$A$11="A",ROW($A$1:$A$11)),ROWS($A$1:A1))),"")}
D1	{=IFERROR(INDEX(B:B,SMALL(IF($A$1:$A$11="A",ROW($A$1:$A$11)),ROWS($A$1:A1))),"")}
E1	{=IFERROR(INDEX(A:A,SMALL(IF($A$1:$A$11="B",ROW($A$1:$A$11)),ROWS($A$1:A1))),"")}
F1	{=IFERROR(INDEX(B:B,SMALL(IF($A$1:$A$11="B",ROW($A$1:$A$11)),ROWS($A$1:A1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[smallxyz]

Hi oldbrewer,
It is to separate the data with respect to A & B while remaining their original structure of order .
We need a Excel formula.

 

[AliGW]

See above.

 

[smallxyz]

THANK YOU!!!!!! AliGW !!!!

 

[AliGW]

You're welcome!