Ottsel
Board Regular
- Joined
- Jun 4, 2022
- Messages
- 174
- Office Version
- 365
- Platform
- Windows
Tried to search around to find a solution for this, but perhaps I'm not phrasing it correctly.
Below is a table of numbers. I want to count each one, but not twice. So, with this example I need the result to give me 11.
Below is a table of numbers. I want to count each one, but not twice. So, with this example I need the result to give me 11.
Employee List.xlsx | |||
---|---|---|---|
F | |||
2 | 101 | ||
3 | 101 | ||
4 | 101 | ||
5 | 101 | ||
6 | 101 | ||
7 | 101 | ||
8 | 101 | ||
9 | 101 | ||
10 | 101 | ||
11 | 101 | ||
12 | 101 | ||
13 | 101 | ||
14 | 101 | ||
15 | 101 | ||
16 | 101 | ||
17 | 101 | ||
18 | 101 | ||
19 | 101 | ||
20 | 101 | ||
21 | 101 | ||
22 | 101 | ||
23 | 112 | ||
24 | 112 | ||
25 | 113 | ||
26 | 113 | ||
27 | 114 | ||
28 | 115 | ||
29 | 115 | ||
30 | 115 | ||
31 | 115 | ||
32 | 115 | ||
33 | 116 | ||
34 | 116 | ||
35 | 117 | ||
36 | 117 | ||
37 | 117 | ||
38 | 117 | ||
39 | 117 | ||
40 | 117 | ||
41 | 118 | ||
42 | 118 | ||
43 | 118 | ||
44 | 118 | ||
45 | 118 | ||
46 | 119 | ||
47 | 119 | ||
48 | 119 | ||
49 | 120 | ||
50 | 120 | ||
51 | 122 | ||
Sheet1 |