Posted by Kim Powell on October 24, 2001 1:37 PM
I have two spreadsheets which both contain two columns of data - Product Numbers (Alpha-numberical) and Total Sales ($). I would like to compare these spreadsheets and report what the differences between the two are. ie: Variances in the Product Codes or Total Sales.
I have looked at using LOOKUP commands but as the product code fields are Alphanumerical it looks for the next best match if the code does not exist giving me false results.
Any suggestions on ways which I can achieve the desired result.