View Single Post
 
Old 01-22-2011, 06:35 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Just some follow up info since it wasn't concluded on this thread -

If you are using Excel 2007 or later then you can use entire column references in array formulas, SUMPRODUCT() etc... If you are using versions prior to Excel 2007 then you can't.
Reply With Quote