ADDRESS
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Analisi dati
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
17 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
CHOOSE
CHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Analisi dati
Apri schedaCOLUMN
COLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Analisi dati
Apri schedaCOLUMNS
COLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Analisi dati
Apri schedaFORMULATEXT
FORMULATEXT(cell)
Returns the formula as a string. Learn more.
Analisi dati
Apri schedaGETPIVOTDATA
GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more
Analisi dati
Apri schedaHLOOKUP
HLOOKUP(search_key, range, index, [is_sorted])
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more
Analisi dati
Apri schedaINDEX
INDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Analisi dati
Apri schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. Learn more
Analisi dati
Apri schedaLOOKUP
LOOKUP(search_key, search_range|search_result_array, [result_range])
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more
Analisi dati
Apri schedaMATCH
MATCH(search_key, range, [search_type])
Returns the relative position of an item in a range that matches a specified value. Learn more
Analisi dati
Apri schedaOFFSET
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more
Analisi dati
Apri schedaROW
ROW([cell_reference])
Returns the row number of a specified cell. Learn more
Analisi dati
Apri schedaROWS
ROWS(range)
Returns the number of rows in a specified array or range. Learn more
Analisi dati
Apri schedaSHEET
SHEET(value)
Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
Analisi dati
Apri schedaVLOOKUP
VLOOKUP(search_key, range, index, [is_sorted])
Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more
Analisi dati
Apri schedaXLOOKUP
XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match. Learn more
Analisi dati
Apri scheda