You can’t just plug in the asterisk character though. When adding wildcards to a function in this way, you must concatenate the delimiter and the reference.

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how ...

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

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

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Learn how to use the secret hidden Excel FILES function in your Microsoft spreadsheets to easily retrieve file names and metadata ...

The PI function is a Math & Trigonometry Function. Learn how to use the PI function in Excel, or how to multiply by PI, using this tutorial.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...