Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 55 of 60 · 540 articles
Count values with Excel intersect operator
Learn how Excel's INTERSECT function works, including its syntax, arguments, and practical usage.
How to lookup across two tables with VLOOKUP and IF functions
Learn how to lookup across two tables with VLOOKUP and IF functions. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count by month
Learn how to count by month. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate monthly averages
Learn how to calculate monthly averages. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to sum by month
Learn how to sum by month. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find number of days in a month
Learn how to find number of days in a month. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to make case sensitive match
Learn how to make case sensitive match. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to check if a value exists in a list
Learn how to check if a value exists in a list. This practical guide covers the required setup, step-by-step process, and useful Excel options.
How to find smallest value in array using a criteria
Learn how to find the smallest value in an array using a criterion. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.