ExcelHow

Category: Excel Examples

VLOOKUP – Retrieve Data from Another Worksheet

Excel Examples

June 30, 2021
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