skip to Main Content

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.
 

This post is only available to members.
Back To Top