æç¨ä¸é¢çVBAç¼ç¨èªå®ä¹å½æ°å®ç°äºåè½ï¼
Option Explicit
Function éæºç»å(ByRef rng As Range, Optional ByVal n As Long = 1) As String
Dim t As Range, db As Object, i&, v$, c$, s$, arr, m&, j&, l&
Set db = CreateObject("Scripting.Dictionary")
For Each t In rng.Cells
v = Trim(t.Text)
db(v) = True
Next t
arr = db.Keys
Set db = Nothing
s = ""
m = UBound(arr)
l = LBound(arr)
For i = 1 To n
j = Int((m - l + 1) * Rnd + l)
c = arr(j)
s = s & c
arr(j) = arr(m)
m = m - 1
If m < l Then Exit For
Next i
éæºç»å = s
End Function
ç¨åºä»£ç åå
¬å¼ç¤ºä¾ï¼