[ 本帖最后由 哭泣的数字 于 2010-1-22 16:39 编辑 ]作者: wddn 时间: 2010-1-22 13:43
是这样吗?作者: davidhawk 时间: 2010-1-22 13:53
自定义函数:
语法: =xing(区域,几星)
代码:
Function xing(target As Range, jixing As Integer) As Integer
Dim i, lian, s As Integer
Dim li As Boolean
li = False
For Each a In target
If a.Value = "¡ï" And Not (li) Then
li = True
lian = lian + 1
ElseIf a.Value = "¡ï" Then
lian = lian + 1
End If
If a.Value <> "¡ï" And li Then
li = False
If lian = jixing Then s = s + 1
lian = 0
End If
Next
xing = s
End Function作者: wangg913 时间: 2010-1-22 14:00
v2=SUMPRODUCT(N(COUNTIF(OFFSET(OFFSET($A2,,,,COLUMN(B1)),,ROW(INDIRECT("1:"&20-COLUMN(A1)))-1),"★")=COLUMN(B1)))
上市不对,以为是同行连星。