ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
輸入關鍵字蘿蔔
2
3
購買時間會員編號會員姓名購買商品金額關鍵字出現次數F2 儲存格的函數
4
2025/2/26 23:481小Ｏ女蘿蔔,青蔥1201
=(LEN(D2)-LEN(SUBSTITUTE(D2, "蘿蔔", "")))/LEN("蘿蔔")
5
2025/4/15 17:112楊Ｏ啤酒600
6
2025/2/24 12:533雕Ｏ鳥食500加總的函數
7
2025/3/25 17:152楊Ｏ啤酒600
=ARRAYFORMULA(SUM((LEN(D:D)-LEN(SUBSTITUTE(D:D, "蘿蔔", "")))/LEN("蘿蔔")))
8
2025/2/15 17:223雕Ｏ鳥食500
9
2025/4/17 0:171小Ｏ女青菜,蘿蔔,豆腐1121
10
2025/2/19 16:421小Ｏ女青菜,竹筍,蘿蔔1231
11
2025/5/19 18:503雕Ｏ零食50
12
2025/4/17 12:063雕Ｏ蘿蔔51
13
2025/2/25 14:483雕Ｏ蘿蔔51
14
15
16
關鍵字總共出現次數5
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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