Functions

Excel ROWS function

15 Views
The ‘ROWS’ function in Excel will return the number of rows between a specified cell range.  For example, there are …
Functions

Excel ROW function

19 Views
The ‘ROW’ function in Excel will return the row number of a specified cell. Note: if you wish to know …
Functions

Excel MIN function

17 Views
The MIN function calculates the smallest value within a specified range of cells.  Only numerical values are accepted, given that …
Functions

Excel MAX function

17 Views
The MAX function calculates the largest value within a specified cell range.  Only numerical values are taken into account.  An …
Functions

Excel MEDIAN function

28 Views
The MEDIAN function calculates the median number within a specified range. What is the Median? Where there are an odd …
Functions

Excel AVERAGE function

26 Views
The AVERAGE function calculates the average (i.e. sum total divided by number of numbers) value within a specified cell range.  …
Functions

Excel OFFSET function

65 Views
The ‘OFFSET’ function in Excel will return a cell reference that is a given number of rows and columns away …