|
回复 zmhzmh1999 的帖子
先把数据表的多余数据删除
执行下面的代码
- Sub 汇总()
- Dim arr1()
- arr = Sheets("数据").UsedRange.Value
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) <> "" Then
- m = m + 1
- ReDim Preserve arr1(1 To 1, 1 To m)
- arr1(1, m) = arr(i, j)
- End If
- Next j
- Next i
- For i = 1 To m - 1
- For j = i + 1 To m
- If arr1(1, i) < arr1(1, j) Then
- t = arr1(1, i)
- arr1(1, i) = arr1(1, j)
- arr1(1, j) = t
- End If
- Next j
- Next i
- Sheets("汇总").Columns("a:a").ClearContents
- Sheets("汇总").Range("a1").Resize(m, 1) = Application.Transpose(arr1)
- End Sub
复制代码
多列提取数据并排序(VBA).rar
(13.68 KB, 下载次数: 10)
|
|