ExcelHow

Category: Excel Examples

Case Sensitive Lookup with SUMPRODUCT and EXACT

Excel Examples

June 29, 2021
Basic Usage of INDEX & MATCH – Case Sensitive Lookup

Excel Examples

June 28, 2021
Basic Rates Calculation by VLOOKUP Based on Weight Band

Excel Examples

June 23, 2021
Basic Grade Calculation by VLOOKUP Function – Approximate Match

Excel Examples

June 21, 2021
Basic Discount Calculation with VLOOKUP Function

Excel Examples

June 19, 2021
Basic Usage of INDEX & MATCH – Exact Match

Excel Examples

June 17, 2021
Basic Usage of INDEX & MATCH – Approximate Match

Excel Examples

June 16, 2021
Approximate Match with Multiple Criteria by INDEX & MATCH

Excel Examples

June 13, 2021
Average per Week by Formula in Excel

Excel Examples

June 8, 2021
How to Statistic Pass 4 Out of 5 Rounds in a Competition by Excel Functions

Excel Examples

June 7, 2021
Average with Multiple Criteria in Excel

Excel Examples

June 5, 2021
Average of Top N Values in Excel

Excel Examples

June 4, 2021
Average the Last N Numeric Values in Excel

Excel Examples

June 3, 2021
How to Average Last N Values in Multiple Columns

Excel Examples

May 30, 2021
How to Average Ignore Zero Number

Excel Examples

May 28, 2021
How to Sum if Equal to Many Items or A Range in Excel

Excel Examples

May 18, 2021
How to Sum if Equal to X or Y in Excel

Excel Examples

May 13, 2021
How to Sum Last N Days in Excel

Excel Examples

May 11, 2021
How to Count Not Empty or Blank Cells with COUNTIFS in Excel

Excel Examples

April 24, 2021
How to Sum One or More Criteria with Multiple Columns in Excel

Excel Examples

April 16, 2021