Dueling Excel 56


Copy Formula Down, Have Range Move Across

DESCRIPTION

See Mr Excel and excelisfun create formulas that can be copied down across the rows and have the range in the function move across the columns. See the OFFSET, ROW, INDEX and MATCH functions.

WORKBOOKS