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

5. Financial functions – PMT to RATE

7. Find numbers closest to sum

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

1. Financial functions – A to PD

### ACCRINTM function

1. Financial functions – A to PD

### ACOS function

1. How to use the ACOS function

### ACOSH function

1. How to use the ACOSH function

### ACOT function

1. How to use the ACOT function

### ACOTH function

1. How to use the ACOTH 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

### AMORDEGRC function

1. How to use the AMORDEGRC function

### AMORLINC function

1. Financial functions – A to PD

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

### ASINH function

1. How to use the ASINH 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

### ATANH function

1. How to use the ATANH 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. How to list unique distinct values sorted by frequency

31. How to perform a two-dimensional lookup

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

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

35. How to use the COLUMN function

37. INDEX MATCH with multiple criteria

38. List all unique distinct rows in a given month

39. Lookup with any number of criteria

40. Match two criteria and return multiple records

41. Merge tables based on a condition

42. Partial match for multiple strings – AND logic

43. Rearrange values in a cell range to a single column

44. Remove common records between two data sets

45. Search related table based on a date and date range

46. Sort based on frequency row-wise

47. Sort items by adjacent number in every other value

48. Sort values by corresponding text arranged in a column

49. True round-robin tournament

50. Unique distinct records sorted based on count or frequency

51. VLOOKUP – Return multiple unique distinct values

52. Vlookup a cell range and return multiple values

53. Wildcard lookups and include or exclude criteria

### COLUMNS function

1. 5 easy ways to VLOOKUP and return multiple values

2. Array Manipulation Functions

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

4. Create a drop down calendar

5. Distribute values across numerical ranges

7. Extract all rows from a range that meet criteria in one column

8. Filter unique distinct records

9. Filter unique distinct records case sensitive

10. How to color chart bars based on their values

11. How to compare two data sets

12. How to copy non contiguous cell ranges

13. How to create date ranges in Excel

14. How to extract rows containing digits [Formula]

15. How to use the COLUMNS function

16. How to use the MAKEARRAY function

17. Identify rows of overlapping records

18. If cell contains text from list

19. Match two criteria and return multiple records

20. Partial match with two conditions and return multiple results

21. Perform multiple partial matches and return records – AND logic

22. Rearrange values in a cell range to a single column

23. Rearrange values using formulas

24. Search each column for a string each and return multiple records – OR logic

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

26. Search related table based on a date and date range

28. Sort items by adjacent number in every other value

29. Split values equally into groups

30. Use a drop down list to search and return multiple values

31. VLOOKUP/XLOOKUP of three columns to pull a single record

### COMBIN function

1. How to use the COMBIN function

2. True round-robin tournament

### COMBINA function

1. How to use the COMBINA function

### Combination chart

### Combinations

1. Identify numbers in sum using Excel solver

### Combine Merge

1. Group rows based on a condition

2. Merge cell ranges into one list

4. Merge tables based on a condition

5. Merge two columns with possible blank cells

### Combobox

1. Apply dependent combo box selections to a filter

2. Working with COMBO BOXES [Form Controls]

### Compare

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

2. Compare two columns and extract differences

3. Compare two columns in different worksheets

4. Extract shared values between two columns

5. Filter values in common between two cell ranges

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

7. Filter values that exists in all three columns

8. How to highlight differences and common values in lists

9. What values are missing in List 1 that exists i List 2?

### COMPLEX function

1. Engineering functions – A to C

2. Engineering functions – IMD to Z

### Complex numbers

### CONCAT function

1. How to extract numbers from a cell value

2. How to use the CONCAT function

### Concatenate

2. Concatenate unique distinct values

3. Lookup and return multiple values concatenated into one cell

4. Use a drop down list to filter and concatenate unique distinct values

### CONCATENATE function

2. How to use the CONCATENATE function

### Conditional formatting

1. Advanced Date Highlighting Techniques in Excel

2. Advanced Techniques for Conditional Formatting

3. Count Conditionally Formatted cells

4. Highlight date ranges overlapping selected record [VBA]

5. Highlight duplicates in a filtered Excel Table

6. Highlight unique values in a filtered Excel table

7. How to highlight differences and common values in lists

8. How to highlight duplicate values

9. Working with Conditional Formatting formulas

### CONFIDENCE

### CONFIDENCE.NORM

1. How to use the CONFIDENCE.NORM function

### CONFIDENCE.T function

1. How to use the CONFIDENCE.T function

### CONVERT function

1. Engineering functions – A to C

### CORREL function

1. How to use the CORREL function

### COS function

1. Engineering functions – D to IMC

2. Engineering functions – IMD to Z

3. How to use the COS function

### COSH function

1. How to use the COSH function

### COT function

1. How to use the COT function

### COTH function

1. How to use the COTH function

### Count

1. Count a specific text string in a cell

2. Count cells containing text from list

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

6. How to use the COUNTIF function to count not blank cells

### COUNT function

1. Count unique distinct values

2. Create a dynamic named range

3. Create dependent drop down lists containing unique distinct values

4. Extract specific word based on position in cell value

6. How to create date ranges in Excel

7. How to use the COUNT function

8. If cell contains multiple values

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

### Count text values

1. How to count the number of values separated by a delimiter

### Count unique distinct records

1. Count unique distinct records

### Count unique distinct values

1. Count unique distinct values

2. Count unique distinct values based on a condition

3. Count unique distinct values that meet multiple criteria

### Count values

1. Count cells based on background color

2. Count cells between specified values