Doomglazer
New Member
- Joined
- Mar 17, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Im looking for a solution to this problem. In need to see when a certain badge number badges in for the first time and then for the last time. Its also important that the company name is visible.
This is just a snapshot from a period of one day but i need to be able to run it over a months worth of data.
Thanks in advance for the help
This is just a snapshot from a period of one day but i need to be able to run it over a months worth of data.
Thanks in advance for the help
testing.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ||||||
2 | Date and time | Badge nr | Company | |||
3 | 6/03/2022 0:31 | 322008125 | MPA_Buurtparkeren | |||
4 | ||||||
5 | 6/03/2022 0:53 | 322007289 | ||||
6 | ||||||
7 | 6/03/2022 0:53 | 322007289 | ||||
8 | ||||||
9 | 6/03/2022 0:53 | 322007289 | ||||
10 | ||||||
11 | 6/03/2022 0:55 | 322007289 | ||||
12 | ||||||
13 | 6/03/2022 1:17 | 25863 | SERIS | |||
14 | ||||||
15 | 6/03/2022 1:24 | 25912 | MPA_Buurtparkeren | |||
16 | ||||||
17 | 6/03/2022 1:29 | 25863 | SERIS | |||
18 | ||||||
19 | 6/03/2022 1:33 | 25863 | SERIS | |||
20 | ||||||
21 | 6/03/2022 1:33 | 25863 | SERIS | |||
22 | ||||||
23 | 6/03/2022 1:33 | 25863 | SERIS | |||
24 | ||||||
25 | 6/03/2022 1:34 | 25863 | SERIS | |||
26 | ||||||
27 | 6/03/2022 1:36 | 25863 | SERIS | |||
28 | ||||||
29 | 6/03/2022 1:39 | 322008129 | MPA_Buurtparkeren | |||
30 | ||||||
31 | 6/03/2022 1:41 | 25863 | SERIS | |||
32 | ||||||
33 | 6/03/2022 2:05 | 322004808 | MPA_Buurtparkeren | |||
34 | ||||||
35 | 6/03/2022 2:53 | 322007284 | ||||
36 | ||||||
37 | 6/03/2022 2:53 | 322007284 | ||||
38 | ||||||
39 | 6/03/2022 2:55 | 322007284 | ||||
40 | ||||||
41 | 6/03/2022 2:58 | 25863 | SERIS | |||
42 | ||||||
43 | 6/03/2022 3:06 | 25863 | SERIS | |||
44 | ||||||
45 | 6/03/2022 3:59 | 25863 | SERIS | |||
46 | ||||||
47 | 6/03/2022 4:25 | 25863 | SERIS | |||
48 | ||||||
49 | 6/03/2022 4:29 | 25863 | SERIS | |||
50 | ||||||
51 | 6/03/2022 4:31 | 25863 | SERIS | |||
52 | ||||||
53 | 6/03/2022 4:31 | 25863 | SERIS | |||
54 | ||||||
55 | 6/03/2022 4:32 | 25863 | SERIS | |||
56 | ||||||
57 | 6/03/2022 4:33 | 25863 | SERIS | |||
58 | ||||||
59 | 6/03/2022 4:33 | 25863 | SERIS | |||
60 | ||||||
61 | 6/03/2022 4:33 | 25863 | SERIS | |||
62 | ||||||
63 | 6/03/2022 4:34 | 25863 | SERIS | |||
64 | ||||||
65 | 6/03/2022 4:35 | 25863 | SERIS | |||
66 | ||||||
67 | 6/03/2022 4:35 | 25863 | SERIS | |||
68 | ||||||
69 | 6/03/2022 4:36 | 25863 | SERIS | |||
70 | ||||||
71 | 6/03/2022 4:36 | 25863 | SERIS | |||
72 | ||||||
73 | 6/03/2022 4:36 | 25863 | SERIS | |||
74 | ||||||
75 | 6/03/2022 4:37 | 25863 | SERIS | |||
76 | ||||||
77 | 6/03/2022 4:37 | 25863 | SERIS | |||
78 | ||||||
79 | 6/03/2022 4:37 | 25863 | SERIS | |||
80 | ||||||
81 | 6/03/2022 4:39 | 25863 | SERIS | |||
82 | ||||||
83 | 6/03/2022 4:56 | 322008121 | MPA_Buurtparkeren | |||
84 | ||||||
85 | 6/03/2022 4:58 | 322008121 | MPA_Buurtparkeren | |||
86 | ||||||
87 | 6/03/2022 5:36 | 25863 | SERIS | |||
88 | ||||||
89 | 6/03/2022 6:05 | 322004804 | MPA_Buurtparkeren | |||
90 | ||||||
91 | 6/03/2022 6:07 | 322004804 | MPA_Buurtparkeren | |||
92 | ||||||
93 | 6/03/2022 6:15 | 25863 | SERIS | |||
94 | ||||||
95 | 6/03/2022 6:15 | 25863 | SERIS | |||
96 | ||||||
97 | 6/03/2022 6:15 | 25863 | SERIS | |||
98 | ||||||
99 | 6/03/2022 6:15 | 25863 | SERIS | |||
Sheet1 |