February 13, 2016
Dueling Excel 63
Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a cell reference in a two way table and create a dynamic […]
DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS
Conditional Formatting VBA or OFFSET? DESCRIPTION See Mr Excel use VBA code for Conditional formatting and see excelisfun use the OFFSET, MOD and ROWS functions to do Conditional Formatting. WORKBOOKS
You must be logged in to post a comment.