Lookup & Reference(Microsoft Excel Functions)
Contents
- 1. Search functions.
- 2. Functions to edit range of cells based on a value.
- 3. Functions to edit range of cells regardless of their values.
- 3.1. DROP Function. Deletes rows and columns from range of cells.
- 3.2. TAKE Function. Get rows and columns from range of cells.
- 3.3. TOCOL Function. Sort range of cells into a single column.
- 3.4. TOROW Function. Sort range of cells into a single row.
- 3.5. EXPAND Function. Expand range of cells.
- 3.6. CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.
- 3.7. VSTACK and HSTACK functions.Merge multiple range of cells.
- 3.8. WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
- 3.9. OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.