View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patti Backman Patti Backman is offline
external usenet poster
 
Posts: 1
Default Compare two columns for typos

Hello,
I have two columns of data. The first (column A) is a master part list that
has no typos, the second (column B) is a part list of parts stored at my off
site storage facility. These part #'s are typed in manualy and sometimes
contain typos that mean we can not find the parts when we need them. How do
I ask the question: Are there any part numbers in column B that do not match
a part number in column A? This would highlight a typo for us.
Thank you in advance.