请问大神我这边库存的货号A,从库存调出的货号B,请问怎么快速

=FILTER(A2:A17,COUNTIF(B2:B5,A2:A17)=0)

部分低版本，公式不正常的话用这个，ctrl+shift+enter三键输出，下拉填充直至出现空单元格
【=IFERROR(INDEX(FILTER($A$2:$A$17,COUNTIF($B$2:$B$5,$A$2:$A$17)=0),ROW(A1)),"")】

=UNIQUE(TOCOL(A2:B27,1,1),,1)

是不是哪里没输入对

用这个稳定快，我猜你的数据应该挺多且大，他们的公式带数组溢出需要2019以上的excel，你看下你的office‘版本

Sub 问题()
Dim arr, dic, dic2, i, d, key
Columns("a:c").NumberFormatLocal = "@"
arr = [a1].CurrentRegion
ReDim brr(1 To UBound(arr, 1), 1 To 2)
Set dic = CreateObject("scripting.dictionary")
Set dic2 = CreateObject("scripting.dictionary")
d = 0
For i = 1 To UBound(arr, 1)
If arr(i, 1) <> "" Then
dic(d) = arr(i, 1)
d = d + 1
End If
Next
d = 0
For i = 1 To UBound(arr, 1)
If arr(i, 2) <> "" Then
dic2(d) = arr(i, 2)
d = d + 1
End If
Next
For i = 0 To dic2.Count - 1
For Each key In dic.keys
If dic(key) = dic2(i) Then
dic.Remove key
Exit For
End If
Next
Next
[c1].Resize(dic.Count, 1) = Application.Transpose(dic.items)
End Sub

条件格式=iserror(match(A1,$B$1:$B$100,))然后筛选

Vlookup就行。没有版本顾虑