Excel Formulas - Find Category
Master the art of data analysis! Learn how to find Excel formulas for any task, use the built-in search functions, and master syntax to solve complex calculations with ease.
How to Use VLOOKUP for Exact Matches in Excel
Learn how to use the Excel VLOOKUP formula to find an exact match using the FALSE or 0 argument. Master precise data lookups in seconds!
How to Use XLOOKUP with Multiple Criteria in Excel
Master Excel's XLOOKUP function to search data using multiple criteria. Learn the exact formula and boolean logic with our easy, step-by-step guide.
Finding Duplicate Records in Excel Using the COUNTIF Formula
Learn how to use the Excel COUNTIF formula to quickly find, highlight, and manage duplicate records in your spreadsheets with this easy, step-by-step guide.
How to Find Row Numbers in Excel Using INDEX and MATCH
Learn how to use the INDEX and MATCH formula in Excel to quickly find and return the exact row number of any lookup value.
How to Find the Nth Occurrence in Excel Using INDEX and SMALL
Learn how to use the Excel INDEX and SMALL formula to find the Nth occurrence of a matching value in your data with this step-by-step guide.
How to Find Text Strings in Excel Using the SEARCH Function
Learn how to use the Excel SEARCH formula to find specific text strings within cells using this step-by-step guide with practical, case-insensitive examples.
How to Extract Unique Values in Excel Using the UNIQUE Function
Learn how to use the Excel UNIQUE formula to easily extract and list unique values from any dataset or range in this quick guide.
How to Extract Filtered Rows in Excel Using the FILTER Function
Learn how to combine the Excel FILTER and SUBTOTAL functions to easily extract and analyze only visible, filtered rows in your spreadsheet.
How to Find the First Non-Blank Cell in Excel Using INDEX and MATCH
Learn how to find the first non-blank cell in Excel using a powerful INDEX and MATCH formula. Master this step-by-step technique with clear examples.
How to Count Words in Excel Using LEN and SUBSTITUTE
Learn how to easily count words in Excel using a simple formula combining the LEN and SUBSTITUTE functions.
Excel AVERAGEIF Formula: Calculating Averages Based on Criteria
Learn how to use the Excel AVERAGEIF formula to calculate the average value of a range based on specific criteria with this quick, step-by-step guide.
How to Extract Top N Values in Excel Using the LARGE Function
Learn how to use the Excel LARGE function to quickly find and extract the top N values from your dataset. Step-by-step formula examples included!
Excel Formulas for Finding Partial Matches with Wildcards
Learn how to find partial text matches in Excel using wildcards (* and ?) with powerful formulas like VLOOKUP, XLOOKUP, and SEARCH.
Excel Running Total Formula Using SUM and Absolute References
Learn how to calculate a running total in Excel using the SUM function and absolute references with this quick, step-by-step formula guide.
How to Extract Leftmost Characters in Excel with the LEFT Formula
Learn how to use the Excel LEFT formula to quickly extract the leftmost character or first set of characters from any text cell.
Excel Formulas to Find Duplicates in Two Columns
Learn how to quickly find and highlight duplicates in two Excel columns using easy formulas like COUNTIF and MATCH.
Case-Sensitive VLOOKUP in Excel: Formulas for Exact Matches
Learn how to perform a case-sensitive VLOOKUP in Excel using a powerful INDEX, MATCH, and EXACT formula to find precise uppercase and lowercase matches.
Excel MAXIFS Formula: Find the Highest Value Under Multiple Criteria
Learn how to use the Excel MAXIFS function to quickly find the highest value based on multiple criteria with simple, step-by-step examples.
Excel Formula to Find the First Non-Blank Cell in a Range
Learn how to quickly find and return the first non-blank cell in an Excel range using powerful formulas like XLOOKUP, INDEX, and MATCH.
Excel Formulas to Find the Last Row with Data in a Column
Learn how to find the last row with data in an Excel column using easy, dynamic formulas like LOOKUP, XLOOKUP, and MATCH.
Excel Formulas to Extract Unique Values from Dynamic Ranges
Learn how to extract unique values from a dynamic Excel range using formulas that automatically update as your dataset grows.
How to Find the Nth Occurrence of a Value in an Excel Column
Learn how to find the Nth occurrence of a value in an Excel column using step-by-step formulas like INDEX, MATCH, FILTER, and XLOOKUP.
Excel Formulas to Extract Email Addresses from Unstructured Text
Extract email addresses from unstructured text in Excel. Learn the exact formulas to quickly find and pull emails from any messy data cell.
Excel Formulas to Identify Overlapping Date Ranges in Schedules
Learn the exact Excel formula to quickly find and identify overlapping date ranges to prevent scheduling conflicts in your spreadsheet.
Excel Formula to Find the Cell Address of the Minimum Value in a Row
Learn how to easily find the exact cell address of the minimum value in an Excel row using a simple ADDRESS, MATCH, and MIN formula.
Excel Formulas to Calculate Average Excluding Zeros and Errors
Learn how to easily average a range in Excel while excluding both zeros and error values using powerful formulas like AGGREGATE and FILTER.
Excel Formulas to Calculate Fiscal Quarter from Calendar Date
Learn how to easily calculate the fiscal quarter from any calendar date in Excel using simple, customizable formulas for any fiscal year start month.
Excel Formula to Find the Nearest Match in an Unsorted List
Easily find the closest value or nearest match in an unsorted Excel list using XLOOKUP or INDEX/MATCH. Step-by-step formulas and examples included!
Excel Formula to Find the Most Frequent Text Value in a Column
Learn how to find the most frequent text value (mode) in an Excel column using a simple INDEX, MATCH, and MODE formula.
Excel Formulas to Find Missing Numbers in a Sequential List
Learn how to quickly find missing numbers in a sequential Excel list using simple formulas to instantly identify and extract gaps in your data.