To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
Function | Description |
---|---|
Returns a reference as text to a single cell in a worksheet |
|
Returns the number of areas in a reference |
|
Chooses a value from a list of values |
|
Returns the column number of a reference |
|
Returns the number of columns in a reference |
|
![]() |
Filters a range of data based on criteria you define |
Returns the formula at the given reference as text |
|
Returns data stored in a PivotTable report |
|
Looks in the top row of an array and returns the value of the indicated cell |
|
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
|
Uses an index to choose a value from a reference or array |
|
Returns a reference indicated by a text value |
|
Looks up values in a vector or array |
|
Looks up values in a reference or array |
|
Returns a reference offset from a given reference |
|
Returns the row number of a reference |
|
Returns the number of rows in a reference |
|
Retrieves real-time data from a program that supports COM automation |
|
![]() |
Sorts the contents of a range or array |
![]() |
Sorts the contents of a range or array based on the values in a corresponding range or array |
Returns the transpose of an array |
|
![]() |
Returns a list of unique values in a list or range |
Looks in the first column of an array and moves across the row to return the value of a cell |
|
![]() |
Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. |
![]() |
Returns the relative position of an item in an array or range of cells. |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.