第1个回答 2010-01-26
假设数据分布于A1:A11,
B1输入公式=INDEX(A1:A11,MATCH(100,A1:A11,1))
回车本回答被提问者采纳
第2个回答 2010-01-26
要用宏来做的
workname = ActiveSheet.Name
j = 1
For i = 1 To 100 Step 1
If (Worksheets(workname).Rows(j).Columns(1).Value <> "") Then
If (Worksheets(workname).Rows(j).Columns(1).Value > 100) Then
i = 200
Else
j = j + 1
Else
i = 2000
End If
Worksheets(workname).Rows(1).Columns(2).Value =Worksheets(workname).Rows(j-1).Columns(1).Value
Next i