FILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
47 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
QUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
Apri schedaCOUNTIF
COUNTIF(range, criterion)
Returns a conditional count across a range. Learn more
Analisi dati Marketing
Apri schedaCOUNTIFS
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the count of a range depending on multiple criteria. Learn more
Analisi dati Marketing
Apri schedaUNIQUE
UNIQUE(range, by_column, exactly_once)
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
Marketing Analisi dati
Apri schedaARABIC
ARABIC(roman_numeral)
Computes the value of a Roman numeral. Learn more
Marketing
Apri schedaASC
ASC(text)
Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.
Marketing
Apri schedaCHAR
CHAR(table_number)
Convert a number into a character according to the current Unicode table. Learn more
Marketing
Apri schedaCLEAN
CLEAN(text)
Returns the text with the non-printable ASCII characters removed. Learn more
Marketing
Apri schedaCODE
CODE(string)
Returns the numeric Unicode map value of the first character in the string provided. Learn more
Marketing
Apri schedaCONCATENATE
CONCATENATE(string1, [string2, ...])
Appends strings to one another. Learn more
Marketing
Apri schedaDOLLAR
DOLLAR(number, [number_of_places])
Formats a number into the locale-specific currency format. Learn more
Marketing
Apri schedaEXACT
EXACT(string1, string2)
Tests whether two strings are identical. Learn more
Marketing
Apri schedaFIND
FIND(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
Apri schedaFINDB
FINDB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Marketing
Apri schedaFIXED
FIXED(number, [number_of_places], [suppress_separator])
Formats a number with a fixed number of decimal places. Learn more
Marketing
Apri schedaJOIN
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
Marketing
Apri schedaLEFT
LEFT(string, [number_of_characters])
Returns a substring from the beginning of a specified string. Learn more
Marketing
Apri schedaLEFTB
LEFTB(string, num_of_bytes)
Returns the left portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri schedaLEN
LEN(text)
Returns the length of a string. Learn more
Marketing
Apri schedaLENB
LENB(string)
Returns the length of a string in bytes." Learn more.
Marketing
Apri schedaLOWER
LOWER(text)
Converts a specified string to lowercase. Learn more
Marketing
Apri schedaMID
MID(string, starting_at, extract_length)
Returns a segment of a string. Learn more
Marketing
Apri schedaMIDB
MIDB(string)
Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more.
Marketing
Apri schedaPROPER
PROPER(text_to_capitalize)
Capitalizes each word in a specified string. Learn more
Marketing
Apri schedaREGEXEXTRACT
REGEXEXTRACT(text, regular_expression)
Extracts matching substrings according to a regular expression. Learn more
Marketing
Apri schedaREGEXMATCH
REGEXMATCH(text, regular_expression)
Whether a piece of text matches a regular expression. Learn more
Marketing
Apri schedaREGEXREPLACE
REGEXREPLACE(text, regular_expression, replacement)
Replaces part of a text string with a different text string using regular expressions. Learn more
Marketing
Apri schedaREPLACE
REPLACE(text, position, length, new_text)
Replaces part of a text string with a different text string. Learn more
Marketing
Apri schedaREPLACEB
REPLACEB(text, position, num_bytes, new_text)
Replaces part of a text string, based on a number of bytes, with a different text string. Learn more.
Marketing
Apri schedaREPT
REPT(text_to_repeat, number_of_repetitions)
Returns specified text repeated a number of times. Learn more
Marketing
Apri schedaRIGHT
RIGHT(string, [number_of_characters])
Returns a substring from the end of a specified string. Learn more
Marketing
Apri schedaRIGHTB
RIGHTB(string, num_of_bytes)
Returns the right portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri schedaROMAN
ROMAN(number, [rule_relaxation])
Formats a number in Roman numerals. Learn more
Marketing
Apri schedaSEARCH
SEARCH(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
Apri schedaSEARCHB
SEARCHB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Marketing
Apri schedaSPLIT
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more
Marketing
Apri schedaSUBSTITUTE
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Replaces existing text with new text in a string. Learn more
Marketing
Apri schedaT
T(value)
Returns string arguments as text. Learn more
Marketing
Apri schedaTEXT
TEXT(number, format)
Converts a number into text according to a specified format. Learn more
Marketing
Apri schedaTEXTJOIN
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more.
Marketing
Apri schedaTRIM
TRIM(text)
Removes leading and trailing spaces in a specified string. Learn more
Marketing
Apri schedaUNICHAR
UNICHAR(number)
Returns the Unicode character for a number. Learn more.
Marketing
Apri schedaUNICODE
UNICODE(text)
Returns the decimal Unicode value of the first character of the text. Learn more.
Marketing
Apri schedaUPPER
UPPER(text)
Converts a specified string to uppercase. Learn more
Marketing
Apri schedaVALUE
VALUE(text)
Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more
Marketing
Apri schedaIMPORTXML
IMPORTXML(url, xpath_query)
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more
Automazione Marketing
Apri scheda