This will contain all my notes.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
notepad/spreadsheet.md

2.2 KiB

Selectors

@[Col_Name] - To get the column name

'SHEET_NAME'!$COL$ROW - To get cell from given sheet name and specified row and col

Functions

AVERAGE(number1, [number2], ...)

number1 - A number or cell reference that refers to numeric values.

number2 - [optional] A number or cell reference that refers to numeric values.

https://exceljet.net/excel-functions/excel-average-function

COUNTIF(range, criteria)

range - The range of cells to count.

criteria - The criteria that controls which cells should be counted.

https://exceljet.net/excel-functions/excel-countif-function

IF(condition, truthy_val, falsy_val)

condition - A value or condition that can evaluate to TRUE or FALSE

truthy_val - The value to return when condition is TRUE

falsy_val - The value too return when condition is FALSE

https://exceljet.net/excel-functions/excel-if-function

IFERROR(value, value_if_error)

value - The value, reference, or formula to check for an error.

value_if_error - The value to return if an error is found.

https://exceljet.net/excel-functions/excel-iferror-function

MATCH (lookup_value, lookup_array, [match_type])

lookup_value - The value to match in lookup_array.

lookup_array - A range of cells or an array reference.

match_type - [optional] 1 = exact or next smallest (default), 0 = exact match, -1 = exact or next largest.

https://exceljet.net/excel-functions/excel-match-function

MIN (number1, [number2], ...)

number1 - Number, reference to numeric value, or range that contains numeric values.

number2 - [optional] Number, reference to numeric value, or range that contains numeric values.

https://exceljet.net/excel-functions/excel-min-function

OFFSET(reference, rows, cols, [height], [width])

references - The starting point, supplied as a cell reference or range

rows - The number of rows to offset below the starting reference.

cols - The number of columns to offset to the right of the starting reference.

height - [optional] The height in rows of the returned reference.

width - [optional] The width in columns of the returned reference.

https://exceljet.net/excel-functions/excel-offset-function