第1个回答 2014-01-10
同时按Alt和F11进入宏界面,点菜单的插入,模块,粘贴如下代码:Function dyy(xRng As Range) As StringDim i As IntegerDim tmpStr As StringFor i = 1 To xRng.Rows.CountIf Abs(xRng.Cells(i, 1)) < 1 ThentmpStr = Mid(xRng.Cells(i, 1), InStr(xRng.Cells(i, 1), ".") + 1, 1)If InStr(dyy, tmpStr) = 0 Then dyy = dyy & tmpStrEnd IfNext iEnd Function回到Excel,在E1输入 =dyy(A1:A16),公式向右复制。