|
009:pdsxff交作业
本帖最后由 pdsxff 于 2011-12-28 23:04 编辑
交作业,详情见附件!
Sub a009()
Dim xingm, lb1(), lb2(), lb3()
Dim lb1id, lb2id, lb3id, lb1max, lb2max, lb3max, i As Integer
lb1id = 1
lb2id = 1
lb3id = 1
lb1max = Application.CountIf(Range("B2:B6000"), "<2000")
lb2max = Application.CountIf(Range("B2:B6000"), "<3000") - lb1max
lb3max = Application.CountIf(Range("B2:B6000"), ">=3000")
ReDim lb1(1 To lb1max, 1 To 2)
ReDim lb2(1 To lb2max, 1 To 2)
ReDim lb3(1 To lb3max, 1 To 2)
xingm = Range("A2:B" & Cells(65536, 1).End(xlUp).Row).Value
For i = 1 To UBound(xingm)
Select Case xingm(i, 2)
Case Is < 2000
lb1(lb1id, 1) = xingm(i, 1)
lb1(lb1id, 2) = xingm(i, 2)
lb1id = lb1id + 1
Case Is < 3000
lb2(lb2id, 1) = xingm(i, 1)
lb2(lb2id, 2) = xingm(i, 2)
lb2id = lb2id + 1
'
Case Else
lb3(lb3id, 1) = xingm(i, 1)
lb3(lb3id, 2) = xingm(i, 2)
lb3id = lb3id + 1
End Select
Next
Range("D3").Resize(lb1max, 1) = Application.Index(lb1, 0, 1)
Range("E3").Resize(lb1max, 1) = Application.Index(lb1, 0, 2)
Range("F3").Resize(lb2max, 1) = Application.Index(lb2, 0, 1)
Range("G3").Resize(lb2max, 1) = Application.Index(lb2, 0, 2)
Range("H3").Resize(lb3max, 1) = Application.Index(lb3, 0, 1)
Range("I3").Resize(lb3max, 1) = Application.Index(lb3, 0, 2)
End Sub
【课时一作业】工资分类.zip
(22 Bytes, 下载次数: 16)
|
评分
-
查看全部评分
|