1300+ Excel formula examples
This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.
A formula example may show up in multiple categories. No numbers on duplicate formula examples.
#, hashtag
25. #NAME! error
2D, twodimensional, twoway
3D, multiple worksheets, multiple sheets
365
117. Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
Address
Alternative
233. Alternative formula
234. VLOOKUP alternatives
And logic
Autofilter
250. Enable Autofilter
Average
293. AVERAGE ignore NA()
297. How to AVERAGE time
Blank, space
389. Remove blank cells
Calendar
396. Pivot Table calendar
400. Worksheet Calendar
Case
Character
476. LEFT until character
500. Match cell that begins with string and ends with another string  a single character in between
Column
533. Columns
535. Unique columns
574. Sum by column value
590. How to add a column
593. Reference a column
____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
615. Helper column
649. Sort two columns
661. Add columns
664. Merge two columns
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
766. Merge matching rows
772. Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
Conditional formatting, cf, highlight
820. Highlight weekends
835. CF formula examples
Count
885. Count rows with data
919. OR function COUNTIF
932. Count value per row
Countif
_____OR function COUNTIF
Countifs
Criteria, multiple conditions, conditions
1020. How to add criteria
Date
1068. How to split date value
1077. MINIFS function date
1090. WEEKDAYS between dates
1093. Days between two dates
1102. Is date an Excel date?
1105. Year and month to date?
1107. Date function example
1109. Date function format
1112. Date function add days
1114. Date function add months
1115. Date formats
1124. VLOOKUP between dates
1126. Create a date range
1138. Most overlapped date
1139. Least overlapped date
1153. Random date values
_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
1199. Lookup the nearest date
Day
1216. WEEKDAY Function Video
1217. WEEKDAY Function example
1221. DAY Function example
1222. DAY Function not working
1229. Worksheet Day
Decimal
Delete, remove
1248. Delete secondary yaxis
1251. Remove totals
1254. Delete a value
1255. Delete a cell
_____Remove blank cells
Digit
1270. Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
Dynamic
1275. Dynamic scoreboard
1279. Create a dynamic range
1282. Dynamic team generator
1284. Dynamic formatting
Empty
Equal, condition, criterion
1322. IF function  equals
Error, problem
1342. IMTAN function error
1343. BIN2HEX Function error
1346. DROP Function errors
1347. HSTACK Function errors
1348. VSTACK Function errors
1354. BIN2OCT Function error
1355. BIN2DEC Function error
1356. DEC2OCT Function error
1357. DEC2HEX Function error
1358. DEC2BIN Function error
1359. CONVERT Function error
1362. Excel error functions
1364. ISERROR function example
1365. Error in data
_____#NAME! error
_____What is #N/A error
1370. SUMPRODUCT if not error
1374. Can it handle errors?
1378. IFERROR function example
1383. INDEX function error
Extend, expand
1386. EXPAND Function example
Extract, list, filter, get
1391. Get Excel *.xlsx file
_____Enable Autofilter
1392. Get Excel * .xlsx file
1394. Add a drop down list
1397. Get every other row
1414. FILTER Function example
1425. Extract unique values
1428. Extract unique rows
1435. Get the latest revision
1440. Get most frequent value
1445. Extract the last word
1446. Extract the last letter
1447. Extract the last number
1460. Get Excel *.xlsx file
1462. Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
1469. Get *.xlsm file
1470. Get Excel *.xlsm file
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
1480. Insert a drop down list
1482. Build a DropDown List
1485. Nihilist cipher
1490. Random list
1491. List consecutive numbers
_____Get *.xlsx file
1510. Filter duplicate records
1514. Get *.xls file
1521. Create a random playlist
1529. Extract unique distinct values if the value contains the given string  earlier Excel versions
1535. Extract unique distinct values sorted based on sum of adjacent values  earlier Excel versions
1548. Apply filter
1552. Extract duplicates
Finance, stock, expense
First, last
1577. Search last to first
1583. INDEX MATCH – Last value
Group, category
1590. Sum by group
1591. Sum by category
_____Sum by group
1592. Custom groups
Hour
Hyperlink, link
If
1627. If cell has value
1632. IF with OR function
1634. If cell contains text
1641. OR function with IF
1648. VLOOKUP yes if true
1650. Bifid
1651. Trifid
1654. IF function example
_____IF function  equals
1663. IF function  ends with
1664. IF function  contains
1666. IF function  AND OR
1669. IF function  add value?
Ifs
1687. MINIFS function example
_____MINIFS function date
1691. IFS function example
1694. MAXIFS function example
1701. SUMIFS function or
Ignore, avoid, prevent, exclude, hide
1710. MIN function ignore text
_____AVERAGE ignore NA()
1720. How to hide zeros
1721. How to hide text values
Image, picture
1728. IMAGE Function example
1730. Heat map using pictures
Index
1734. INDEX Function Example
_____INDEX function error
1741. Two index table
Index match, index and match
1746. VLOOKUP vs INDEX MATCH
Intersection
Lambda
1750. LAMBDA function example
1751. Build LAMBDA function
1752. Name the LAMBDA function
Large, larger, highest, greater
1762. LARGE function  example
Letter
Lookup, find, identify
1792. FIND Function example
1804. Video  HLOOKUP function
1808. VLOOKUP function formula
_____VLOOKUP alternatives
1819. VLOOKUP another sheet
1820. VLOOKUP keep formatting
_____VLOOKUP returns #N/A
_____VLOOKUP yes if true
1822. VLOOKUP part of text
1823. VLOOKUP sum
1824. VLOOKUP true false
1825. VLOOKUP unique
1828. Find the time difference
1836. Nested LOOKUP functions
_____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
1861. Find lower prices
1862. Find higher prices
1863. Fuzzy lookups
1864. Fuzzy VLOOKUP
_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
1882. Find closest value
1883. Find the closest value
1884. Find closest values
Match
1888. XMATCH Function Comments
1892. Approximate match
_____Match cell that begins with string and ends with another string  a single character in between
_____Merge matching rows
Max
1898. MAX function not working
1900. Max function for text
1901. AGGREGATE function  MAX
Min
_____MINIFS function date
1908. AGGREGATE function  MIN
1911. MIN function example
1913. MIN function not working
1914. Bill reminder in excel
Minute
Month
1916. How to sort by month?
1921. MONTH Function example
1923. Sum by month and year
1924. Year and month
1928. Building monthly sheets
1929. Create remaining months
1930. How to change the month
1931. Worksheet Month
Multiply, multiplication, product
1944. SUMPRODUCT if not NA
1948. SUMPRODUCT if or
Negative, minus, subtract
New line
Not equal
1968. How to sum not equal to
Or logic
Overlapping
1970. Sum overlapping time
Partial, wildcard, contain
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
1975. How to calculate row numbers of two cells containing search values next to each other vertically?
1980. Partial match and return multiple adjacent values corresponding to the number of matching values
Permut
1984. PERMUT function example
Random
1996. Sort in random order
1998. Random names
_____Random list
2001. Random numbers
2002. Random text strings
_____Random date values
2003. Random time values
Rearrange, distribute
2008. Rearrange data
Record, row
_____Get every other row
2022. TOROW Function example
2023. Unique distinct rows
2024. Unique rows
_____Extract unique rows
_____Count rows with data
2033. ROWS function example
2035. How to sum a row?
2036. How to add a row
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
_____Count value per row
_____How to calculate row numbers of two cells containing search values next to each other vertically?
2043. How to number rows
_____Merge matching rows
Recursive
Reference
_____Reference a column
Relation, related
Reverse
2072. Reverse horizontal axis
2073. Reverse text
Right, left
2074. Search right to left
2080. RIGHT function example
2083. LEFT function Example
_____LEFT until character
2084. LEFT until dash
2085. LEFT until number
2086. MID function from right
Running total
Schedule
2094. Shift Schedule
2097. Weekly schedule template
Second
Sequence, consecutive
Shared, common, exist
Small, smaller, less
2119. SMALL function for text
2123. SMALL function examples
Solver
Sort, A to Z, z to a, ascending, descending
_____Sort in random order
2126. SORTBY Function example
2127. How to sort from A to Z?
2128. How to sort from Z to A?
2130. Sort by word length
_____Sort in random order
2131. Sort by week number
2132. Sort by quarter
2134. SORT Function example
2141. Sort data
_____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
2143. Sort algorithm
_____Sort two columns
2153. Sort alphanumeric values
Split
String
2160. CLEAN function  string
2163. Convert string to HEX
2164. Convert string to ASCII
2165. Convert string to Base64
_____Match cell that begins with string and ends with another string  a single character in between
_____Random text strings
2168. Exact word in string
Substitute, replace
2170. REPLACE function example
Subtotal
2182. Start the Subtotal tool
Sum, total
2186. IMSUM function example
2187. How to sum a cell range
_____Sum overlapping time
2197. AGGREGATE function  SUM
_____Sum by group
2198. Sum by text
_____Sum by category
_____Sum by group
_____Sum by column value
2199. Sum by color
_____How to sum a row?
2208. How to sum by color?
_____VLOOKUP sum
2216. Totals worksheet
_____Remove totals
2223. Sum unique numbers
2225. Sum only visible cells
Sumif
Sumifs
_____SUMIFS function or
Sumproduct
_____SUMPRODUCT if not NA
_____SUMPRODUCT if or
Tab
2230. Tabula recta
Table, excel table
2233. How to use Excel Tables
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
2242. Create an Excel Table
2243. Excel Table and slicers
2245. Create Excel Tables
_____Two index table
2249.
Excel defined tables
Team, tournament
2253. Team Generator
Text
2273. Excel text functions
_____Sum by text
2276. AND function with text
2277. Year as text
_____VLOOKUP part of text
_____Reverse text
_____Random text strings
Time
_____Sum overlapping time
2289. What is time in Excel?
2290. TIME Function example
_____How to AVERAGE time
2291. Time formats
2292. Time sheet for work
2297. One time pad cipher
_____Random time values
Unique
2299. UNIQUE Function example
2300. Unique values
_____Unique rows
_____Extract unique rows
_____Unique columns
_____VLOOKUP unique
_____Sum unique numbers
Vlookup
_____VLOOKUP alternatives
_____VLOOKUP returns #N/A
_____VLOOKUP yes if true
_____VLOOKUP part of text
_____VLOOKUP sum
_____VLOOKUP true false
_____VLOOKUP unique
_____Fuzzy VLOOKUP
Week
_____Sort by week number
2302. Year by week?
_____Highlight weekends
Year
2305. YEAR function example
_____Year and month
2307. Year and quarter
_____Year as text
_____Year by week?

[…] Learn how to create a stock chart in excel […]