![]() ![]() ![]() Returns a list of unique values in a list or rangeĪppends arrays vertically and in sequence to return a larger array Returns a specified number of contiguous rows or columns from the start or end of an array Sorts the contents of a range or array based on the values in a corresponding range or array Retrieves real-time data from a program that supports COM automation Returns the number of rows in a reference Returns a reference offset from a given reference Returns a reference indicated by a text value Uses an index to choose a value from a reference or array Looks in the top row of an array and returns the value of the indicated cellĪppends arrays horizontally and in sequence to return a larger arrayĬreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet Returns data stored in a PivotTable report Returns the formula at the given reference as text Returns the number of columns in a referenceĮxcludes a specified number of rows or columns from the start or end of an arrayĮxpands or pads an array to specified row and column dimensionsįilters a range of data based on criteria you define ![]() Returns the specified columns from an array Returns the number of areas in a reference Returns a reference as text to a single cell in a worksheet For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions. These functions aren't available in earlier versions. Note: Version markers indicate the version of Excel a function was introduced. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |