Function demo(r1 As Range, r2 As Range, k As Integer)
Dim arr: arr = r1
For i = 1 To 4
If arr(1, i) <> "" Then n = n + 2 ^ arr(1, i)
Next
s = r2.Value
For i = 1 To Len(s)
si = Mid(s, i, 1)
If si = " " Then
If cnt = k Then demo = demo & Mid(s, i - 4, 4) & " "
v = 0: cnt = 0
Else
If (2 ^ si Or v) <> v Then
If (2 ^ si Or n) = n Then cnt = cnt + 1
v = v Or 2 ^ si
End If
End If
Next
End Function
祝順心,南無阿彌陀佛!