This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.

#, hashtag

2D, two-dimensional, two-way

3D, multiple worksheets, multiple sheets

365

Address

Advanced Filter

Alternative

And logic

Autofilter

Average

Blank, space

Calendar

Case

Character

Column

553. Columns

Combination, combin

Complex, imaginary

Concatenate, combine, merge, join, append

Conditional formatting, cf, highlight

Count

929. Count

Countif

Countifs

Criteria, multiple conditions, conditions

Date

Day

Decimal

Delete, remove

Digit

Duplicates

Dynamic

Empty

Equal, condition, criterion

Error, problem

Extend, expand

Extract, list, filter, get

Finance, stock, expense

First, last

Group, category

Hour

If

1633. Bifid
1634. Trifid

Ifs

Ignore, avoid, prevent, exclude, hide

Image, picture

Index

Index match, index and match

Intersection

Lambda

Large, larger, highest, greater

Letter

Lookup, find, identify

Match

Max

Min

Minute

Month

Multiply, multiplication, product

Negative, minus, subtract

New line

Not equal

Or logic

Overlapping

Partial, wildcard, contain

Permut

Random

Rearrange, distribute

Record, row

Recursive

Reference

Relation, related

Reverse

Running total

Schedule

Second

Sequence, consecutive

Shared, common, exist, occur

Small, smaller, less

Solver

Sort, A to Z, z to a, ascending, descending

2111. Sort data

Split

String

Substitute, replace

Subtotal

Sum, total

Sumif

Sumifs

Sumproduct

Tab

Table, excel table

Team, tournament

Text

Time

Unique

Vlookup

Week

Year

Categories

100% stacked column chart

ABS function

1. Calculate the number of weeks between given dates

2. Count cells between specified values

3. Count rows containing data

4. Date and Time Functions – A to M

5. Find closest value

6. Find numbers closest to sum

7. How to create date ranges in Excel

8. How to use the ABS function

9. How to use the asterisk character

10. Identify numbers in sum using Excel solver

11. Lookup the nearest date

12. Split expenses calculator

ACCRINT function

ACCRINTM function

ACOS function

1. How to use the ACOS function

ACOT function

1. How to use the ACOT function

Add-in

1. How to save custom functions and macros to an Add-In

2. Merge Ranges Add-In

3. Split data across multiple sheets – VBA

4. Vlookup across multiple sheets

ADDRESS function

1. Easily select data using hyperlinks

2. How to quickly find the maximum or minimum value [Formula]

3. How to use the ADDRESS function

Advanced filter

AGGREGATE function

1. Convert array formula to a regular formula

2. Count cells between specified values

3. Extract the most repeated adjacent values in a column

4. Filter unique distinct values, sorted and blanks removed from a range

5. How to ignore zeros using the SMALL function

6. How to use the AGGREGATE function

AMORLINC function

AND function

1. Excel calendar

2. Highlight lookups in relational tables

3. How to use the AND function

4. IF function with AND function – multiple conditions

5. Search for a text string in a data set and return multiple records

Animate

1. How to animate an Excel chart

Area chart

AREAS function

1. How to use the AREAS function

ARRAY function

Arrays

1. A beginners guide to Excel array formulas

2. Working with ARRAY VARIABLES (VBA)

ARRAYTOTEXT Function

1. How to use the ARRAYTOTEXT function

ASC function

1. How to use the ASC function

ASIN function

1. How to use the ASIN function

ATAN function

1. Engineering functions – D to IMC

2. How to use the ATAN function

ATAN2 function

1. How to use the ATAN2 function

AVEDEV function

1. How to use the AVEDEV function

AVERAGE function

1. Add buy and sell points to a stock chart

2. AVERAGE based on criteria

3. AVERAGE ignore blanks

4. AVERAGE ignore NA()

5. Follow stock market trends – Moving Average

6. How to AVERAGE time

7. How to use the AVERAGE function

8. Plot buy and sell points in an Excel Chart based on two moving averages

AVERAGEA function

1. How to use the AVERAGEA function

AVERAGEIF function

1. AVERAGE ignore blanks

2. AVERAGE ignore NA()

3. How to use the AVERAGEIF function

AVERAGEIFS function

1. How to use the AVERAGEIFS function

Bar chart

BASE function

1. Engineering functions – D to IMC

2. How to use the BASE function

3. List permutations with repetition and how many to choose from

Basic formulas

1. Calculate the number of weeks between given dates

2. Count a specific text string in a cell

3. Count cells containing text from list

4. Count cells with text

5. Count rows containing data

6. Count specific multiple text strings in a given cell range

7. Excel formula not working

8. Extract numbers from a column

9. Extract specific word based on position in cell value

10. Find closest value

11. Find last matching value in an unsorted list

12. Find last value in a column

13. Find the most recent date that meets a particular condition

14. Find the smallest number in a list that is larger than a given number

15. Formula for matching a date within a date range

16. Get the latest revision

17. How to AVERAGE time

18. How to calculate overlapping time ranges

19. How to create date ranges in Excel

20. How to create running totals

21. How to do tiered calculations in one formula

22. How to extract numbers from a cell value

23. How to ignore zeros using the SMALL function

24. How to perform a two-dimensional lookup

25. How to remove numbers from a cell value

26. How to replace part of formula in all cells

27. How to use nested IF functions

28. If cell contains multiple values

29. If cell contains text

30. If cell contains text from list

31. If cell equals value from list

32. IF function with AND function – multiple conditions

33. INDEX MATCH – Case sensitive

34. INDEX MATCH – multiple results

35. INDEX MATCH with multiple criteria

36. Lookup multiple values across columns and return a single value

37. Lookup with any number of criteria

38. Match two columns and return another value on the same row

39. Running totals based on criteria

40. SMALL function – INDEX MATCH

41. SMALL function – multiple conditions

42. SMALL function for text

43. SMALL function ignore duplicates

44. Sum numerical ranges between two numbers

45. Sum unique numbers

46. Use IF + COUNTIF to evaluate multiple conditions

BETA.DIST function

1. How to use the BETA.DIST function

BETA.INV function

1. How to use the BETA.INV function

BETADIST function

1. Compatibility Functions

BETAINV function

1. Compatibility Functions

BIN2DEC function

1. Engineering functions – A to C

2. Working with classic ciphers in Excel

BIN2HEX function

1. Engineering functions – A to C

BIN2OCT function

1. Engineering functions – A to C

BINOM.DIST function

1. Compatibility Functions

2. How to use the BINOM.DIST function

BINOM.INV function

1. How to use the BINOM.INV function

BINOMDIST function

1. Compatibility Functions

BITAND function

1. Engineering functions – A to C

2. How to use the BITAND function

BITLSHIFT function

1. Engineering functions – A to C

2. How to use the BITLSHIFT function

BITOR function

1. Engineering functions – A to C

BITRSHIFT function

1. Engineering functions – A to C

BITXOR function

1. Engineering functions – A to C

2. Working with classic ciphers in Excel

Blank cells

1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

Box and whisker chart

Bubble chart

BYCOL function

1. How to use the BYCOL function

BYROW function

1. Filter unique distinct records case sensitive

2. Fuzzy VLOOKUP

3. How to use the BYROW function

4. Rearrange data

5. Search for a text string in a data set and return multiple records

6. Vlookup a cell range and return multiple values

Calendar

1. Calendar – monthly view

2. Create a drop down calendar

3. Excel calendar

4. Highlight events in a yearly calendar

5. Monthly calendar template

6. Pivot Table calendar

7. Plot date ranges in a calendar

8. Yet another Excel Calendar

Candlestick chart

Case sensitive

1. Count unique distinct values

2. INDEX MATCH – Case sensitive

CEILING function

1. How to use the CEILING function

CELL function

1. Find last value in a column

2. How to use the CELL function

CF-basic-formulas

1. Working with Conditional Formatting formulas

CF-built-in

CF-compare

1. How to highlight differences and common values in lists

CF-dates

1. Advanced Date Highlighting Techniques in Excel

2. Highlight date ranges overlapping selected record [VBA]

CF-duplicates

1. Highlight duplicates in a filtered Excel Table

2. How to highlight duplicate values

CF-min-max

CF-misc

1. Advanced Techniques for Conditional Formatting

CF-search

CF-unique-distinct

1. Highlight unique values in a filtered Excel table

CHAR function

1. Easily select data using hyperlinks

2. Engineering functions – A to C

3. How to create random numbers, text strings, dates and time values

4. How to decode URL-encoded strings

5. How to extract email addresses from an Excel sheet

6. How to generate random numbers and text

7. How to use the CHAR function

8. Navigate to first empty cell using a hyperlink formula

9. Populate cells dynamically in a weekly schedule

10. Working with classic ciphers in Excel

Chart basics

1. Excel charts tips and tricks

Chart elements

1. Excel chart components

2. How to add chart elements

Charts

1. Add pictures to a chart axis

2. Advanced Excel Chart Techniques

3. Change chart axis range programmatically

4. Color chart columns based on cell color

5. Compare data in an Excel chart using drop down lists

6. Dynamic stock chart

7. Excel chart components

8. Excel charts tips and tricks

9. Heat map using pictures

10. Highlight a data series in a chart

11. Highlight group of values in an x y scatter chart programmatically

12. Hover with mouse cursor to change stock in a candlestick chart

13. How to add chart elements

14. How to add horizontal line to chart

15. How to animate an Excel chart

16. How to build an interactive map in Excel

17. How to color chart bars based on their values

18. How to create an interactive Excel chart [VBA]

19. How to create charts in Excel

20. How to filter chart data

21. How to improve your Excel Chart

22. How to position month and year between chart tick marks

23. How to use mouse hover on a worksheet [VBA]

24. Use drop down lists and named ranges to filter chart values

Check-boxes

1. Add checkboxes and copy values – VBA

2. Multi-level To-Do list template

3. Open Excel files in a folder [VBA]

4. Toggle a macro on/off using a button

CHIDIST function

1. Compatibility Functions

CHIINV function

1. Compatibility Functions

CHISQ.DIST function

1. Compatibility Functions

2. How to use the CHISQ.DIST function

CHISQ.DIST.RT function

1. How to use the CHISQ.DIST.RT function

CHISQ.INV function

1. How to use the CHISQ.INV function

CHISQ.INV.RT function

1. How to use the CHISQ.INV.RT function

CHISQ.TEST function

1. How to use the CHISQ.TEST function

CHITEST function

1. Compatibility Functions

CHOOSE function

1. How to group items by quarter using formulas

2. How to perform a two-dimensional lookup

3. How to use the CHOOSE function

4. Time sheet for work

CHOOSECOLS function

1. Array Manipulation Functions

CHOOSEROWS function

1. Array Manipulation Functions

CLEAN function

1. How to use the CLEAN function

CODE function

1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

2. How to use the CODE function

3. Search for a text string in a data set and return multiple records

4. Working with classic ciphers in Excel

Column

Column chart

1. Color chart columns based on cell color

2. How to add horizontal line to chart

3. How to animate an Excel chart

4. How to create charts in Excel

COLUMN function

1. 5 easy ways to VLOOKUP and return multiple values

2. A Comprehensive Guide to Splitting Text in Excel

3. Apply dependent combo box selections to a filter

4. Array Manipulation Functions

5. Auto populate a worksheet

6. Bill reminder in excel

7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

8. Compare tables: Filter records occurring only in one table

9. Count identical values if they are on the same row

10. Count unique distinct values

11. Create a quartely date range

12. Create numbers based on numerical ranges

13. Dynamic scoreboard

14. Excel calendar

15. Extract a list of duplicates from a column

16. Extract a unique distinct list and sum amounts based on a condition

17. Extract duplicates from a multi-column cell range

18. Extract records between two dates

19. Filter unique distinct records

20. Filter unique distinct records case sensitive

21. Filter unique distinct values, sorted and blanks removed from a range

22. Filter unique values from a cell range

23. Filter values in common between two cell ranges

24. Filter values occurring in range 1 but not in range 2

25. Fuzzy VLOOKUP

26. Get date ranges from a schedule

27. Group rows based on a condition

28. How to extract email addresses from an Excel sheet

29. How to group items by quarter using formulas

30.