i have to compare 2 Excel work sheets. Basically a fixed target list with the actual distribution list.
The target list contains 130 product-IDs (collums A to Z) and round about 100 recipients (rows 1 to 100) whereas a "1" in the product ID collum indicates which row (customer) must receive the product.
the actual distribution list contains of colum A (row 1-100) = product IDs and in B all receipians seperated by a "/". for each product.
The job is now to compare both worksheets to find errors in the distribution. Basically i need to know if worksheet A matches B. If they do not match i need the product ID of the product where recipeints do not match with worksheet A.
Deadline for this job is [url removed, login to view], GMT +1 at 18h. I will be online around 13h to hold a conference.