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

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

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

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

5. Follow stock market trends – Moving Average

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

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

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

8. Extract numbers from a column

9. Extract specific word based on position in cell 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

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

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

43. SMALL function ignore duplicates

44. Sum numerical ranges between two 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

### 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. Filter unique distinct records case sensitive

3. How to use the BYROW function

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

6. Vlookup a cell range and return multiple values

### Calendar

2. Create a drop down calendar

4. Highlight events in a yearly calendar

7. Plot date ranges in a 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

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

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

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

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

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

### 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 group items by quarter using formulas

2. How to perform a two-dimensional lookup

3. How to use the CHOOSE function

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

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

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.