ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
Made for ๐Ÿ’กCoolTables.Onine Collection of Formulas
CUTBLANKROWS filter Out All Blank Rows
CUTBLANKROWS_LAST filter Out Last Blank Rows
SUBMATRIX
LAST_NonBlank
2
=CUTBLANKROWS(B4:H)
=CUTBLANKROWS_LAST(B4:H)
=LAST_NONBLANK({"";1;1;1;"";1;1;1;"";"";""})
3
4
DateColorEmailSuccessProductPriceQuantity8
5
9/30/2022sfqosjupsncnht@test.testFALSE๐Ÿ’125448DateColorEmailSuccessProductPriceQuantityDateColorEmailSuccessProductPriceQuantity
data: range or array
6
9/30/2022pkembh@test.testFALSE๐Ÿ‰4.995869/30/2022
sfqosjupsncnht@test.test
FALSE๐Ÿ’1254489/30/2022sfqosjupsncnht@test.testFALSE๐Ÿ’125448ProductPriceQuantityDefinition
7
9/30/2022ybkvhatv@test.testTRUE
2.99209/30/2022
pkembh@test.test
FALSE๐Ÿ‰4.995869/30/2022pkembh@test.testFALSE๐Ÿ‰4.99586๐Ÿ’125448ProductPriceQuantity20
8
9/30/2022oibwv@test.testTRUE๐Ÿ2.9932899/30/2022
ybkvhatv@test.test
TRUE
2.99209/30/2022ybkvhatv@test.testTRUE
2.9920๐Ÿ‰4.99586๐Ÿ’125448
9
9/30/2022mbletsn@test.testTRUE๐ŸŒฝ8.9917589/30/2022
oibwv@test.test
TRUE๐Ÿ2.9932899/30/2022oibwv@test.testTRUE๐Ÿ2.993289๐Ÿ2.9920๐Ÿ‰4.99586
10
9/30/2022
mbletsn@test.test
TRUE๐ŸŒฝ8.9917589/30/2022mbletsn@test.testTRUE๐ŸŒฝ8.991758๐Ÿ2.993289๐Ÿ2.9920
11
9/30/2022rgpdcasomfipp@test.testTRUE๐Ÿ4.9922069/30/2022
rgpdcasomfipp@test.test
TRUE๐Ÿ4.992206๐ŸŒฝ8.991758๐Ÿ2.993289
12
9/30/2022edlpvvnnjyn@test.testFALSE๐Ÿ‰8.9926499/30/2022
edlpvvnnjyn@test.test
FALSE๐Ÿ‰8.9926499/30/2022rgpdcasomfipp@test.testTRUE๐Ÿ4.992206๐ŸŒฝ8.991758
13
9/30/2022jatuyrxjb@test.testFALSE๐Ÿ1.998219/30/2022
jatuyrxjb@test.test
FALSE๐Ÿ1.998219/30/2022edlpvvnnjyn@test.testFALSE๐Ÿ‰8.992649๐Ÿ4.992206
14
10/1/2022naharqb@test.testFALSE๐Ÿฅ•12.49276210/1/2022
naharqb@test.test
FALSE๐Ÿฅ•12.4927629/30/2022jatuyrxjb@test.testFALSE๐Ÿ1.99821๐Ÿ‰8.992649๐Ÿ4.992206
15
10/1/2022
hxiylvksucpm@test.test
TRUE๐Ÿ‰8.9947310/1/2022naharqb@test.testFALSE๐Ÿฅ•12.492762๐Ÿ1.99821
16
10/1/2022
jatuyrxjb@test.test
FALSE๐Ÿ4.991012๐Ÿฅ•12.492762
17
10/1/2022
jatuyrxjb@test.test
FALSE๐Ÿฅ•4.99911
18
10/1/2022hxiylvksucpm@test.testTRUE๐Ÿ‰8.9947310/1/2022
ybkvhatv@test.test
FALSE๐Ÿ’12510601
19
10/1/2022jatuyrxjb@test.testFALSE๐Ÿ4.99101210/1/2022
hcrwqnpiarvxeg@test.test
FALSE๐Ÿ‰4.99147710/1/2022hxiylvksucpm@test.testTRUE๐Ÿ‰8.99473rowcolumnnum_rowsnum_columns2
20
10/1/2022jatuyrxjb@test.testFALSE๐Ÿฅ•4.9991110/1/2022
ybkvhatv@test.test
TRUE๐Ÿ’275132910/1/2022jatuyrxjb@test.testFALSE๐Ÿ4.99101211833
21
10/1/2022ybkvhatv@test.testFALSE๐Ÿ’125106010/1/2022jatuyrxjb@test.testFALSE๐Ÿฅ•4.99911
22
10/1/2022hcrwqnpiarvxeg@test.testFALSE๐Ÿ‰4.99147710/1/2022ybkvhatv@test.testFALSE๐Ÿ’1251060
23
10/1/2022ybkvhatv@test.testTRUE๐Ÿ’275132910/1/2022hcrwqnpiarvxeg@test.testFALSE๐Ÿ‰4.991477
24
10/1/2022ybkvhatv@test.testTRUE๐Ÿ’2751329
25
26
27
Definition
Definition #1
28
DateColorEmailSuccessProductPriceQuantityDateColorEmailSuccessProductPriceQuantity
29
9/30/2022
sfqosjupsncnht@test.test
FALSE๐Ÿ’1254489/30/2022sfqosjupsncnht@test.testFALSE๐Ÿ’125448
30
9/30/2022
pkembh@test.test
FALSE๐Ÿ‰4.995869/30/2022pkembh@test.testFALSE๐Ÿ‰4.99586
31
9/30/2022
ybkvhatv@test.test
TRUE
2.99209/30/2022ybkvhatv@test.testTRUE
2.9920
32
9/30/2022
oibwv@test.test
TRUE๐Ÿ2.9932899/30/2022oibwv@test.testTRUE๐Ÿ2.993289
33
9/30/2022
mbletsn@test.test
TRUE๐ŸŒฝ8.9917589/30/2022mbletsn@test.testTRUE๐ŸŒฝ8.991758
34
9/30/2022
rgpdcasomfipp@test.test
TRUE๐Ÿ4.992206
35
9/30/2022
edlpvvnnjyn@test.test
FALSE๐Ÿ‰8.9926499/30/2022rgpdcasomfipp@test.testTRUE๐Ÿ4.992206
36
9/30/2022
jatuyrxjb@test.test
FALSE๐Ÿ1.998219/30/2022edlpvvnnjyn@test.testFALSE๐Ÿ‰8.992649
37
10/1/2022
naharqb@test.test
FALSE๐Ÿฅ•12.4927629/30/2022jatuyrxjb@test.testFALSE๐Ÿ1.99821
38
10/1/2022
hxiylvksucpm@test.test
TRUE๐Ÿ‰8.9947310/1/2022naharqb@test.testFALSE๐Ÿฅ•12.492762
39
10/1/2022
jatuyrxjb@test.test
FALSE๐Ÿ4.991012
40
10/1/2022
jatuyrxjb@test.test
FALSE๐Ÿฅ•4.99911
41
10/1/2022
ybkvhatv@test.test
FALSE๐Ÿ’1251060
42
10/1/2022
hcrwqnpiarvxeg@test.test
FALSE๐Ÿ‰4.99147710/1/2022hxiylvksucpm@test.testTRUE๐Ÿ‰8.99473
43
10/1/2022
ybkvhatv@test.test
TRUE๐Ÿ’275132910/1/2022jatuyrxjb@test.testFALSE๐Ÿ4.991012
44
10/1/2022jatuyrxjb@test.testFALSE๐Ÿฅ•4.99911
45
10/1/2022ybkvhatv@test.testFALSE๐Ÿ’1251060
46
10/1/2022hcrwqnpiarvxeg@test.testFALSE๐Ÿ‰4.991477
47
10/1/2022ybkvhatv@test.testTRUE๐Ÿ’2751329
48
49
50
Definitoin #3
51
DateColorEmailSuccessProductPriceQuantity
52
9/30/2022sfqosjupsncnht@test.testFALSE๐Ÿ’125448
53
9/30/2022pkembh@test.testFALSE๐Ÿ‰4.99586
54
9/30/2022ybkvhatv@test.testTRUE
2.9920
55
9/30/2022oibwv@test.testTRUE๐Ÿ2.993289
56
9/30/2022mbletsn@test.testTRUE๐ŸŒฝ8.991758
57
58
9/30/2022rgpdcasomfipp@test.testTRUE๐Ÿ4.992206
59
9/30/2022edlpvvnnjyn@test.testFALSE๐Ÿ‰8.992649
60
9/30/2022jatuyrxjb@test.testFALSE๐Ÿ1.99821
61
10/1/2022naharqb@test.testFALSE๐Ÿฅ•12.492762
62
63
64
65
10/1/2022hxiylvksucpm@test.testTRUE๐Ÿ‰8.99473
66
10/1/2022jatuyrxjb@test.testFALSE๐Ÿ4.991012
67
10/1/2022jatuyrxjb@test.testFALSE๐Ÿฅ•4.99911
68
10/1/2022ybkvhatv@test.testFALSE๐Ÿ’1251060
69
10/1/2022hcrwqnpiarvxeg@test.testFALSE๐Ÿ‰4.991477
70
10/1/2022ybkvhatv@test.testTRUE๐Ÿ’2751329
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