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
241. Alternative formula
242. VLOOKUP alternatives
And logic
Autofilter
257. Enable Autofilter
Average
302. AVERAGE ignore NA()
306. How to AVERAGE time
Blank, space
Calendar
408. Pivot Table calendar
412. Worksheet Calendar
415. Calendar sheet
Case
Character
487. LEFT until character
511. Match cell that begins with string and ends with another string  a single character in between
Column
546. Columns
548. Unique columns
600. How to add a column
603. Reference a column
____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
624. Helper column
662. Sort two columns
676. Merge two columns
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
767. Unmerge cells
778. Merge matching rows
784. Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
Conditional formatting, cf, highlight
810. Highlight weekends
860. Highlight records
Count
883. Count rows with data
884. Count nonempty rows
889. Count values by sign
922. OR function COUNTIF
931. Count
937. Count value per row
Countif
Countifs
Criteria, multiple conditions, conditions
1018. How to add criteria
Date
1063. How to split date value
1071. MINIFS function date
1089. WEEKDAYS between dates
1100. Is date an Excel date?
1103. Year and month to date?
1105. Date function example
1107. Date function format
1110. Date function add days
1112. Date function add months
1113. Date formats
1122. VLOOKUP between dates
1125. Create a date range
1137. Most overlapped date
1138. Least overlapped date
1146. Working with date ranges
1158. Random date values
_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
1195. Basic date ranges
1196. Create a date sequence
1198. Lookup the nearest date
Day
1214. WEEKDAY Function Video
1215. WEEKDAY Function example
1219. DAY Function example
1220. DAY Function not working
1227. Worksheet Day
Decimal
Delete, remove
1248. Remove totals
Digit
1267. Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
Duplicates
1277. Extract duplicates
Dynamic
1282. Dynamic scoreboard
1286. Create a dynamic range
1289. Dynamic team generator
Empty
_____Count nonempty rows
Equal, condition, criterion
1327. IF function  equals
Error, problem
1345. IMTAN function error
1346. BIN2HEX Function error
1349. DROP Function errors
1350. HSTACK Function errors
1351. VSTACK Function errors
1356. BIN2OCT Function error
1357. BIN2DEC Function error
1358. DEC2OCT Function error
1359. DEC2HEX Function error
1360. DEC2BIN Function error
1361. CONVERT Function error
1364. Excel error functions
1366. ISERROR function example
1367. Error in data
_____#NAME! error
_____What is #N/A error
1372. SUMPRODUCT if not error
1379. IFERROR function example
1385. INDEX function error
Extend, expand
1388. EXPAND Function example
Extract, list, filter, get
1393. Get Excel *.xlsx file
_____Enable Autofilter
1394. Get Excel * .xlsx file
1396. Add a drop down list
1399. Get every other row
1416. FILTER Function example
1427. Extract unique values
1430. Extract unique rows
1435. Filter values by sign
1439. Get the latest revision
1441. Filter text values
1447. Get most frequent value
1455. Extract the last word
1456. Extract the last letter
1457. Extract the last number
1469. Get Excel *.xlsx file
1471. Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
1475. Unique distinct list sorted alphabetically based on a numerical range  Earlier Excel versions
_____Get *.xlsx file
_____Get *.xlsx file
_____Get *.xlsx file
1478. Get Excel *.xlsm file
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
1489. Unique distinct list
1492. Insert a drop down list
1494. Build a DropDown List
1497. Nihilist cipher
1501. Random list
1502. List consecutive numbers
_____Get *.xlsx file
1525. Create a random playlist
1534. Extract unique distinct values if the value contains the given string  earlier Excel versions
1540. Extract unique distinct values sorted based on sum of adjacent values  earlier Excel versions
_____Extract duplicates
Finance, stock, expense
First, last
1577. Search last to first
1583. INDEX MATCH  Last value
Group, category
1590. Custom groups
1591. How to sum by group
1593. Group data
Hour
1599. HOUR function Argument
1600. HOUR function Example
Hyperlink, link
If
1629. If cell has value
1634. IF with OR function
1636. If cell contains text
1643. OR function with IF
1650. VLOOKUP yes if true
1652. Bifid
1653. Trifid
1656. IF function example
_____IF function  equals
1665. IF function  ends with
1666. IF function  contains
1668. IF function  AND OR
1671. IF function  add value?
Ifs
1689. MINIFS function example
_____MINIFS function date
1693. IFS function example
1696. MAXIFS function example
1703. SUMIFS function or
Ignore, avoid, prevent, exclude, hide
1712. MIN function ignore text
_____AVERAGE ignore NA()
1721. How to hide zeros
1722. How to hide text values
Image, picture
1727. IMAGE Function example
1729. Heat map using pictures
Index
1733. INDEX Function Example
_____INDEX function error
1740. Two index table
Index match, index and match
1745. VLOOKUP vs INDEX MATCH
Intersection
Lambda
1748. LAMBDA function example
1749. Build LAMBDA function
1750. Name the LAMBDA function
Large, larger, highest, greater
1760. LARGE function  example
Letter
Lookup, find, identify
1789. FIND Function example
1801. Video  HLOOKUP function
1805. VLOOKUP function formula
_____VLOOKUP alternatives
1816. VLOOKUP another sheet
1817. VLOOKUP keep formatting
_____VLOOKUP returns #N/A
_____VLOOKUP yes if true
1819. VLOOKUP part of text
1820. VLOOKUP sum
1821. VLOOKUP true false
1822. VLOOKUP unique
1825. Find the time difference
1833. Nested LOOKUP functions
_____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
1858. Find lower prices
1859. Find higher prices
1860. Fuzzy lookups
1861. Fuzzy VLOOKUP
_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]
1876. Find missing numbers
1879. Find closest value
1880. Find the closest value
1881. Find closest values
Match
1885. XMATCH Function Comments
1889. Approximate match
_____Match cell that begins with string and ends with another string  a single character in between
_____Merge matching rows
Max
1895. MAX function not working
1897. Max function for text
1898. AGGREGATE function  MAX
Min
_____MINIFS function date
1905. AGGREGATE function  MIN
1908. MIN function example
1910. MIN function not working
1911. Bill reminder in excel
Minute
Month
1913. How to sort by month?
1918. MONTH Function example
1920. Year and month
1924. Building monthly sheets
1925. Create remaining months
1926. How to change the month
1928. Worksheet Month
Multiply, multiplication, product
1940. SUMPRODUCT if not NA
1944. SUMPRODUCT if or
Negative, minus, subtract
New line
Not equal
1964. How to sum not equal to
Or logic
Overlapping
1966. 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)
1971. How to calculate row numbers of two cells containing search values next to each other vertically?
1976. Partial match and return multiple adjacent values corresponding to the number of matching values
Permut
1981. PERMUT function example
Random
1993. Sort in random order
1996. Random names
_____Random list
1999. Random numbers
2000. Random text strings
_____Random date values
2001. Random time values
Rearrange, distribute
2006. Rearrange values
2007. Rearrange data
Record, row
_____Get every other row
2021. TOROW Function example
2022. Unique distinct rows
2023. Unique rows
_____Extract unique rows
_____Count rows with data
_____Count nonempty rows
2032. ROWS function example
2034. How to sum a row?
2035. 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
2044. Format entire row
_____Merge matching rows
_____Highlight records
Recursive
Reference
_____Reference a column
Relation, related
Reverse
2072. Reverse horizontal axis
2073. Reverse text
Right, left
2074. Search right to left
2081. RIGHT function example
2084. LEFT function Example
_____LEFT until character
2085. LEFT until dash
2086. LEFT until number
2088. MID function from right
Running total
Schedule
2096. Weekly schedule template
2097. Shift Schedule
Second
Sequence, consecutive
Shared, common, exist, occur
Small, smaller, less
2120. SMALL function for text
Solver
2124. Excel solver examples
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
2135. SORT Function example
2138. Sort data
_____Sort data
_____Lookup and return multiple sorted values based on corresponding values in another column  Excel 365
_____Sort two columns
2147. Sort values
2148. Sort alphanumeric values
Split
String
2156. CLEAN function  string
2159. Convert string to HEX
2160. Convert string to ASCII
2161. Convert string to Base64
_____Match cell that begins with string and ends with another string  a single character in between
_____Random text strings
2163. Exact word in string
Substitute, replace
2165. REPLACE function example
Subtotal
2177. Start the Subtotal tool
Sum, total
2181. IMSUM function example
2182. How to sum a cell range
2186. DSUM Function Example
_____Sum overlapping time
2192. AGGREGATE function  SUM
_____How to sum by group
_____How to sum a row?
2201. How to sum by color?
_____VLOOKUP sum
2210. Totals worksheet
2211. Summarize and analyze
_____Remove totals
2217. Sum unique numbers
Sumif
Sumifs
_____SUMIFS function or
Sumproduct
_____SUMPRODUCT if not NA
_____SUMPRODUCT if or
Tab
2224. Tabula recta
Table, excel table
2227. How to use Excel Tables
_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)
2235. Excel Table and slicers
2237. Create an Excel Table
2238. Create Excel Tables
_____Two index table
Team, tournament
2243. Team Generator
Text
2260. What is text in Excel?
2261. ISTEXT function example
_____Filter text values
2265. Excel text functions
2268. AND function with text
2269. Year as text
_____VLOOKUP part of text
_____Reverse text
_____Random text strings
Time
_____Sum overlapping time
2279. What is time in Excel?
2280. TIME Function example
_____How to AVERAGE time
2281. Time formats
2282. Time sheet for work
2287. One time pad cipher
_____Random time values
Unique
2289. UNIQUE Function example
2290. 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
2293. Year by week?
_____Highlight weekends
Year
2296. YEAR function example
_____Year and month
2298. Year and quarter
_____Year as text
_____Year by week?

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