Dear All,
I am using Excel 2010 and the spreadsheet I am working on contains 6,500 rows of data. I am currently using a filter to reduce the output to a certain product and I am using the =subtotal(9,C1:c6500) formula to create a subtotal, however, I would like to know if this formula or...