Display missing Part Number if Column A does not match column B
Hi Erik,
=IF(COUNTIF($B$27:$B$35,A27)=0,A27,"")
And fill down.. change range to suit of course.
Returned G0325V3 using your data.
HTH
Regards,
Howard
"Erik T" wrote in message
...
I want to look in column A and column B for matching part numbers and in
column C have a formula that will display any part number from column A
that
is not in column B. I have 3450 part numbers to go through as new numbers
are
added every week.
Column A Column B
G0015 G0015
G0092 G0092
G0123V1 G0123V1
G0124 G0124
G0125V2 G0125V2
G0325V3 G0327V1
G0327V1 G0329-2
G0329-2 G0331-1
G0331-1 G0332V1
Thank you,
Erik
|