Article Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell. Syntax AREAS ( reference ) Reference   is a reference to a...

Article Creates a cell address as text, given specified row and column numbers. Syntax ADDRESS ( row_num , column_num ,abs_num,a1,sheet_text) Row_num   is the row numbe...

Article Excel 2003 comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your need...

Article Returns the number of rows in a reference or array.

Article Retrieves real-time data from a program that supports COM automation . Syntax = RTD ( ProgID ,server,topic1,[topic2],...) ProgID   the name of the ProgID of a ...

Article Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the refer...

Article Returns the row number of a reference. Syntax ROW (reference) Reference   is the cell or range of cells for which you want the row number. If reference is omitt...

Article Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 29 values based on the index number. For example, if value1...

Article Search a row or column in Excel 2003 for specific data, and then return that value in another cell using the functions VLOOKUP, MATCH, and INDEX.

Article Show All Hide All Returns the number of columns in an array (array: Used to build single formulas that produce multiple results or that operate on a group of ar...

Article Returns the column number of the given reference.

Article Creates a shortcut or jump that opens a document stored on a network server, an intranet , or the Internet. When you click the cell that contains the HYPERLINK...

Article Returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula in a range that has the same number of r...

Article Returns data stored in a PivotTable report. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in ...

Article Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or arra...