|
用VBA的方法提取所需的数。
本帖最后由 sunjing-zxl 于 2012-1-8 22:20 编辑
- Sub aa()
- Dim arr, arr1
- Dim i As Long, j As Long
- Range(Cells(1, 2), Cells(65536, "IV")).ClearContents
- arr = Range("A1:A" & [A65536].End(xlUp).Row)
- ReDim arr1(1 To 50, 1 To Int(UBound(arr) / 2) + 1)
- For i = 1 To UBound(arr1, 2)
- For j = 1 To UBound(arr1)
- If i + j * (i - 1) > UBound(arr) Then
- Exit For
- Else
- arr1(j, i) = arr(i + j * (i - 1), 1)
- End If
- Next j
- Next i
- Range("B1").Resize(UBound(arr1), UBound(arr1, 2)) = arr1
- End Sub
复制代码附件:
TT-sunjing.rar
(11.9 KB, 下载次数: 17)
|
|