How to : Comparing Two Ranges

L

lockwood7

I run an auto parts business. I have a list of parts in my excel data
base. When parts are sold throught the web, I need to download the
list and compare it to the list of parts in the database. Any parts
that no longer show on the web must be deleted from the list in excel.
How do I compare the two lists and view the exceptions? I thought I had
figured it out using the EXACT function, but it is not working
properly.

Thanks-
John
 
S

Steve Mackay

Would help if you explained a little more about the format. However,
if the Web list is in Column A (I'm assuming 500 parts) and the
Database is in column B, then in C1 you could use this formula and copy
down to the the end of the list:

=countif(B1,$A$1:$A$500)

any cell with "0" you could delete.
 
Top