Selecting the FIRST and LAST time readings from the daily card readings and ignoring the other ones

D

Doomglazer

New Member
Joined
Mar 17, 2022
Messages
11
Office Version
  1. 365
Platform
  1. 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


testing.xls
ABCD
1
2Date and timeBadge nrCompany
36/03/2022 0:31322008125MPA_Buurtparkeren
4
56/03/2022 0:53322007289
6
76/03/2022 0:53322007289
8
96/03/2022 0:53322007289
10
116/03/2022 0:55322007289
12
136/03/2022 1:1725863SERIS
14
156/03/2022 1:2425912MPA_Buurtparkeren
16
176/03/2022 1:2925863SERIS
18
196/03/2022 1:3325863SERIS
20
216/03/2022 1:3325863SERIS
22
236/03/2022 1:3325863SERIS
24
256/03/2022 1:3425863SERIS
26
276/03/2022 1:3625863SERIS
28
296/03/2022 1:39322008129MPA_Buurtparkeren
30
316/03/2022 1:4125863SERIS
32
336/03/2022 2:05322004808MPA_Buurtparkeren
34
356/03/2022 2:53322007284
36
376/03/2022 2:53322007284
38
396/03/2022 2:55322007284
40
416/03/2022 2:5825863SERIS
42
436/03/2022 3:0625863SERIS
44
456/03/2022 3:5925863SERIS
46
476/03/2022 4:2525863SERIS
48
496/03/2022 4:2925863SERIS
50
516/03/2022 4:3125863SERIS
52
536/03/2022 4:3125863SERIS
54
556/03/2022 4:3225863SERIS
56
576/03/2022 4:3325863SERIS
58
596/03/2022 4:3325863SERIS
60
616/03/2022 4:3325863SERIS
62
636/03/2022 4:3425863SERIS
64
656/03/2022 4:3525863SERIS
66
676/03/2022 4:3525863SERIS
68
696/03/2022 4:3625863SERIS
70
716/03/2022 4:3625863SERIS
72
736/03/2022 4:3625863SERIS
74
756/03/2022 4:3725863SERIS
76
776/03/2022 4:3725863SERIS
78
796/03/2022 4:3725863SERIS
80
816/03/2022 4:3925863SERIS
82
836/03/2022 4:56322008121MPA_Buurtparkeren
84
856/03/2022 4:58322008121MPA_Buurtparkeren
86
876/03/2022 5:3625863SERIS
88
896/03/2022 6:05322004804MPA_Buurtparkeren
90
916/03/2022 6:07322004804MPA_Buurtparkeren
92
936/03/2022 6:1525863SERIS
94
956/03/2022 6:1525863SERIS
96
976/03/2022 6:1525863SERIS
98
996/03/2022 6:1525863SERIS
Sheet1
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
How do you determine which badge number to find?
 
Upvote 0
How about
+Fluff 1.xlsm
ABCDEFGHIJK
1
2Date and timeBadge nrCompanyBadgeFirstLastCompany
306/03/2022 00:31322008125MPA_Buurtparkeren32200812506/03/2022 00:3106/03/2022 00:31MPA_Buurtparkeren
432200728906/03/2022 00:5306/03/2022 00:55 
506/03/2022 00:533220072892586306/03/2022 01:1706/03/2022 06:15SERIS
62591206/03/2022 01:2406/03/2022 01:24MPA_Buurtparkeren
706/03/2022 00:5332200728932200812906/03/2022 01:3906/03/2022 01:39MPA_Buurtparkeren
832200480806/03/2022 02:0506/03/2022 02:05MPA_Buurtparkeren
906/03/2022 00:5332200728932200728406/03/2022 02:5306/03/2022 02:55 
1032200812106/03/2022 04:5606/03/2022 04:58MPA_Buurtparkeren
1106/03/2022 00:5532200728932200480406/03/2022 06:0506/03/2022 06:07MPA_Buurtparkeren
12
1306/03/2022 01:1725863SERIS
14
1506/03/2022 01:2425912MPA_Buurtparkeren
16
1706/03/2022 01:2925863SERIS
18
1906/03/2022 01:3325863SERIS
20
2106/03/2022 01:3325863SERIS
22
2306/03/2022 01:3325863SERIS
24
2506/03/2022 01:3425863SERIS
26
2706/03/2022 01:3625863SERIS
28
2906/03/2022 01:39322008129MPA_Buurtparkeren
30
3106/03/2022 01:4125863SERIS
32
3306/03/2022 02:05322004808MPA_Buurtparkeren
34
3506/03/2022 02:53322007284
36
3706/03/2022 02:53322007284
38
3906/03/2022 02:55322007284
40
4106/03/2022 02:5825863SERIS
42
4306/03/2022 03:0625863SERIS
44
4506/03/2022 03:5925863SERIS
46
4706/03/2022 04:2525863SERIS
48
4906/03/2022 04:2925863SERIS
50
5106/03/2022 04:3125863SERIS
52
5306/03/2022 04:3125863SERIS
54
5506/03/2022 04:3225863SERIS
56
5706/03/2022 04:3325863SERIS
58
5906/03/2022 04:3325863SERIS
60
6106/03/2022 04:3325863SERIS
62
6306/03/2022 04:3425863SERIS
64
6506/03/2022 04:3525863SERIS
66
6706/03/2022 04:3525863SERIS
68
6906/03/2022 04:3625863SERIS
70
7106/03/2022 04:3625863SERIS
72
7306/03/2022 04:3625863SERIS
74
7506/03/2022 04:3725863SERIS
76
7706/03/2022 04:3725863SERIS
78
7906/03/2022 04:3725863SERIS
80
8106/03/2022 04:3925863SERIS
82
8306/03/2022 04:56322008121MPA_Buurtparkeren
84
8506/03/2022 04:58322008121MPA_Buurtparkeren
86
8706/03/2022 05:3625863SERIS
88
8906/03/2022 06:05322004804MPA_Buurtparkeren
90
9106/03/2022 06:07322004804MPA_Buurtparkeren
92
9306/03/2022 06:1525863SERIS
94
9506/03/2022 06:1525863SERIS
96
9706/03/2022 06:1525863SERIS
98
9906/03/2022 06:1525863SERIS
Sheet3
Cell Formulas
RangeFormula
H3:H11H3=UNIQUE(FILTER(C3:C1000,C3:C1000<>""))
I3:I11I3=MINIFS(B:B,C:C,H3#)
J3:J11J3=MAXIFS(B:B,C:C,H3#)
K3:K11K3=INDEX(FILTER($D$3:$D$1000,($C$3:$C$1000=H3)*($D$3:$D$1000<>""),""),1)
Dynamic array formulas.
 
Upvote 0
Fluff said:
How about
+Fluff 1.xlsm
ABCDEFGHIJK
1
2Date and timeBadge nrCompanyBadgeFirstLastCompany
306/03/2022 00:31322008125MPA_Buurtparkeren32200812506/03/2022 00:3106/03/2022 00:31MPA_Buurtparkeren
432200728906/03/2022 00:5306/03/2022 00:55 
506/03/2022 00:533220072892586306/03/2022 01:1706/03/2022 06:15SERIS
62591206/03/2022 01:2406/03/2022 01:24MPA_Buurtparkeren
706/03/2022 00:5332200728932200812906/03/2022 01:3906/03/2022 01:39MPA_Buurtparkeren
832200480806/03/2022 02:0506/03/2022 02:05MPA_Buurtparkeren
906/03/2022 00:5332200728932200728406/03/2022 02:5306/03/2022 02:55 
1032200812106/03/2022 04:5606/03/2022 04:58MPA_Buurtparkeren
1106/03/2022 00:5532200728932200480406/03/2022 06:0506/03/2022 06:07MPA_Buurtparkeren
12
1306/03/2022 01:1725863SERIS
14
1506/03/2022 01:2425912MPA_Buurtparkeren
16
1706/03/2022 01:2925863SERIS
18
1906/03/2022 01:3325863SERIS
20
2106/03/2022 01:3325863SERIS
22
2306/03/2022 01:3325863SERIS
24
2506/03/2022 01:3425863SERIS
26
2706/03/2022 01:3625863SERIS
28
2906/03/2022 01:39322008129MPA_Buurtparkeren
30
3106/03/2022 01:4125863SERIS
32
3306/03/2022 02:05322004808MPA_Buurtparkeren
34
3506/03/2022 02:53322007284
36
3706/03/2022 02:53322007284
38
3906/03/2022 02:55322007284
40
4106/03/2022 02:5825863SERIS
42
4306/03/2022 03:0625863SERIS
44
4506/03/2022 03:5925863SERIS
46
4706/03/2022 04:2525863SERIS
48
4906/03/2022 04:2925863SERIS
50
5106/03/2022 04:3125863SERIS
52
5306/03/2022 04:3125863SERIS
54
5506/03/2022 04:3225863SERIS
56
5706/03/2022 04:3325863SERIS
58
5906/03/2022 04:3325863SERIS
60
6106/03/2022 04:3325863SERIS
62
6306/03/2022 04:3425863SERIS
64
6506/03/2022 04:3525863SERIS
66
6706/03/2022 04:3525863SERIS
68
6906/03/2022 04:3625863SERIS
70
7106/03/2022 04:3625863SERIS
72
7306/03/2022 04:3625863SERIS
74
7506/03/2022 04:3725863SERIS
76
7706/03/2022 04:3725863SERIS
78
7906/03/2022 04:3725863SERIS
80
8106/03/2022 04:3925863SERIS
82
8306/03/2022 04:56322008121MPA_Buurtparkeren
84
8506/03/2022 04:58322008121MPA_Buurtparkeren
86
8706/03/2022 05:3625863SERIS
88
8906/03/2022 06:05322004804MPA_Buurtparkeren
90
9106/03/2022 06:07322004804MPA_Buurtparkeren
92
9306/03/2022 06:1525863SERIS
94
9506/03/2022 06:1525863SERIS
96
9706/03/2022 06:1525863SERIS
98
9906/03/2022 06:1525863SERIS
Sheet3
Cell Formulas
RangeFormula
H3:H11H3=UNIQUE(FILTER(C3:C1000,C3:C1000<>""))
I3:I11I3=MINIFS(B:B,C:C,H3#)
J3:J11J3=MAXIFS(B:B,C:C,H3#)
K3:K11K3=INDEX(FILTER($D$3:$D$1000,($C$3:$C$1000=H3)*($D$3:$D$1000<>""),""),1)
Dynamic array formulas.
Click to expand...
Hey

thank you for the help but i cant seem to get it correct.
As you can see the first one is correct but evrything after that isent anymore.

Map1
ABCDEFGHIJKL
1
2date and timeBadge nrCompanyBadgeFirstLastCompany
36/03/2022 0:31322008125MPA_Buurtparkeren3220081256/03/2022 0:316/03/2022 0:31MPA_Buurtparkeren
43220072896/03/2022 0:536/03/2022 0:55 
56/03/2022 0:533220072893220072896/03/2022 0:536/03/2022 0:55 
63220072896/03/2022 0:536/03/2022 0:55 
76/03/2022 0:533220072893220072896/03/2022 0:536/03/2022 0:55 
83220072896/03/2022 0:536/03/2022 0:55 
96/03/2022 0:533220072893220072896/03/2022 0:536/03/2022 0:55 
103220072896/03/2022 0:536/03/2022 0:55 
116/03/2022 0:553220072893220072896/03/2022 0:536/03/2022 0:55 
12258636/03/2022 1:176/03/2022 6:15SERIS
136/03/2022 1:1725863SERIS258636/03/2022 1:176/03/2022 6:15SERIS
14259126/03/2022 1:246/03/2022 1:24MPA_Buurtparkeren
156/03/2022 1:2425912MPA_Buurtparkeren
16
176/03/2022 1:2925863SERIS
18
196/03/2022 1:3325863SERIS
20
216/03/2022 1:3325863SERIS
22
236/03/2022 1:3325863SERIS
24
256/03/2022 1:3425863SERIS
26
276/03/2022 1:3625863SERIS
28
296/03/2022 1:39322008129MPA_Buurtparkeren
30
316/03/2022 1:4125863SERIS
32
336/03/2022 2:05322004808MPA_Buurtparkeren
34
356/03/2022 2:53322007284
36
376/03/2022 2:53322007284
38
396/03/2022 2:55322007284
40
416/03/2022 2:5825863SERIS
42
436/03/2022 3:0625863SERIS
44
456/03/2022 3:5925863SERIS
46
476/03/2022 4:2525863SERIS
48
496/03/2022 4:2925863SERIS
50
516/03/2022 4:3125863SERIS
52
536/03/2022 4:3125863SERIS
54
556/03/2022 4:3225863SERIS
56
576/03/2022 4:3325863SERIS
58
596/03/2022 4:3325863SERIS
60
616/03/2022 4:3325863SERIS
62
636/03/2022 4:3425863SERIS
64
656/03/2022 4:3525863SERIS
66
676/03/2022 4:3525863SERIS
68
696/03/2022 4:3625863SERIS
70
716/03/2022 4:3625863SERIS
72
736/03/2022 4:3625863SERIS
74
756/03/2022 4:3725863SERIS
76
776/03/2022 4:3725863SERIS
78
796/03/2022 4:3725863SERIS
80
816/03/2022 4:3925863SERIS
82
836/03/2022 4:56322008121MPA_Buurtparkeren
84
856/03/2022 4:58322008121MPA_Buurtparkeren
86
876/03/2022 5:3625863SERIS
88
896/03/2022 6:05322004804MPA_Buurtparkeren
90
916/03/2022 6:07322004804MPA_Buurtparkeren
92
936/03/2022 6:1525863SERIS
94
956/03/2022 6:1525863SERIS
96
976/03/2022 6:1525863SERIS
98
996/03/2022 6:1525863SERIS
100
Blad1
Cell Formulas
RangeFormula
H3:H14H3=UNIQUE(FILTER(C3:C1000,C3:C1000<>""))
I3:I14I3=MINIFS(B:B,C:C,H3#)
J3:J14J3=MAXIFS(B:B,C:C,H3#)
K3:K14K3=INDEX(FILTER($D$3:$D$1000,($C$3:$C$1000=H3)*($D$3:$D$1000<>""),""),1)
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Clear cells H3:J14 then put the formulae back in H3:J3 only, but do not use Ctrl Shift Enter
 
Upvote 0
Hey Fluff

Thanks it works now but as i stated in my original question it works perfect for one day of data. But i also need it to work on a months worth of data. This means from 01/../2022 till the 31/../2022.
So per day i need the first and last entry of that badge number. And this for every day. If its something completly new ill make a new post and mark your answer as the solution as it is for one day.
Below is infor pasted for 2 days:

Map1
ABCDEFGHIJKLM
1
2date and Timebadge nrCompanyBadgeFirstLastCompany
36/03/2022 0:31322008125MPA_Buurtparkeren3220081256/03/2022 0:317/03/2022 19:15MPA_Buurtparkeren
43220072896/03/2022 0:537/03/2022 12:15 
56/03/2022 0:53322007289258636/03/2022 1:177/03/2022 13:27SERIS
6259126/03/2022 1:247/03/2022 17:34MPA_Buurtparkeren
76/03/2022 0:533220072893220081296/03/2022 1:396/03/2022 1:39MPA_Buurtparkeren
83220048086/03/2022 2:056/03/2022 2:05MPA_Buurtparkeren
96/03/2022 0:533220072893220072846/03/2022 2:536/03/2022 2:55 
103220081216/03/2022 4:566/03/2022 4:58MPA_Buurtparkeren
116/03/2022 0:553220072893220048046/03/2022 6:056/03/2022 6:07MPA_Buurtparkeren
12
136/03/2022 1:1725863SERIS
14
156/03/2022 1:2425912MPA_Buurtparkeren
16
176/03/2022 1:2925863SERIS
18
196/03/2022 1:3325863SERIS
20
216/03/2022 1:3325863SERIS
22
236/03/2022 1:3325863SERIS
24
256/03/2022 1:3425863SERIS
26
276/03/2022 1:3625863SERIS
28
296/03/2022 1:39322008129MPA_Buurtparkeren
30
316/03/2022 1:4125863SERIS
32
336/03/2022 2:05322004808MPA_Buurtparkeren
34
356/03/2022 2:53322007284
36
376/03/2022 2:53322007284
38
396/03/2022 2:55322007284
40
416/03/2022 2:5825863SERIS
42
436/03/2022 3:0625863SERIS
44
456/03/2022 3:5925863SERIS
46
476/03/2022 4:2525863SERIS
48
496/03/2022 4:2925863SERIS
50
516/03/2022 4:3125863SERIS
52
536/03/2022 4:3125863SERIS
54
556/03/2022 4:3225863SERIS
56
576/03/2022 4:3325863SERIS
58
596/03/2022 4:3325863SERIS
60
616/03/2022 4:3325863SERIS
62
636/03/2022 4:3425863SERIS
64
656/03/2022 4:3525863SERIS
66
676/03/2022 4:3525863SERIS
68
696/03/2022 4:3625863SERIS
70
716/03/2022 4:3625863SERIS
72
736/03/2022 4:3625863SERIS
74
756/03/2022 4:3725863SERIS
76
776/03/2022 4:3725863SERIS
78
796/03/2022 4:3725863SERIS
80
816/03/2022 4:3925863SERIS
82
836/03/2022 4:56322008121MPA_Buurtparkeren
84
856/03/2022 4:58322008121MPA_Buurtparkeren
86
876/03/2022 5:3625863SERIS
88
896/03/2022 6:05322004804MPA_Buurtparkeren
90
916/03/2022 6:07322004804MPA_Buurtparkeren
92
936/03/2022 6:1525863SERIS
94
956/03/2022 6:1525863SERIS
96
976/03/2022 6:1525863SERIS
98
996/03/2022 6:1525863SERIS
100
1017/03/2022 0:15322008125MPA_Buurtparkeren
102
1037/03/2022 1:15322007289
104
1057/03/2022 7:1525863SERIS
106
1077/03/2022 6:1525912MPA_Buurtparkeren
108
1097/03/2022 6:15322007289
110
1117/03/2022 14:1525912MPA_Buurtparkeren
112
1137/03/2022 17:3425912MPA_Buurtparkeren
114
1157/03/2022 12:15322007289
116
1177/03/2022 13:2725863SERIS
118
1197/03/2022 19:15322008125MPA_Buurtparkeren
Blad1
Cell Formulas
RangeFormula
H3:H11H3=UNIQUE(FILTER(C3:C1000,C3:C1000<>""))
I3:I11I3=MINIFS(B:B,C:C,H3#)
J3:J11J3=MAXIFS(B:B,C:C,H3#)
K3:K11K3=INDEX(FILTER($D$3:$D$1000,($C$3:$C$1000=H3)*($D$3:$D$1000<>""),""),1)
Dynamic array formulas.
 
Upvote 0
You never said you needed it on a day by day basis, which makes it more complex.
I'll have a look at it tomorrow if nobody else steps in as I'll be going out shortly
 
Upvote 0
Ok, how about
+Fluff 1.xlsm
ABCDEFGHIJK
1
2date and Timebadge nrCompanyDateBadgeFirstLastCompany
306/03/2022 00:31322008125MPA_Buurtparkeren06/03/202232200812506/03/2022 00:3106/03/2022 00:31MPA_Buurtparkeren
406/03/202232200728906/03/2022 00:5306/03/2022 00:55 
506/03/2022 00:5332200728906/03/20222586306/03/2022 01:1706/03/2022 06:15SERIS
606/03/20222591206/03/2022 01:2406/03/2022 01:24MPA_Buurtparkeren
706/03/2022 00:5332200728906/03/202232200812906/03/2022 01:3906/03/2022 01:39MPA_Buurtparkeren
806/03/202232200480806/03/2022 02:0506/03/2022 02:05MPA_Buurtparkeren
906/03/2022 00:5332200728906/03/202232200728406/03/2022 02:5306/03/2022 02:55 
1006/03/202232200812106/03/2022 04:5606/03/2022 04:58MPA_Buurtparkeren
1106/03/2022 00:5532200728906/03/202232200480406/03/2022 06:0506/03/2022 06:07MPA_Buurtparkeren
1207/03/202232200812507/03/2022 00:1507/03/2022 19:15MPA_Buurtparkeren
1306/03/2022 01:1725863SERIS07/03/202232200728907/03/2022 01:1507/03/2022 12:15 
1407/03/20222586307/03/2022 07:1507/03/2022 13:27SERIS
1506/03/2022 01:2425912MPA_Buurtparkeren07/03/20222591207/03/2022 06:1507/03/2022 17:34MPA_Buurtparkeren
16
1706/03/2022 01:2925863SERIS
18
1906/03/2022 01:3325863SERIS
20
2106/03/2022 01:3325863SERIS
22
2306/03/2022 01:3325863SERIS
24
2506/03/2022 01:3425863SERIS
26
2706/03/2022 01:3625863SERIS
28
2906/03/2022 01:39322008129MPA_Buurtparkeren
30
3106/03/2022 01:4125863SERIS
32
3306/03/2022 02:05322004808MPA_Buurtparkeren
34
3506/03/2022 02:53322007284
36
3706/03/2022 02:53322007284
38
3906/03/2022 02:55322007284
40
4106/03/2022 02:5825863SERIS
42
4306/03/2022 03:0625863SERIS
44
4506/03/2022 03:5925863SERIS
46
4706/03/2022 04:2525863SERIS
48
4906/03/2022 04:2925863SERIS
50
5106/03/2022 04:3125863SERIS
52
5306/03/2022 04:3125863SERIS
54
5506/03/2022 04:3225863SERIS
56
5706/03/2022 04:3325863SERIS
58
5906/03/2022 04:3325863SERIS
60
6106/03/2022 04:3325863SERIS
62
6306/03/2022 04:3425863SERIS
64
6506/03/2022 04:3525863SERIS
66
6706/03/2022 04:3525863SERIS
68
6906/03/2022 04:3625863SERIS
70
7106/03/2022 04:3625863SERIS
72
7306/03/2022 04:3625863SERIS
74
7506/03/2022 04:3725863SERIS
76
7706/03/2022 04:3725863SERIS
78
7906/03/2022 04:3725863SERIS
80
8106/03/2022 04:3925863SERIS
82
8306/03/2022 04:56322008121MPA_Buurtparkeren
84
8506/03/2022 04:58322008121MPA_Buurtparkeren
86
8706/03/2022 05:3625863SERIS
88
8906/03/2022 06:05322004804MPA_Buurtparkeren
90
9106/03/2022 06:07322004804MPA_Buurtparkeren
92
9306/03/2022 06:1525863SERIS
94
9506/03/2022 06:1525863SERIS
96
9706/03/2022 06:1525863SERIS
98
9906/03/2022 06:1525863SERIS
100
10107/03/2022 00:15322008125MPA_Buurtparkeren
102
10307/03/2022 01:15322007289
104
10507/03/2022 07:1525863SERIS
106
10707/03/2022 06:1525912MPA_Buurtparkeren
108
10907/03/2022 06:15322007289
110
11107/03/2022 14:1525912MPA_Buurtparkeren
112
11307/03/2022 17:3425912MPA_Buurtparkeren
114
11507/03/2022 12:15322007289
116
11707/03/2022 13:2725863SERIS
118
11907/03/2022 19:15322008125MPA_Buurtparkeren
Sheet3
Cell Formulas
RangeFormula
G3:H15G3=LET(a,CHOOSE({1,2},INT(B3:B1000),C3:C1000),UNIQUE(FILTER(a,INDEX(a,,1)<>0)))
I3:I15I3=MIN(IF((INT($B$3:$B$1000)=G3)*($C$3:$C$1000=H3),$B$3:$B$1000))
J3:J15J3=MAX(IF((INT($B$3:$B$1000)=G3)*($C$3:$C$1000=H3),$B$3:$B$1000))
K3:K15K3=INDEX(FILTER($D$3:$D$1000,($C$3:$C$1000=H3)*($D$3:$D$1000<>""),""),1)
Dynamic array formulas.
 
Upvote 0
Solution
Fluff

thanks yet again for yout work. But im having trouble with the formula of G3. I cant get it to work. The other formulas in I3,J3 and K3 worked after i manually inputted the data in Cells G3 and H3.
Down below my excel:

test1234.xlsx
ABCDEFGHIJK
1
2date and Timebadge nrCompanyDateBadgeFirstLastCompany
36/03/2022 0:31322008125MPA_Buurtparkeren#N/B
4
56/03/2022 0:53322007289
6
76/03/2022 0:53322007289
8
96/03/2022 0:53322007289
10
116/03/2022 0:55322007289
12
136/03/2022 1:1725863SERIS
14
156/03/2022 1:2425912MPA_Buurtparkeren
16
176/03/2022 1:2925863SERIS
18
196/03/2022 1:3325863SERIS
20
216/03/2022 1:3325863SERIS
22
236/03/2022 1:3325863SERIS
24
256/03/2022 1:3425863SERIS
26
276/03/2022 1:3625863SERIS
28
296/03/2022 1:39322008129MPA_Buurtparkeren
30
316/03/2022 1:4125863SERIS
32
336/03/2022 2:05322004808MPA_Buurtparkeren
34
356/03/2022 2:53322007284
36
376/03/2022 2:53322007284
38
396/03/2022 2:55322007284
40
416/03/2022 2:5825863SERIS
42
436/03/2022 3:0625863SERIS
44
456/03/2022 3:5925863SERIS
46
476/03/2022 4:2525863SERIS
48
496/03/2022 4:2925863SERIS
50
516/03/2022 4:3125863SERIS
52
536/03/2022 4:3125863SERIS
54
556/03/2022 4:3225863SERIS
56
576/03/2022 4:3325863SERIS
58
596/03/2022 4:3325863SERIS
60
616/03/2022 4:3325863SERIS
62
636/03/2022 4:3425863SERIS
64
656/03/2022 4:3525863SERIS
66
676/03/2022 4:3525863SERIS
68
696/03/2022 4:3625863SERIS
70
716/03/2022 4:3625863SERIS
72
736/03/2022 4:3625863SERIS
74
756/03/2022 4:3725863SERIS
76
776/03/2022 4:3725863SERIS
78
796/03/2022 4:3725863SERIS
80
816/03/2022 4:3925863SERIS
82
836/03/2022 4:56322008121MPA_Buurtparkeren
84
856/03/2022 4:58322008121MPA_Buurtparkeren
86
876/03/2022 5:3625863SERIS
88
896/03/2022 6:05322004804MPA_Buurtparkeren
90
916/03/2022 6:07322004804MPA_Buurtparkeren
92
936/03/2022 6:1525863SERIS
94
956/03/2022 6:1525863SERIS
96
976/03/2022 6:1525863SERIS
98
996/03/2022 6:1525863SERIS
100
1017/03/2022 0:15322008125MPA_Buurtparkeren
102
1037/03/2022 1:15322007289
104
1057/03/2022 7:1525863SERIS
106
1077/03/2022 6:1525912MPA_Buurtparkeren
108
1097/03/2022 6:15322007289
110
1117/03/2022 14:1525912MPA_Buurtparkeren
112
1137/03/2022 17:3425912MPA_Buurtparkeren
114
1157/03/2022 12:15322007289
116
1177/03/2022 13:2725863SERIS
118
1197/03/2022 19:15322008125MPA_Buurtparkeren
Blad1
Cell Formulas
RangeFormula
G3G3=LET(a,CHOOSE({1;2},INT(B3:B1000),C3:C1000),UNIQUE(FILTER(a,INDEX(a,,1)<>0)))
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
What do you use as the separator in formulae?
 
Upvote 0
You must log in or register to reply here.

Similar threads

SaraWitch
  • Solved
Return first Monday in April from one date and first Monday in current year April if another is blank
2 3
Replies
28
Views
856
Dave Patton
D
C
  • Solved
Calculate difference b/w numbers
Replies
3
Views
147
Peter_SSs
Peter_SSs
F
  • Question
Need to find and highlight values from high column which are greater than 10 times low value but on same expiry date,same strike price,same option typ
Replies
3
Views
313
etaf
etaf
SaraWitch
  • Solved
Extract individual lines from cell
Replies
6
Views
245
SaraWitch
SaraWitch
Y
  • Question
Extract some (not all) numbers from these strings
2
Replies
12
Views
569
Dan_W
D

Forum statistics

Threads
1,215,148
Messages
6,123,301
Members
449,095
Latest member
Chestertim

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top