Count names in columns sample data

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	U	V	W	X	Y	Z
1	Form survey Date	Class	Students name	1ST FRIEND	2ND FRIEND	3RD FRIEND	4TH FRIEND	5TH FRIEND	Times Chosen	Concatenated data results	Friend 1 reciprocal	Friend 2 reciprocal	Friend 3 reciprocal	Friend 4 reciprocal	Friend 5 reciprocal	Surveys Completed	No of times chosen	Friend 1 reciprocal	Friend 2 reciprocal	Friend 3 reciprocal	Friend 4 reciprocal	Friend 5 reciprocal

2	24/05/2019	1.1	Wegner	Wagner	Yuette	Aleta	Dortha	Santos	0	Wagner Yuette Aleta Dortha Santos						1	0		Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Cruz Dortha	Aleta Yuette Cruz David	Cruz Lisbeth Aleta David	0
3	24 May 2019	1.1	Yuette	Chery	Lisbeth	Gilbert	David	Dallas	7	Chery Lisbeth Gilbert David Dallas			1		1	1	7		David Chery Aleta Dortha Dallas	Chery Yuette Cruz Dortha Santos	Chery Lisbeth Cruz Dortha Santos	Rueben Yuette Aleta David Cruz	0
4	22 May 2019	1.1	Cruz	Rueben	Lisbeth	Aleta	David	Santos	9	Rueben Lisbeth Aleta David Santos	1		1	1	1	1	9	Chery Yuette Cruz David Dale	David Chery Aleta Dortha Dallas	Rueben Lisbeth Cruz Dortha	Chery Lisbeth Cruz Dortha Santos	Cruz Lisbeth Aleta David	1
5	23 May 2019	1.1	David	Chery	Lisbeth	Cruz	Dortha	Santos	7	Chery Lisbeth Cruz Dortha Santos		1	1	1	1	1	7		David Chery Aleta Dortha Dallas	Rueben Lisbeth Aleta David Santos	Aleta Yuette Cruz David	Cruz Lisbeth Aleta David	0
6	24 May 2019	1.1	Dallas	Rueben	Yuette	Aleta	David	Cruz	2	Rueben Yuette Aleta David Cruz		1				1	2	Chery Yuette Cruz David Dale	Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Cruz Dortha	Chery Lisbeth Cruz Dortha Santos	Rueben Lisbeth Aleta David Santos	0
7	27 May 2019	1.1	Rueben	Chery	Yuette	Cruz	David	Dale	5	Chery Yuette Cruz David Dale			1			1	5		Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Aleta David Santos	Chery Lisbeth Cruz Dortha Santos		0
8	24 May 2019	1.1	Lisbeth	David	Chery	Aleta	Dortha	Dallas	5	David Chery Aleta Dortha Dallas	1		1			1	5	Chery Lisbeth Cruz Dortha Santos		Rueben Lisbeth Cruz Dortha	Aleta Yuette Cruz David	Rueben Yuette Aleta David Cruz	1
9	23 May 2019	1.1	Aleta	Rueben	Lisbeth	Cruz	Dortha		6	Rueben Lisbeth Cruz Dortha		1	1	1		1	6	Chery Yuette Cruz David Dale	David Chery Aleta Dortha Dallas	Rueben Lisbeth Aleta David Santos	Aleta Yuette Cruz David		0
10	23 May 2019	1.1	Dortha	Aleta	Yuette	Cruz	David		7	Aleta Yuette Cruz David	1			1		1	7	Rueben Lisbeth Cruz Dortha	Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Aleta David Santos	Chery Lisbeth Cruz Dortha Santos		1
11	23 May 2019	1.1	Santos	Cruz	Lisbeth	Aleta	David		6	Cruz Lisbeth Aleta David	1			1		1	6	Rueben Lisbeth Aleta David Santos	David Chery Aleta Dortha Dallas	Rueben Lisbeth Cruz Dortha	Chery Lisbeth Cruz Dortha Santos		1
12	22 May 2019	1.1	Gilbert	Chery	Yuette	Cruz	Dortha	Santos	1	Chery Yuette Cruz Dortha Santos		1				1	1		Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Aleta David Santos	Aleta Yuette Cruz David	Cruz Lisbeth Aleta David	0
13	22 May 2019	1.1	Andrew	Rueben	Yuette	Cruz	Dortha	Santos	0	Rueben Yuette Cruz Dortha Santos						1	0	Chery Yuette Cruz David Dale	Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Aleta David Santos	Aleta Yuette Cruz David	Cruz Lisbeth Aleta David	0
14	22 May 2019	1.1	Dallas	Rueben	Yuette	Cruz	Dortha	Santos	2	Rueben Yuette Cruz Dortha Santos		1				2	2	Chery Yuette Cruz David Dale	Chery Lisbeth Gilbert David Dallas	Rueben Lisbeth Aleta David Santos	Aleta Yuette Cruz David	Cruz Lisbeth Aleta David	0
15	23 Sep 2019	1.1	Dale	Rueben	Yuette	Aleta			0	Rueben Yuette Aleta						1	0	Chery Cruz Aleta					0
16	24 Sep 2019	1.1	Chery	Rueben	Cruz	David			1	Rueben Cruz David	1					1	1	Chery Cruz Aleta					1
17	24 Sep 2019	1.1	Rueben	Chery	Cruz		Aleta		2	Chery Cruz Aleta	1					2	2	Rueben Cruz David					1
18	3 Oct 2019	1.1	Wegner	Rueben	Cruz		Aleta		0	Rueben Cruz Aleta						2	0						0
19
20
21
22
23
24
25
26
27
28
29
30
31
32
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