Spreadsheet: 836919d1689719927-alternative-formula-subtotal-for-hidden-column-book1
Sheet: Blad1

# | RS | Topic | Dimension | Art 1 | Art 2
 | I want to search for "#" and link that value to "RS".  "#" and "RS" are located in sheet 3 and sheet 4.  It would be convenient if the results of the found values from sheet 3 and sheet 4 are displayed in column B of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result. | I want to search for "#" and link that value to "topics".  "#" and "topics" are located in sheet 2.  It would be great if the results of the found values from sheet 2 are displayed in column C of sheet 1. Duplicate values should be omitted.  An example of the result is provided in the cell below. | I want to search for "#" and link that value to "Dimension".  "#" and "Dimension" are located in sheet 2.  It would be great if the results of the found values from sheet 2 are displayed in column D of sheet 1. Duplicate values should be omitted.  An example of the result is provided in the cell below. | I want to search for "#" and link that value to "Art 1".  "#" and "Art 1" are located in sheet 3.  It would be convenient if the results of the found values from sheet 3 are displayed in column E of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result. | I want to search for "#" and link that value to "Art 2".  "#" and "Art 2" are located in sheet 4.  It would be convenient if the results of the found values from sheet 3 are displayed in column F of sheet 1. Duplicate values should be omitted.  Below, in the green cell, is an example of the expected result.
1 |  | Information Protection | Process, Management, Employees, | 27001:2022 5.1, 27001:2022 5.3, | 27002:2022 5.1, 27002:2022 75.10, 27002:2022 7.7
2 | 6.46, 6.58, 6.78
3 | 6.04, 6.08, 6.4, 6.81
4 | 6.38, 6.46
5 | 6.38, 6.46
6 | 6.67
7 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.67
8 | 6.01, 6.02, 6.03, 6.04, 6.08, 6.09, 6.13, 6.14, 6.17, 6.18, 6.2, 6.21, 6.22, 6.35, 6.39, 6.4, 6.46, 6.63, 6.69, 6.7, 6.71, 6.72, 6.73, 6.74, 8.85
9 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12, 5.14, 6.12, 6.38, 6.39, 6.4, 6.46, 6.77
10 | 5.07, 6.04, 6.08, 6.17, 6.2, 6.38, 6.39, 6.4, 6.41, 6.46, 8.85
11 | 6.2, 6.36, 6.38, 6.46, 6.81, 6.82
12 | 6.37, 6.53, 6.64, 6.65
13 | 5.08, 6.1, 6.11, 6.83
14 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44
15 | 6.02, 6.11, 9.01, 9.02
16 | 6.02, 6.11, 9.01, 9.02
17 | 6.04, 6.08, 6.1, 6.11, 6.36, 6.4, 6.47, 6.7
18 | 6.6
19 | 6.17, 9.03
20 | 6.38, 6.46, 6.53, 6.55, 6.69
21 | 6.71
22 | 6.12, 6.18, 6.21, 6.23, 6.3, 6.31
23 | 6.35, 6.74
24 | 6.38, 6.44, 6.77
25
26 | 6.46, 6.47
27 | 6.46, 6.7
28 | 6.46
29 | 6.46, 6.6, 6.63
30 | 5.05, 5.11, 5.12, 5.14, 6.12, 6.38, 6.39, 6.4, 6.46, 6.77
31 | 6.46
32 | 6.01, 6.02, 6.03, 6.04, 6.06, 6.08, 6.09, 6.13, 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.31, 6.35, 6.36, 6.38, 6.39, 6.4, 6.41, 6.42, 6.44, 6.47, 6.7, 6.71, 6.73, 6.76, 6.77
33 | 6.12, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.3, 6.31, 6.43, 6.72, 6.73
34 | 6.04, 6.06, 6.08, 6.12, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.3, 6.31, 6.35, 6.36, 6.38, 6.39, 6.4, 6.42, 6.43, 6.44, 6.7, 6.71, 6.72, 6.73, 6.74, 6.77
35 | 5.08, 6.05, 6.06, 6.07, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.83
36 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.47
37
38 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.74
39 | 6.84
40 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.21
41 | 6.22
42 | 6.6
43 | 5.01, 6.31, 6.34
44 | 6.07, 6.17, 6.2, 6.31, 6.35, 6.36, 6.44
45 | 6.1, 6.11
46 | 6.08, 6.39, 6.4
47 | 6.01, 6.02, 6.03, 6.09, 6.13
48 | 6.17, 6.22, 6.4
49 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12, 6.67, 6.81
50 | 5.05, 5.11, 5.12, 6.05, 6.06, 6.07, 6.12, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.39, 6.4, 6.42, 6.43, 6.44, 6.63, 6.66
51
52 | 6.05, 6.06, 6.07, 6.15, 6.25, 6.3, 6.32, 6.33, 6.35, 6.36, 6.37, 6.42, 6.43, 6.44, 6.45, 6.46, 6.48, 6.58, 6.61
53 | 6.46, 6.64, 8.85
54 | 6.41, 6.47
55 | 6.34, 6.41, 6.47
56 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.24, 6.25, 6.33, 6.41, 6.42, 6.45
57 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.24, 6.25, 6.33, 6.38, 6.41, 6.42, 6.45, 6.55
58 | 6.14, 6.15, 6.17, 6.18, 6.19, 6.2, 6.21, 6.22, 6.23, 6.24, 6.25, 6.33, 6.41, 6.42, 6.45
59 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.21
60 | 6.05, 6.66
61 | 6.02, 6.11, 6.64, 6.65, 6.66, 9.01, 9.02
62 | 5.05, 5.11, 5.12, 6.05, 6.06, 6.07, 6.12, 6.15, 6.25, 6.32, 6.33, 6.35, 6.36, 6.37, 6.39, 6.4, 6.42, 6.43, 6.44, 6.45, 6.63, 6.66
63 | 6.68
64 | 5.1, 6.69
65 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12, 6.69
66 | 6.17, 6.22, 6.4
67 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.21
68 | 6.17
69 | 5.01, 6.31
70 | 6.07, 6.17, 6.2, 6.31, 6.35, 6.36, 6.44
71 | 6.04, 6.08, 6.39, 6.4, 6.41, 6.47
72 | 5.08, 6.09, 6.1, 6.11, 6.83
73 | 6.02, 6.11, 9.01, 9.02
74 | 6.7
75 | 6.1, 6.11
76 | 5.1
77 | 5.08, 6.17, 6.83
78 | 6.12, 6.18, 6.21, 6.23, 6.3, 6.31
79 | 6.38, 6.44, 6.77
80 | 6.18, 6.23, 6.3, 6.72
81 | 6.18, 6.21
82 | 6.15, 6.2, 6.36, 6.42
83 | 6.35, 6.74
84 | 6.75
85 | 6.04, 6.08, 6.4, 6.81
86
87
88
89
90 | 6.64, 6.65
91 | 6.01, 6.02, 6.03, 6.09, 6.13, 6.14, 6.17, 6.18, 6.2, 6.21, 6.22, 6.68, 6.73
92 | 6.37, 6.66
93 | 6.52, 6.58, 6.6, 6.61
94 | 6.47, 6.58
95 | 6.79
96 | 6.15, 6.2, 6.36, 6.42
97 | 5.1
98 | 6.12, 6.18, 6.21, 6.23, 6.3, 6.31, 6.43
99 | 6.33, 6.38, 6.45, 6.46, 6.53, 6.55, 6.69
100
101 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12, 6.01, 6.02, 6.03, 6.09, 6.13
102
103
104
105
106
107
108 | 6.35
109 | 6.26, 6.27, 6.28, 6.35
110 | 6.07, 6.26, 6.27, 6.28, 6.35, 6.44
111 | 5.05, 5.11, 5.12, 6.12, 6.39, 6.4
112 | 6.34, 6.45
113
114 | 6.17, 9.03
115 | 6.41, 6.47
116 | 6.17
117 | 6.17, 6.22, 6.4
118 | 6.17
119 | 6.17
120
121
122
123
124
125 | 6.38, 6.44, 6.46, 6.77
126 | 6.18
127 | 6.23, 6.3
128 | 6.23, 6.3
129 | 6.26, 6.27, 6.28
130 | 6.06, 6.15, 6.42
131 | 6.76
132 | 5.07, 6.17, 6.2, 6.38
133 | 5.04, 5.05, 5.06, 5.07, 5.08, 5.09, 5.11, 5.12
134 | 6.52, 6.61
135 | 6.38
136 | 6.38, 6.57, 6.61
137 | 6.52
138 | 6.52
139 | 6.56, 6.62
140 | 6.6, 6.61
141 | 6.6
142 | 5.08, 6.1, 6.11, 6.83
143
144 | 5.08, 6.1, 6.11, 6.83
145 | 6.29, 6.33, 6.48, 6.52, 6.58, 6.59, 6.61, 6.62
146
147 | 6.48