## Extract common values from two lists

You can use the Excel COMPARE function to extract common values from two lists and get the result into a dynamic array.

Excel Formulas and Examples – This section gives easy-to-understand help for the most used formulas. String manipulation functions play an important role in Excel. Discover how to replace the regular LEN, LEFT, RIGHT, MID, and SUBSTITUTE functions and use stunning user-defined functions! **Learn more about XLOOKUP!**

Click on the below sections to get started!

You can use the Excel COMPARE function to extract common values from two lists and get the result into a dynamic array.

To count cells between two numbers in Excel, you can use the COUNTBETWEEN function or the COUNTIFS function.

This tutorial will show you how to extract the nth word from a text string (a sentence or phrase) in Excel.

This tutorial will show you how to convert a date to a number or convert a serial number to a date using Excel.

To add years to date in Excel, you can use the XDATE function instead of built-in functions like YEAR, MONTH, and DAY.

Learn how to extract a number from a text string in Excel (from the left, right, or any position) using custom formulas and functions.

A logical test in Excel (logical expression) returns only two types of values: TRUE or FALSE, helping to decision-making processes.

Assign a descriptive name to a range of cells using a named range in Excel. Use it to create easy-to-understand formulas.

This tutorial will show you how to calculate the running total (cumulative sum) in Excel using the RTOTAL function.

Today’s tutorial will show you how to find if a cell contains specific text using the ISNUMBER and SEARCH functions.

Learn how to split a text string at specific character in Excel using the LEFT, RIGHT, LEN, and FIND functions.

Learn how to remove text from a cell by position in Excel using the REPLACE, SUBSTITUTE, and TEXTRIGHT functions.

To remove text from a cell based on matching content in Excel (or replace multiple characters), use the SUBSTITUTE or MSUB functions.

To split text and numbers, use a formula based on the FIND function, the MIN function, and the LEN function with the LEFT or RIGHT function.

This tutorial will show various ways and tips on how to remove the first character from a cell in Excel using formulas.

Learn how to separate names in Excel (first, last, or middle) using regular Excel formulas and advanced functions.

In this tutorial, you will learn how to separate Date and Time in different columns in Excel using the DATETIME function.

This tutorial will show you straightforward ways to extract a word or words in Excel without using complex formulas.

Learn how to use the Excel SUBSTRING function to extract text before or after a character and find a substring between two characters.

To find the first or last positive value in a list (row or column), use the XLOOKUP, SIGN, INDEX, or MATCH functions.

Learn how to sum multiple rows or columns based on a lookup value you can use the SUM function with the XLOOKUP function.

Combine the LET and IF functions with XLOOKUP, and XLOOKUP will return blank if the lookup result is blank.

XLOOKUP can’t return all matches by default; however, here is the workaround with the Excel FILTER function.

You can use the XLOOKUP function and a sorted list to look up values between two numbers and return a corresponding result.

Learn how to create a nested XLOOKUP formula if you need two lookup values to find the matching record in Excel.

This guide will explain how to find the 2nd match or the nth occurrence in an array using the XLOOKUP function.

Learn how to lookup the first negative value in a range using the XLOOKUP function or INDEX and MATCH functions.

To lookup and get the first text value in a range, use the XLOOKUP function with a wildcard character match mode.