Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...

It's easy to search in Excel by typing into the Search Sheet bar at the top of the screen, or by using a keyboard shortcut. You can also search for terms or numbers and easily replace them with ...

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

Learn how to find and replace wildcard characters in Excel as normal text using tilde special characters. It is very easy to do so!

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell. Search finds data in a cell and returns the ...

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

Learn how to use both Excel's XLOOKUP() and VLOOKUP() functions to find results between conditional benchmarks in Microsoft Excel.