Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Lookup & Reference (40)

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Returns a reference as text to a single cell in a worksheet.

=AREAS(reference)

Returns the number of areas in a reference.

=CHOOSE(index_num, value1, [value2], ...)

Chooses a value from a list of values.

=CHOOSECOLS(array, col_num1, [col_num2], ...)

Returns the specified columns from an array.

=CHOOSEROWS(array, row_num1, [row_num2], ...)

Returns the specified rows from an array.

=COLUMN([reference])

Returns the column number of a reference.

=COLUMNS(array)

Returns the number of columns in a reference.

=DROP(array, rows, [columns])

Excludes a specified number of rows or columns from the start or end of an array.

=EXPAND(array, rows, [columns], [pad_with])

Expands or pads an array to specified row and column dimensions.

=FILTER(array, include, [if_empty])

Filters a range of data based on criteria you define.

=FORMULATEXT(reference)

Returns the formula at the given reference as text.

=GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)

Returns data stored in a PivotTable report.

=GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])

Helps a user group, aggregate, sort, and filter data based on the fields you specify.

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Looks in the top row of an array and returns the value of the indicated cell.

=HSTACK(array1, [array2], ...)

Appends arrays horizontally and in sequence to return a larger array.

=HYPERLINK(link_location, [friendly_name])

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

=IMAGE(source, [alt_text], [sizing], [height], [width])

Returns an image from a given source.

=INDEX(array, row_num, [column_num])

Uses an index to choose a value from a reference or array.

=INDIRECT(ref_text, [a1])

Returns a reference indicated by a text value.

=LOOKUP(lookup_value, lookup_vector, [result_vector])

Looks up values in a vector or array.

=MATCH(lookup_value, lookup_array, [match_type])

Looks up values in a reference or array.

=OFFSET(reference, rows, cols, [height], [width])

Returns a reference offset from a given reference.

=PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to])

Helps a user group, aggregate, sort, and filter data based on the row and column fields that you specify.

=ROW([reference])

Returns the row number of a reference.

=ROWS(array)

Returns the number of rows in a reference.

=RTD(ProgID, server, topic1, [topic2], ...)

Retrieves real-time data from a program that supports COM automation.

=SORT(array, [sort_index], [sort_order], [by_col])

Sorts the contents of a range or array.

=SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2], ...)

Sorts the contents of a range or array based on the values in a corresponding range or array.

=TAKE(array, rows, [columns])

Returns a specified number of contiguous rows or columns from the start or end of an array.

=TOCOL(array, [ignore], [scan_by_column])

Returns the array in a single column.

=TOROW(array, [ignore], [scan_by_column])

Returns the array in a single row.

=TRANSPOSE(array)

Returns the transpose of an array.

=TRIMRANGE(range, [trim_rows], [trim_cols])

Scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns.

=UNIQUE(array, [by_col], [exactly_once])

Returns a list of unique values in a list or range.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Looks in the first column of an array and moves across the row to return the value of a cell.

=VSTACK(array1, [array2], ...)

Appends arrays vertically and in sequence to return a larger array.

=WRAPCOLS(vector, wrap_count, [pad_with])

Wraps the provided row or column of values by columns after a specified number of elements.

=WRAPROWS(vector, wrap_count, [pad_with])

Wraps the provided row or column of values by rows after a specified number of elements.

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

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.

=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Returns the relative position of an item in an array or range of cells.