Dynamic List (2).xlsx

	B	C	E	F	G	H	I	J	K	L	N	Q
1						Anna				AA
2		Mike				Betty		BB		BB	Column1
3						Carl				CC	AA
4						David				DD	BB
5						Ed				EE	CC
6						Fred				FF	DD
7						Gina				GG	EE
8						Harriet				HH	FF
9	=OFFSET(Sheet1!$H$1,0,0,COUNTA(Sheet1!$H$1:$H$100))					Inga	cad			II	GG
10						John	20			JJ	HH
11						Katie	30			jlklhjkjhlj	II
12				45		Larry	40				JJ
13				44		Mike	50				خخ
14				55			60				jhjjh
15				46			70		352
16							82
17
18												CC
19					David		82
20					Ed
21					Fred
22					Gina	RRR
23		name	yyyy		Harriet
24		Sally			Inga
25		Tina			John
26		Ursula			Katie
27		Vic			Larry
28		Wally			Mike
29		Xavier			RRR
30		Yolanda
31		Zoe
32		hanan
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100