Function

The Excel INRANGE function checks if a specific value or a range exists within another range and returns a boolean value, TRUE or FALSE.

Use the Excel COMPARE function to compare two lists or ranges and extract values based on different aspects.

The COUNTX function supports the “Count cells that contain”-type searches and helps you to write short, easy-to-understand formulas.

Use the Excel COUNTTEXT function to count cells that contain one or more text values instead of using the built-in COUNTIF function.

The Excel BETWEEN function finds values within a given range and provides useful optional arguments to count, sum, or average values.

The Excel COLUMN function returns the column number, and the result is a cell reference. Learn more about the function.

The Excel CHOOSE function allows you to select a value from a larger set of options by adding an index of the value you want to retrieve.

The Excel ADDRESS function generates a cell address. The result is the row and column number in text format.

The GETLASTWORD user-defined function in Excel extracts the last word from a cell that contains a text string.

The SUMVISIBLE function is compatible with all Microsoft Excel versions and replaces the SUBTOTAL function.

User-defined functions in Excel, also known as UDFs, are powerful custom functions that provide solutions for advanced tasks.

The XLFN prefix in Excel formulas indicates that the current Microsoft Excel version does not support the given function. If you open a workbook that you created an earlier Excel version, some formulas may show an _xlfn prefix at the starting position of the function. The prefix is an alert, and Excel will indicate that … Read more