INDEX and MATCH Functions
Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales [Read More >>>]
Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS
Count Between Words DESCRIPTION See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words WORKBOOKS
You must be logged in to post a comment.
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.