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

557. Columns

Combination, combin

Complex, imaginary

Concatenate, combine, merge, join, append

Conditional formatting, cf, highlight

Count

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

1648. Bifid
1649. 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

2141. 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. Financial functions – PMT to RATE

6. Find closest value

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

12. Lookup the nearest date

13. Split expenses calculator

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

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

AMORDEGRC function

1. How to use the AMORDEGRC function

AMORLINC function

1. Financial functions – A to PD

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

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

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

34. How to use Excel Tables

35. How to use the COLUMN function

36. How to use the Scroll Bar

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

6. Dynamic scoreboard

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

27. Sort by multiple columns

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

2. Return all combinations

Combine Merge

1. Group rows based on a condition

2. Merge cell ranges into one list

3. Merge Ranges Add-In

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

1. Concatenate cell values

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

1. Concatenate cell values

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

3. Count cells with text

4. Count rows containing data

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

5. Fuzzy VLOOKUP

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

10. Split expenses calculator

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

3. Count cells containing text from list

4. Count Conditionally Formatted cells