Hillary S | search
Click here to view Hillary S news from 60+ newspapers.
Bookmark or Share- TOCOL function - Microsoft SupportReturns the array in a single column. =TOCOL (array, [ignore], [scan_by_column]) The TOCOL function syntax has the following arguments: array The array or reference to return as a column. ignore Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following: scan_by_column Scan the array by column.
- TOROW function - Microsoft SupportReturns the array in a single row. =TOROW (array, [ignore], [scan_by_column]) The TOROW function syntax has the following arguments: array The array or reference to return as a row. ignore Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following: scan_by_column Scan the array by column.
- Names in formulas - Microsoft SupportThere are several types of names you can create and use. Defined name A name representing a cell, range of cells, formula, or constant value. You can create your own defined name, or Excel can create a defined name for you, such as when you set a print area.
More
