## Excel formula examples

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

### Combination, combin

### Complex, imaginary

### Concatenate, combine, merge, join, append

### Conditional formatting, cf, highlight

### 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

### Hyperlink, link

### If

### 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

### Right, left

### Running total

### Schedule

### Second

### Sequence, consecutive

### Shared, common, exist, occur

### Small, smaller, less

### Solver

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

### 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

4. Date and Time Functions – A to M

6. Find numbers closest to sum

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

8. How to create date ranges in Excel

9. How to use the ABS function

10. How to use the asterisk character

11. Identify numbers in sum using Excel solver

### 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. Split data across multiple sheets – VBA

### 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 unique distinct values from a multi-column cell range

4. How to use the AGGREGATE function

### AMORLINC function

### AND function

2. How to use the AND function

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

4. Working with Relational Tables in Excel

### 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

### 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

2. Follow stock market trends – Moving Average

3. How to use the AVERAGE function

### AVERAGEA function

1. How to use the AVERAGEA function

### AVERAGEIF function

1. 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

### 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

6. Extract numbers from a column

7. Extract specific word based on position in cell value

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

10. Formula for matching a date within a date range

11. How to create date ranges in Excel

12. How to do tiered calculations in one formula

13. How to extract numbers from a cell value

14. How to perform a two-dimensional lookup

15. How to remove numbers from a cell value

16. How to replace part of formula in all cells

17. If cell contains text from list

18. INDEX MATCH – multiple results

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

20. Lookup with any number of criteria

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

22. Working with running totals

### BETA.DIST function

1. How to use the BETA.DIST function

### BETA.INV function

1. How to use the BETA.INV function

### BETADIST function

### BETAINV function

### 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

2. How to use the BINOM.DIST function

### BINOM.INV function

1. How to use the BINOM.INV function

### BINOMDIST function

### 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. 5 easy ways to VLOOKUP and return multiple values

2. Calculate machine utilization

3. Filter unique distinct records case sensitive

5. How to use the BYROW function

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

### Calendar

2. Highlight events in a yearly calendar

5. Plot date ranges in a calendar

### Candlestick chart

### Case sensitive

1. Count unique distinct values

### CEILING function

1. How to use the CEILING function

### CELL function

1. How to use the CELL function

2. INDEX MATCH – multiple results

### 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

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

5. How to decode URL-encoded strings

6. How to extract email addresses from an Excel sheet

7. How to generate random numbers and text

8. How to use the CHAR function

9. Navigate to first empty cell using a hyperlink formula

10. Working with classic ciphers in Excel

### Chart basics

1. Excel charts tips and tricks

### 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

8. Excel charts tips and tricks

10. Highlight a data series in a chart

12. How to add horizontal line to chart

13. How to animate an Excel chart

14. How to color chart bars based on their values

15. How to create an interactive Excel chart

16. How to create charts in Excel

17. How to improve your Excel Chart

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

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

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

### Check-boxes

1. Add checkboxes and copy values – VBA

### CHIDIST function

### CHIINV function

### CHISQ.DIST function

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

### CHOOSE function

1. How to perform a two-dimensional lookup

2. How to use the CHOOSE function

3. Split data across multiple sheets – VBA

### 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. Array Manipulation Functions

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

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

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

8. Count unique distinct values

9. Create a quartely date range

11. Excel calendar

12. Extract a list of duplicates from a column

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

14. Extract duplicates from a multi-column cell range

15. Extract records between two dates

16. Extract unique distinct values from a multi-column cell range

17. Filter unique distinct records

18. Filter unique distinct records case sensitive

19. Filter values in common between two cell ranges

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

21. Fuzzy VLOOKUP

22. Get date ranges from a schedule

23. Group rows based on a condition

24. How to extract email addresses from an Excel sheet

25. How to generate a round-robin tournament

26. How to list unique distinct values sorted by frequency

27. How to perform a two-dimensional lookup

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

29. How to return a value if lookup value is in a range

30. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA

32. How to use Pivot Tables – Excel’s most powerful feature and also least known

33.