Need data for similar names

[sksanjeev786]

Hi Team

I have similar name in Column A and I need Column B data based on Column A

Below is the example E, F is my output

Book3
	A	B	C	D	E	F
2	Sanjeev	A
3	Sanjeev	B			Sanjeev	A
4	Vijay	E			Sanjeev	B
5	Sanjeev	D			Sanjeev	D
6	Sanjeev	E			Sanjeev	E
7	Sanjeev	F			Sanjeev	F
8	Vijay	G			Sanjeev	M
9	Rahul	H
10	Vijay	I
11	Vijay	J
12	Rahul	K
13	Vijay	L
14	Sanjeev	M
Sheet1

Regards
Sanjeev

 

[Kerryx]

Book1
	A	B	C	D
1	Sanjeev	A
2	Sanjeev	B	Sanjeev	A
3	Vijay	E	Sanjeev	B
4	Sanjeev	D	Sanjeev	D
5	Sanjeev	E	Sanjeev	E
6	Sanjeev	F	Sanjeev	F
7	Vijay	G	Sanjeev	M
8	Rahul	H
9	Vijay	I
10	Vijay	J
11	Rahul	K
12	Vijay	L
13	Sanjeev	M
Sheet1

Cell Formulas
Range	Formula
C2:D7	C2	=FILTER(A1:B13,A1:A13="Sanjeev")
Dynamic array formulas.

 

[sksanjeev786]

Book1
	A	B	C	D
1	Sanjeev	A
2	Sanjeev	B	Sanjeev	A
3	Vijay	E	Sanjeev	B
4	Sanjeev	D	Sanjeev	D
Sheet1

[/X

Book1
Sheet1

R][XR][XH]5[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Sanjeev[/XD][XD=h:l|v:m|fz:10pt|cls:ww]E[/XD][XD=h:l|v:m|cls:spill ww|tx:]Sanjeev[/XD][XD=h:l|v:m|cls:spill ww|tx:]E[/XD]

[XR][XH]6[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Sanjeev[/XD][XD=h:l|v:m|fz:10pt|cls:ww]F[/XD][XD=h:l|v:m|cls:spill ww|tx:]Sanjeev[/XD][XD=h:l|v:m|cls:spill ww|tx:]F[/XD][/XR][XR][XH]7[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Vijay[/XD][XD=h:l|v:m|fz:10pt|cls:ww]G[/XD][XD=h:l|v:m|cls:spill ww|tx:]Sanjeev[/XD][XD=h:l|v:m|cls:spill ww|tx:]M[/XD][/XR][XR][XH]8[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Rahul[/XD][XD=h:l|v:m|fz:10pt|cls:ww]H[/XD][XD][/XD][XD][/XD][/XR][XR][XH]9[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Vijay[/XD][XD=h:l|v:m|fz:10pt|cls:ww]I[/XD][XD][/XD][XD][/XD][/XR][XR][XH]10[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Vijay[/XD][XD=h:l|v:m|fz:10pt|cls:ww]J[/XD][XD][/XD][XD][/XD][/XR][XR][XH]11[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Rahul[/XD][XD=h:l|v:m|fz:10pt|cls:ww]K[/XD][XD][/XD][XD][/XD][/XR][XR][XH]12[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Vijay[/XD][XD=h:l|v:m|fz:10pt|cls:ww]L[/XD][XD][/XD][XD][/XD][/XR][XR][XH]13[/XH][XD=h:l|v:m|ch:15|fz:10pt|cls:ww]Sanjeev[/XD][XD=h:l|v:m|fz:10pt|cls:ww]M[/XD][XD][/XD][XD][/XD][/XR]

Cell Formulas
Range	Formula
C2:D7	C2	=FILTER(A1:B13,A1:A13="Sanjeev")
Dynamic array formulas.

Thank you so much!!!