Text
★ 60 · ◉ 305 · All versions
=SEARCH()
Finds the position of one text string within another
=SEARCH(find_text, within_text, [start_num])
Text Manipulation
Conditional Formatting & Validation
Math & Trig
★ 55 · ◉ 6 · All versions
=MOD()
Returns the remainder after dividing a number by a divisor
=MOD(number, divisor)
Conditional Formatting & Validation
Date & Time Calculations
Lookup & Reference
★ 30 · ◉ 5 · All versions
=ROW()
Returns the row number of a reference or the row number of the cell where it is called
=ROW([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Information
★ 20 · ◉ 4 · All versions
=ISTEXT()
Checks whether an input value is text or not?
=ISTEXT(value)
Data Cleaning
Error Handling
Lookup & Reference
★ 60 · ◉ 4 · All versions
=OFFSET()
Starts from a cell, moves by a specified number of rows and columns, and returns the new cell or range
=OFFSET(reference, rows, cols, [height], [width])
Lookup & Retrieval
Conditional Formatting & Validation
Lookup & Reference
★ 50 · ◉ 3 · All versions
=COLUMN()
Returns the column number
=COLUMN([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Information
★ 60 · ◉ 3 · All versions
=ISBLANK()
Checks whether a cell is empty or not?
=ISBLANK(value)
Error Handling
Conditional Formatting & Validation
Information
★ 20 · ◉ 3 · Excel 2013
=ISFORMULA()
Checks whether a cell contains a formula or not?
=ISFORMULA(reference)
Error Handling
Conditional Formatting & Validation
Information
★ 50 · ◉ 3 · All versions
=ISNUMBER()
Checks whether a value is numeric or not?
=ISNUMBER(value)
Data Cleaning
Comparation
Statistical
★ 60 · ◉ 3 · All versions
=LARGE()
Finds the k-th largest number in a range
=LARGE(array, k)
Daily Tasks
Ranking & Top N
Logical
★ 50 · ◉ 2 · All versions
=AND()
Checks whether two or more conditions are all TRUE
=AND(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
Lookup & Reference
★ 55 · ◉ 2 · All versions
=INDIRECT()
Converts an address written as text into a real address
=INDIRECT(ref_text, [a1])
Lookup & Retrieval
Conditional Formatting & Validation
Information
★ 30 · ◉ 2 · All versions
=ISEVEN()
Checks whether a number is even or not?
=ISEVEN(number)
Error Handling
Conditional Formatting & Validation
Information
★ 30 · ◉ 2 · All versions
=ISODD()
Checks whether a number is odd or not?
=ISODD(number)
Error Handling
Conditional Formatting & Validation
Text
★ 60 · ◉ 2 · All versions
=LEN()
Determines the number of characters of an input value
=LEN(text)
Daily Tasks
Data Cleaning
Logical
★ 30 · ◉ 2 · All versions
=NOT()
Returns the logical negation (NOT)
=NOT(logical)
Conditional Logic
Conditional Formatting & Validation
Text
★ 30 · ◉ 2 · Excel 365
=REGEXTEST()
Checks whether a text matches a pattern
=REGEXTEST(text, pattern, [case_sensitivity])
Data Cleaning
Text Manipulation
Lookup & Reference
★ 80 · ◉ 2 · Excel 2021
=UNIQUE()
Returns the distinct values of a range without duplicates
=UNIQUE(array, [by_col], [exactly_once])
Daily Tasks
Reporting
Statistical
★ 60 · ◉ 1 · All versions
=COUNTIF()
Conditional count (a single condition)
=COUNTIF(range, criteria)
Daily Tasks
Conditional Aggregation
Statistical
★ 70 · ◉ 1 · Excel 2007
=COUNTIFS()
Count with one condition or multiple conditions
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Daily Tasks
Conditional Aggregation
Text
★ 30 · ◉ 1 · All versions
=EXACT()
Compares two texts, case-sensitively
=EXACT(text1, text2)
Text Manipulation
Comparation
Logical
★ 50 · ◉ 1 · All versions
=OR()
Checks whether at least one of several conditions is true
=OR(logical1, [logical2], ...)
Daily Tasks
Conditional Logic
Date & Time
★ 40 · ◉ 1 · All versions
=TODAY()
Returns the current system date
=TODAY()
Daily Tasks
Conditional Formatting & Validation
Date & Time
★ 55 · ◉ 1 · All versions
=WEEKDAY()
Returns the day of the week number for a date
=WEEKDAY(serial_number, [return_type])
Conditional Formatting & Validation
Date & Time Calculations