Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I compare two columns | Excel Worksheet Functions | |||
Compare two columns | Excel Worksheet Functions | |||
Compare Columns | Excel Discussion (Misc queries) | |||
Compare two columns | Excel Discussion (Misc queries) |