|I have two tables containing similar information. What I'd like to is compare the text in the first column and if they match, subtract the data for the following 12 columns.|
So basically table 1 is a list of companies (column A) by their total spend over a period of 12 months (Columns (B-M),
Table 2 is list of companies (column A) who have spent on product X over the last 12 months (Columns B-M). but it has all the companies who haven't spent on product X deleted.
I'd like to compare these two tables to create a third table which has a list of companies minus their spend on product X. If they have spent anything at all
I hope this is clear, please let me know if you need any more information