Excel – Subtract Data in Columns/Rows Without a Formula (Excel 2003, Excel 2007, Excel 2010)
Using “Paste Special” with ‘Subtract’, will allow you to subtract a set of data from another set of data, without having to create an extra column and a formula. In this example we are going to back out the defective returns from the sales figures for each month.