Sub s()
ca = 7
n = Cells(Rows.Count, 10).End(3).Row
For i = 10 To 16
k = 0
t = ""
Do While Len(t) < ca And n > k
tt = Cells(n - k, i).Text
If InStr(t, tt) = 0 Then t = t & tt
k = k + 1
Loop
Cells(1, i) = t
Next
End Sub
追é®ç»ææäºï¼ä½ä¸å¡«å
é¢è²
ä»æåå¼å§åä¸å¡«å
é¢è²
ä¸ä¸ç¸åæ¶ï¼å¡«å
ä¸åå
é¢è²