Excel Functions & Formulas
How to Average Only Non-Blank Cells in Excel (6 Easy Ways)
Learn how to average only non-blank cells in Excel using AVERAGEIF, AVERAGEIFS, IF, FILTER functions, table totals, and manual methods.
Read article
Excel Functions & Formulas
69 articles
Excel Functions & Formulas
How to Vlookup Multiple Values in One Cell in Excel (5 Examples)
Learn how to VLOOKUP multiple values in one cell using TEXTJOIN, FILTER, UNIQUE, and VBA codes—both with and without duplicates.
Read article
Excel Functions & Formulas
How to Vlookup with Multiple Criteria in Different Excel Sheets
Learn how to VLOOKUP with multiple criteria across different Excel sheets using INDEX-MATCH, XLOOKUP, and FILTER functions.
Read article
Excel Functions & Formulas
How to Vlookup and Return Second Match in Excel (2 Easy Ways)
Learn how to VLOOKUP the second match value in Excel with or without a helper column using advanced formulas like INDEX, SMALL, and FILTER.
Read article
Excel Functions & Formulas
How to Vlookup to Return All Matches in Excel (4 Suitable Ways)
Learn how to use VLOOKUP in Excel to return all matches, with methods like FILTER, Advanced Filter, and Power Query tools.
Read article
Excel Functions & Formulas
How to Combine VLOOKUP with COUNTIF in Excel (2 Examples)
Learn how to combine VLOOKUP with COUNTIF in Excel to count occurrences accurately using absolute references for better results.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Find a Value That Falls Between a Range
Learn how to use VLOOKUP and alternative Excel functions to find values that fall between a range for accurate data analysis.
Read article
Excel Functions & Formulas
How to Use AVERAGEIF Function with Multiple Criteria in Excel
Learn how to use AVERAGEIF with multiple criteria in Excel using AVERAGEIFS, array formulas, IF with AND, and SUMIFS with COUNTIFS.
Read article
Excel Functions & Formulas
How to Use IF Function with OR Statement in Excel
Learn how to use the IF function with OR in Excel to check regions, flag pending or delayed orders, and identify low sales or target areas.
Read article
Excel Functions & Formulas
How to Use IF Function with Dates in Excel (4 Examples)
Learn how to use the IF function with dates in Excel to check overdue tasks, identify due today, and test if a date falls within a range.
Read article
Excel Functions & Formulas
IF Statement Between Two Numbers in Excel Formula
Learn how to use the IF formula in Excel to check if a value falls between two numbers, return numeric results, or assign categories.
Read article
Excel Functions & Formulas
How to Use VLOOKUP with Date Range in Excel (3 Examples)
Learn how to use VLOOKUP with date ranges in Excel, plus INDEX-MATCH and LOOKUP methods to return values when dates fall between ranges.
Read article