Thanks for the tips, didn't know about Ctrl+Shift+L. Regarding array formulas, I wouldn't recommend them. Especially as you can use SUMPRODUCT for the same pur

Thanks for the tips, didn't know about Ctrl+Shift+L. Regarding array formulas, I wouldn't recommend them. Especially as you can use SUMPRODUCT for the same purposes as array formulas... http://ww2.cfo.com/accounting-tax/2010/12/spreadsheets-hate-arrays-then-hijack-sumproduct/ http://ww2.cfo.com/accounting-tax/2010/12/spreadsheets-hate-...