DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See […]
DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]
INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 […]
Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS
Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]
Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]
Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.
Formula to Create Alpha Numeric Series X20, X25, X39… DESCRIPTION See how to create formula to create Alpha Numeric Series X20, X25, X39… using ROWS function. See the ROWS function and an expandable range to […]