scott
scott´s postings
- How to Average Only Positive or Negative Numbers of a Range
- How to Sort Data but Keep Blank Cells in Excel
- How to Copy and Paste Only Values and Ignore Formula
- How to Sort Date by Day of Week in Excel
- How to Select All Non-Blank Cells of a Range
- Remove Indents within Cells
- Hide Rows with Blank Cells in Two Ways
- Sort Positive Numbers and Negative Numbers by Absolute Values
- Get Employee Information by VLOOKUP
- VLOOKUP with Two Lookup Tables
- VLOOKUP with Multiple Lookup Values
- VLOOKUP Data by Date
- VLOOKUP – Retrieve Data from Another Workbook
- VLOOKUP – Retrieve Data from Another Worksheet
- Case Sensitive Lookup with SUMPRODUCT and EXACT
- Basic Usage of INDEX & MATCH – Case Sensitive Lookup
- Basic Rates Calculation by VLOOKUP Based on Weight Band
- Basic Grade Calculation by VLOOKUP Function – Approximate Match
- Basic Discount Calculation with VLOOKUP Function
- Basic Usage of INDEX & MATCH – Exact Match
Our authors
- scott (1320)
