Question

Excel中如何通过具体的多个数值批量筛选出符合条件的数据？

满足设备分组名称和设备数量，筛选符合条件的序列号

Answer 1

Sub TEXT()
[d9] = "辅助1"
[E9] = "辅助2"
Dim RNG As Range, RNG1 As Range, N%, RNG2 As Range, rng3 As Range
Set RNG = Range("B1:B17")
Set RNG2 = Range("d2:d4")
For Each rng3 In RNG2 '数量判定
For Each RNG1 In RNG '原始数据循环
If RNG1 = rng3 Then
N = N + 1
If N <= rng3(1, 2) Then
Cells(Rows.Count, "d").End(xlUp)(2, 1) = RNG1(1, 0)
Cells(Rows.Count, "e").End(xlUp)(2, 1) = RNG1
End If
End If
Next
N = 0
Next
End Sub

Answer 2

COUNTIFS第几次出现法把某组出现的位置求出来，然后简单的一个高级筛选。就可以了

Answer 3

写代码可以处理,需要文档

Answer 4

把问题作为内容（邮件主题一定要包含“excel”,本人以此为依据辨别非垃圾邮件，以免误删）,excel样表文件（尽量详细说明现状和目标效果）作为附件发到yqch134@163.com帮你看下