The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

How to use InputBox in VBA Now that you know about InputBox, let’s use it in a simple procedure. Specifically, the procedure in Listing A will prompt you to select a range.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.