Function: XMATCH
The XMATCH function is a Lookup & Reference function that returns the relative position of a lookup value from a specified array or range. In this guide, we’re going to show you how to use the XMATCH function and also go over some tips and error handling methods....
Function: XLOOKUP
The XLOOKUP function is a Lookup & Reference function that can find values in a table or a range by row. Similar to the better-known VLOOKUP function, you can use this function to do things like looking up the name or price of a product by its code number. In this...
Function: LET
The LET function can define names within the scope of a formula. This essentially offers better readability and help with calculation performance. In this guide, we are going to show you how to use the LET function and go over some tips and error handling methods....
Function: DEC2HEX
The DEC2HEX is an Engineering function that converts a hexadecimal number into a decimal number. In this guide, we’re going to show you how to use the DEC2HEX function and also go over some tips and error handling methods. Supported versions All Excel versions DEC2HEX...
Function: HEX2DEC
The HEX2DEC is an Engineering function that converts a hexadecimal number to decimal. In this guide, we’re going to show you how to use the HEX2DEC function and also go over some tips and error handling methods. Supported versions All Excel versions HEX2DEC Syntax...
Function: CELL
The CELL is an Information function that returns information about various properties of a cell. You can learn things like file name with full folder path, location of a cell or formatting properties. In this guide, we’re going to show you how to use the CELL function...
Function: YEARFRAC
The YEARFRAC is a Date & Time function that calculates and returns the fraction of the year between two days. The function calculates the fraction by the number of whole days in given day count basis. In this guide, we’re going to show you how to use the YEARFRAC...
How to select a random item from a list in Excel
You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. [button...
STANDARDIZE Function
The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...