ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
ClassDistanceId numbervehiclespeedEvent
3
A/PBG-2000/41 MileMike Yurko164.835
2019 September
max
4
A/PBG-750/41 MileNick Genet98.414
2023 Horsepower Harvest
A/PBG-2000/41 Mile
2019 September
5
A/PBG-750/41/2 MileNick Genet84.483
2023 Horsepower Harvest
A/PBG-750/41 Mile
2023 Horsepower Harvest
6
A/PBG-750/42 KilometersNick Genet102.576
2023 Horsepower Harvest
A/PBG-750/41/2 Mile
2023 Horsepower Harvest
7
A/PF-2000/41 MileMike Yurko163.339
2019 September
A/PBG-750/42 Kilometers
2023 Horsepower Harvest
8
A/PF-3000/41 MileMike Yurko162.455
2019 September
A/PF-2000/41 Mile
2019 September
9
A/PF-3000/41 Mile
2019 September
10
11
12
A/PBG-750/41 MileSteve Siegel1991 Sporster116.099
2025 Spring Fling
A/PBG-2000/41 MileMike Yurko164.835
2019 September
13
A/PBG-750/41/2 MileSteve Siegel1991 Sporster103.496
2025 Spring Fling
A/PBG-750/41 MileNick Genet98.414
2023 Horsepower Harvest
14
A/PBG-750/22 KilometersSteve Siegel1991 Sporster116.671
2025 Spring Fling
A/PBG-750/41/2 MileNick Genet84.483
2023 Horsepower Harvest
15
A/PBG-750/42 KilometersNick Genet102.576
2023 Horsepower Harvest
16
A/PF-2000/41 MileMike Yurko163.339
2019 September
17
A/PF-3000/41 MileMike Yurko162.455
2019 September
18
A/PBG-2000/41 MileMike Yurko164.835
2019 September
19
A/PBG-750/22 KilometersSteve Siegel1991 Sporster116.671
2025 Spring Fling
MOMMASAID v2 with auto-header
20
A/PBG-750/41 MileSteve Siegel1991 Sporster116.099
2025 Spring Fling
ClassDistanceId numbervehiclespeedEvent
21
A/PBG-750/41 MileNick Genet98.414
2023 Horsepower Harvest
A/PBG-2000/41 MileMike Yurko164.835
2019 September
22
A/PBG-750/41/2 MileSteve Siegel1991 Sporster103.496
2025 Spring Fling
A/PBG-750/41 MileNick Genet98.414
2023 Horsepower Harvest
23
A/PBG-750/41/2 MileNick Genet84.483
2023 Horsepower Harvest
A/PBG-750/41/2 MileNick Genet84.483
2023 Horsepower Harvest
24
A/PBG-750/42 KilometersNick Genet102.576
2023 Horsepower Harvest
A/PBG-750/42 KilometersNick Genet102.576
2023 Horsepower Harvest
25
A/PF-2000/41 MileMike Yurko163.339
2019 September
A/PF-2000/41 MileMike Yurko163.339
2019 September
26
A/PF-3000/41 MileMike Yurko162.455
2019 September
A/PF-3000/41 MileMike Yurko162.455
2019 September
27
=QUERY({$B$3:$G$8;$B$12:$G$14}, "select* order by Col1 asc,Col2 asc, Col5 desc",)
=let(data, $B$3:$G$8, colNums, { 1,2,3,4,5,6 },
head, choosecols(offset(data,-1,0,1), colNums),
select, "Col1, Col2, MAX(Col6) WHERE Col1 is not null GROUP BY Col1, Col2 ORDER BY Col1, MAX(Col6) DESC",

rowQuery, query(hstack(data, sequence(rows(data))), "SELECT MIN(Col" & columns(data)+1 & "), " & select, 0),
rowNums, filter(choosecols(rowQuery,1), isnumber(choosecols(rowQuery,1))),
results, choosecols(chooserows(data, rowNums), colNums),
vstack(head,results))
28
29
30
31
32
MOMMASAID v1
33
A/PBG-2000/41 MileMike Yurko164.835
2019 September
34
A/PBG-750/41 MileNick Genet98.414
2023 Horsepower Harvest
35
A/PBG-750/41/2 MileNick Genet84.483
2023 Horsepower Harvest
36
A/PBG-750/42 KilometersNick Genet102.576
2023 Horsepower Harvest
37
A/PF-2000/41 MileMike Yurko163.339
2019 September
38
A/PF-3000/41 MileMike Yurko162.455
2019 September
39
40
=let(data, $B$3:$G$8, colNums, { 1,2,3,4,5,6 },
select, "Col1, Col2, MAX(Col6) WHERE Col1 is not null GROUP BY Col1, Col2 ORDER BY Col1, MAX(Col6) DESC",

rowQuery, query(hstack(data, sequence(rows(data))), "SELECT MIN(Col" & columns(data)+1 & "), " & select, 0),
rowNums, filter(choosecols(rowQuery,1), isnumber(choosecols(rowQuery,1))),
choosecols(chooserows(data, rowNums), colNums))
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