|
本帖最后由 csmctjg 于 2013-3-20 13:19 编辑
- vba方法:
- Sub aa()
- Dim i&, j&, d As New Dictionary, arr
- arr = Range("A1:A" & Range("A" & Rows.Count).End(3).Row + 1)
- For i = 1 To UBound(arr) - 1
- j = i
- Do While arr(i, 1) = arr(i + 1, 1)
- i = i + 1
- Loop
- If d(arr(i, 1)) < i - j + 1 Then d(arr(i, 1)) = i - j + 1
- Next
- [C1].Resize(d.Count) = Application.Transpose(d.Keys)
- [D1].Resize(d.Count) = Application.Transpose(d.Items)
- End Sub
- 函数方法(数组公式):
- =MAX(FREQUENCY(IF(A$1:A$19=C1,ROW($1:$19)),IF(A$1:A$19=C1,,ROW($1:$19))))
复制代码 |
评分
-
查看全部评分
|