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

498. Columns

Combination, combin

Complex, imaginary

Concatenate, combine, merge, join, append

Conditional formatting, cf, highlight

Count

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

1449. Bifid
1450. 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

1721. Wildcard

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

1860. 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. Count cells containing text from list

2. Find numbers closest to sum

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

4. How to create date ranges in Excel

5. How to use the ABS function

6. How to use the asterisk character

7. Identify numbers in sum using Excel solver

8. INDEX MATCH – multiple results

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

ADDRESS function

1. How to use the ADDRESS function

Advanced filter

AGGREGATE function

1. Count cells containing text from list

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

3. How to use the AGGREGATE function

AMORLINC function

AND function

1. Count cells containing text from list

2. Excel calendar

3. How to use the AND function

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

5. 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. Complex Calculations: A Guide to Excel’s IM Functions

2. Engineering functions – D to IMC

3. 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. Follow stock market trends – Moving Average

2. 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. Count cells containing text from list

2. Excel formula not working

3. Extract specific word based on position in cell value

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

5. Formula for matching a date within a date range

6. How to create date ranges in Excel

7. How to do tiered calculations in one formula

8. How to extract numbers from a cell value

9. How to perform a two-dimensional lookup

10. If cell contains text from list

11. INDEX MATCH – multiple results

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

13. Lookup with any number of criteria

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

1. Compatibility Functions

BETAINV function

1. Compatibility Functions

BIN2DEC function

1. How to use the BIN2DEC function

2. Working with classic ciphers in Excel

BIN2HEX function

1. How to use the BIN2HEX function

BIN2OCT function

1. How to use the BIN2OCT function

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. How to use the BITAND function

BITLSHIFT function

1. How to use the BITLSHIFT function

BITOR function

1. How to use the BITOR function

BITRSHIFT function

1. How to use the BITRSHIFT function

BITXOR function

1. How to use the BITXOR function

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. Count cells containing text from list

4. Filter unique distinct records case sensitive

5. Fuzzy VLOOKUP

6. How to do tiered calculations in one formula

7. How to use the BYROW function

8. Rearrange values using formulas

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

Calendar

1. Excel calendar

2. Monthly calendar template

3. Plot date ranges in a calendar

4. Yet another Excel 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

CF-duplicates

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

2. How to use the CHAR function

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

4. 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. Advanced Excel Chart Techniques

2. Excel chart components

3. Excel charts tips and tricks

4. Highlight a data series in a chart

5. How to add chart elements

6. How to add horizontal line to chart

7. How to animate an Excel chart

8. How to create an interactive Excel chart

9. How to create charts in Excel

10. How to improve your Excel Chart

Check-boxes

1. Add checkboxes and copy values – VBA

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 perform a two-dimensional lookup

2. How to use the CHOOSE function

3. Split data across multiple sheets – VBA

4. Time sheet for work

CHOOSECOLS function

1. How to use the CHOOSECOLS function

CHOOSEROWS function

1. How to use the CHOOSEROWS function

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. How to add horizontal line to chart

2. How to animate an Excel chart

3. 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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

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

5. Compare two columns in different worksheets

6. Count cells containing text from list

7. Count unique distinct values

8. Dynamic scoreboard

9. Excel calendar

10. Extract a list of duplicates from a column

11. Extract duplicates from a multi-column cell range

12. Extract records between two dates

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

14. Filter unique distinct records

15. Filter unique distinct records case sensitive

16. Fuzzy VLOOKUP

17. Get date ranges from a schedule

18. How to compare two data sets

19. How to create date ranges in Excel

20. How to generate a round-robin tournament

21. How to list unique distinct values sorted by frequency

22. How to perform a two-dimensional lookup

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

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

25. How to use Excel Tables

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

27. How to use the COLUMN function

28. How to use the Scroll Bar

29. INDEX MATCH – multiple results

30. Lookup with any number of criteria

31. Match two criteria and return multiple records

32. Merge cell ranges into one list

33. Merge tables based on a condition

34. Partial match for multiple strings – AND logic

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

36. Sort a column alphabetically

37. Split data across multiple sheets – VBA

38. Split expenses calculator

39. Unique distinct records sorted based on count or frequency

40. VLOOKUP – Return multiple unique distinct values

41. Wildcard lookups and include or exclude criteria

42. Working with COMBO BOXES [Form Controls]

43. Working with Relational Tables in Excel

44. Working with unique values

COLUMNS function

1. 5 easy ways to VLOOKUP and return multiple values

2. Count cells containing text from list

3. Dynamic scoreboard

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

5. Filter unique distinct records

6. Filter unique distinct records case sensitive

7. How to compare two data sets

8. How to copy non contiguous cell ranges

9. How to create date ranges in Excel

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

11. How to use the COLUMNS function

12. How to use the MAKEARRAY function

13. How to use VLOOKUP/XLOOKUP with multiple conditions

14. Identify rows of overlapping records

15. If cell contains text from list

16. Match two criteria and return multiple records

17. Populate drop down list with unique distinct values sorted from A to Z

18. Rearrange values using formulas

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

20. Sort a column alphabetically

21. Split data across multiple sheets – VBA

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

23. Working with Relational Tables in Excel

COMBIN function

1. How to generate a round-robin tournament

2. How to use the COMBIN function

COMBINA function

1. How to use the COMBINA function

Combination chart

Combinations

1. Identify numbers in sum using Excel solver

Combine Merge

1. Merge cell ranges into one list

2. Merge tables based on a condition

Combobox

1. 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. How to highlight differences and common values in lists

COMPLEX function

1. Complex Calculations: A Guide to Excel’s IM Functions

Complex numbers

CONCAT function

1. How to extract numbers from a cell value

2. How to use the CONCAT function

Concatenate

1. Lookup and return multiple values concatenated into one cell

CONCATENATE function

1. How to use the CONCATENATE function

Conditional formatting

1. Advanced Date Highlighting Techniques in Excel

2. Advanced Techniques for Conditional Formatting

3. Count cells based on color

4. Highlight unique values in a filtered Excel table

5. How to highlight differences and common values in lists

6. How to highlight duplicate values

7. 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. How to use the CONVERT function

CORREL function

1. How to use the CORREL function

COS function

1. Complex Calculations: A Guide to Excel’s IM Functions

2. Engineering functions – D to IMC

3. How to use the COS function

COT function

1. How to use the COT function

Count

1. Count cells containing text from list

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 text from list

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

10. Split expenses calculator

Count text values

Count unique distinct records

1. Count unique distinct records

Count unique distinct values

1. Count unique distinct values

Count values

1. Count cells based on color

2. Count cells containing text from list

3. Count unique distinct values

COUNTA function

1. Add values to a regular drop-down list programmatically

2. Automate net asset value (NAV) calculation on your stock portfolio

3. Compare the performance of your stock portfolio to S&P 500 using Excel

4. Count unique distinct values

5. Create a dynamic named range

6. Create dependent drop down lists containing unique distinct values

7. Create number series

8. How to compare two data sets

9. How to generate a round-robin tournament

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

11. How to use the COUNTA function

12. Lookup with any number of criteria

13. Match two criteria and return multiple records

14. Team Generator

15. Wildcard lookups and include or exclude criteria

COUNTBLANK function

1. How to use the COUNTBLANK function

COUNTIF

COUNTIF function

1. 5 easy ways to extract Unique Distinct Values

2. 5 easy ways to VLOOKUP and return multiple values

3. A beginners guide to Excel array formulas

4. Automate net asset value (NAV) calculation on your stock portfolio

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

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

7. Compare the performance of your stock portfolio to S&P 500 using Excel

8. Compare two columns and extract differences

9. Compare two columns in different worksheets

10. Compatibility Functions

11. Count unique distinct records

12. Count unique distinct values

13. Create dependent drop down lists containing unique distinct values

14. Create number series

15. Dynamic scoreboard

16. Extract a list of duplicates from a column

17. Extract a unique distinct list from multiple non adjacent cell ranges

18. Extract a unique distinct list sorted from A to Z

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

20. Extract duplicates from a multi-column cell range

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

22. Extract unique distinct values from an Excel Table filtered list

23. Filter duplicate values based on criteria

24. Filter unique distinct records

25. Find all sequences of consecutive dates

26. Find missing numbers

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

28. Get date ranges from a schedule

29. Highlight unique values in a filtered Excel table

30. How to compare two data sets

31. How to generate a round-robin tournament

32. How to highlight duplicate values

33. How to list unique distinct values sorted by frequency

34. How to perform a two-dimensional lookup

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

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

37. How to use the COUNTIF function

38. How to use VLOOKUP/XLOOKUP with multiple conditions

39. If cell contains text from list

40. INDEX MATCH – multiple results

41. Lookup with any number of criteria

42. Match two criteria and return multiple records

43. Merge cell ranges into one list

44. Partial match and return multiple adjacent values

45. Partial match for multiple strings – AND logic

46. Plot date ranges in a calendar

47. Populate drop down list with unique distinct values sorted from A to Z

48. Repeat values across cells

49. Rotating unique groups with no repeat

50. Sort a column alphabetically

51. Split expenses calculator

52. Team Generator

53. Time sheet for work

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

55. VLOOKUP – Return multiple unique distinct values

56. Working with COMBO BOXES [Form Controls]

57. Working with unique values

COUNTIFS function

1. Calculate machine utilization

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

3. Count cells containing text from list

4. Count unique distinct records

5. Count unique distinct values

6. Extract a list of duplicates from a column

7. Extract dates from overlapping date ranges

8. Extract unique distinct values from an Excel Table filtered list

9. Filter unique distinct records

10. Get date ranges from a schedule

11. How to compare two data sets

12. How to create date ranges in Excel

13. How to highlight differences and common values in lists

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

15. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

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

17. How to use the COUNTIFS function

18. How to use VLOOKUP/XLOOKUP with multiple conditions

19. Identify rows of overlapping records

20. INDEX MATCH – multiple results

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

22. Match two criteria and return multiple records

23. Merge tables based on a condition

24. Prevent duplicate records in a worksheet

25. Search for a sequence of values

26. Split data across multiple sheets – VBA

27. Unique distinct records sorted based on count or frequency

28. Working with Conditional Formatting formulas

29. Working with overlapping date ranges

30. Working with Relational Tables in Excel

COVAR function

1. Compatibility Functions

COVARIANCE.P function

1. How to use the COVARIANCE.P function

COVARIANCE.S function

1. How to use the COVARIANCE.S function

CRITBINOM function

1. Compatibility Functions

CSC function

1. How to use the CSC function

CUMIPMT function

CUMPRINC function

Custom charts

1. Advanced Excel Chart Techniques

Data labels

Data validation

1. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

2. Prevent duplicate records in a worksheet

Date and Time

DATE function

1. Count unique distinct values

2. Excel calendar

3. Filter unique distinct records

4. Get date ranges from a schedule

5. How to create date ranges in Excel

6. How to track sector performance in the stock market – Excel template

7. How to use the DATE function

8. Monthly calendar template

9. Plot date ranges in a calendar

10. Populate drop down list with unique distinct values sorted from A to Z

11. Split data across multiple sheets – VBA

12. Working with date ranges

13. Yet another Excel Calendar

DATEDIF function

1. How to use the DATEDIF function

Dates

1. Calculate machine utilization

2. Extract dates from overlapping date ranges

3. Find all sequences of consecutive dates

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

5. Formula for matching a date within a date range

6. Get date ranges from a schedule

7. How to create date ranges in Excel

8. Identify rows of overlapping records

9. Working with date ranges

10. Working with overlapping date ranges

Dates

1. Calculate machine utilization

2. Extract dates from overlapping date ranges

3. Find all sequences of consecutive dates

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

5. Formula for matching a date within a date range

6. Get date ranges from a schedule

7. How to create date ranges in Excel

8. Working with date ranges

DATEVALUE function

1. Formula for matching a date within a date range

2. How to use the DATEVALUE function

DAVERAGE function

DAY function

1. Automate net asset value (NAV) calculation on your stock portfolio

2. Follow stock market trends – Moving Average

3. Get date ranges from a schedule

4. How to track sector performance in the stock market – Excel template

5. How to use the DAY function

6. Monthly calendar template

7. Populate drop down list with unique distinct values sorted from A to Z

8. Split expenses calculator

DAYS function

1. How to use the DAYS function

DB function

DCOUNT function

DDB function

DEC2BIN function

1. Engineering functions – D to IMC

2. Working with classic ciphers in Excel

DEC2HEX function

1. Engineering functions – D to IMC

2. Working with classic ciphers in Excel

DEC2OCT function

1. Engineering functions – D to IMC

DECIMAL function

1. How to use the DECIMAL function

DEGREES function

1. Complex Calculations: A Guide to Excel’s IM Functions

2. Engineering functions – D to IMC

3. How to use the DEGREES function

DELTA function

1. Engineering functions – D to IMC

Dependent drop down lists

1. Create dependent drop down lists containing unique distinct values

DGET function

Dialog boxes

1. How to use DIALOG BOXES

DMAX function

DMIN function

DO LOOP statement

Doughnut chart

DOUNTA function

DPRODUCT function

Drop down lists

1. Advanced Techniques for Conditional Formatting

2. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

3. Populate drop down list with unique distinct values sorted from A to Z

4. Run a Macro from a Drop Down list [VBA]

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

DROP function

1. Calculate machine utilization

2. Filter unique distinct records case sensitive

3. How to create date ranges in Excel

4. How to use the DROP function

5. Merge cell ranges into one list

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

7. Working with classic ciphers in Excel

DSTDEV function

DSTDEVP function

DSUM function

Duplicate records

Duplicate values

1. Extract a list of duplicates from a column

2. Extract duplicates from a multi-column cell range

3. Filter duplicate values based on criteria

DVARP function

EDATE function

1. Excel calendar

2. How to use the EDATE function

EFFECT function

ENCODEURL function

1. How to use the ENCODEURL function

EOMONTH function

1. How to use the EOMONTH function

ERROR.TYPE function

1. How to use the ERROR.TYPE function

Evaluate method

EVEN function

1. How to use the EVEN function

EXACT function

1. 5 easy ways to extract Unique Distinct Values

2. 5 easy ways to VLOOKUP and return multiple values

3. Count unique distinct values

4. How to compare two data sets

5. How to use the EXACT function

6. If cell contains text from list

7. INDEX MATCH – multiple results

8. Working with unique values

Excel Basics

Excel table

EXP function

1. How to use the EXP function

EXPAND function

1. Filter unique distinct records case sensitive

2. How to use the EXPAND function

EXPON.DIST function

1. How to use the EXPON.DIST function

EXPONDIST function

1. Compatibility Functions

Extract

1. Extract specific word based on position in cell value

2. How to extract numbers from a cell value

F.DIST function

1. How to use the F.DIST function

F.DIST.RT

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

F.TEST function

1. How to use the F.TEST function

FACT function

1. How to create permutations

2. How to use the FACT function

FALSE function

1. Advanced Excel Chart Techniques

2. Automate net asset value (NAV) calculation on your stock portfolio

3. Extract a list of duplicates from a column

4. Get date ranges from a schedule

5. How to generate a round-robin tournament

6. How to use the asterisk character

7. How to use VLOOKUP/XLOOKUP with multiple conditions

8. If cell contains text from list

9. INDEX MATCH – multiple results

10. Match two criteria and return multiple records

11. Merge tables based on a condition

12. Plot date ranges in a calendar

13. Populate drop down list with unique distinct values sorted from A to Z

14. Rearrange values using formulas

15. Repeat values across cells

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

17. Unique distinct records sorted based on count or frequency

18. VLOOKUP – Return multiple unique distinct values

19. Working with classic ciphers in Excel

20. Working with Relational Tables in Excel

21. Working with unique values

FDIST function

1. Compatibility Functions

Features

1. 5 easy ways to extract Unique Distinct Values

2. Advanced Techniques for Conditional Formatting

3. Create a dynamic named range

4. Create dependent drop down lists containing unique distinct values

5. Excel solver examples

6. Extract unique distinct values from an Excel Table filtered list

7. How to compare two data sets

8. How to solve simultaneous linear equations in Excel

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

10. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

11. How to use Excel Tables

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

13. How to use the COMBIN function

14. How to use the Scroll Bar

15. How to use the Subtotal tool

16. Identify numbers in sum using Excel solver

17. Lookup with any number of criteria

18. Populate drop down list with unique distinct values sorted from A to Z

19. Prevent duplicate records in a worksheet

20. Run a Macro from a Drop Down list [VBA]

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

22. Working with Excel tables programmatically

Files and folders

1. Copy data from workbooks in folder and subfolders

2. Search all workbooks in a folder

3. Search for a file in folder and subfolders – UDF

4. Working with FILES

Filter emails

FILTER function

1. 5 easy ways to extract Unique Distinct Values

2. 5 easy ways to VLOOKUP and return multiple values

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

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

5. Compare two columns and extract differences

6. Compare two columns in different worksheets

7. Compatibility Functions

8. Count unique distinct records

9. Count unique distinct values

10. Create dependent drop down lists containing unique distinct values

11. Extract a list of duplicates from a column

12. Extract a unique distinct list sorted from A to Z

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

14. Extract dates from overlapping date ranges

15. Extract duplicates from a multi-column cell range

16. Extract records between two dates

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

18. Extract unique distinct values from an Excel Table filtered list

19. Filter duplicate values based on criteria

20. Filter unique distinct records

21. Filter unique distinct records case sensitive

22. Find all sequences of consecutive dates

23. Find missing numbers

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

25. Get date ranges from a schedule

26. How to compare two data sets

27. How to create date ranges in Excel

28. How to extract numbers from a cell value

29. How to list unique distinct values sorted by frequency

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

31. How to use the FILTER function

32. How to use VLOOKUP/XLOOKUP with multiple conditions

33. Identify rows of overlapping records

34. If cell contains text from list

35. INDEX MATCH – multiple results

36. Lookup and return multiple values concatenated into one cell

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

38. Lookup with any number of criteria

39. Match two criteria and return multiple records

40. Merge cell ranges into one list

41. Monthly calendar template

42. Partial match and return multiple adjacent values

43. Partial match for multiple strings – AND logic

44. Search for a sequence of values

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

46. Sort a column alphabetically

47. Split expenses calculator

48. VLOOKUP – Return multiple unique distinct values

49. Wildcard lookups and include or exclude criteria

50. Working with date ranges

51. Working with overlapping date ranges

52. Working with Relational Tables in Excel

53. Working with unique values

Filter records

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

2. Extract records between two dates

3. Match two criteria and return multiple records

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

FILTERXML function

1. A Comprehensive Guide to Splitting Text in Excel

2. How to use the FILTERXML function

3. How to use the LIKE OPERATOR

4. Rearrange values using formulas

Finance

1. Automate net asset value (NAV) calculation on your stock portfolio

2. Compare the performance of your stock portfolio to S&P 500 using Excel

3. Follow stock market trends – Moving Average

4. How to track sector performance in the stock market – Excel template

FIND function

1. Count cells containing text from list

2. Formula for matching a date within a date range

3. How to use the FIND function

4. INDEX MATCH – multiple results

5. Search for a sequence of values

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

7. Working with classic ciphers in Excel

Find numbers in sum

1. Find numbers closest to sum

2. How to do tiered calculations in one formula

3. Identify numbers in sum using Excel solver

Fix Function

FIXED function

1. How to use the FIXED function

FLOOR function

1. Compatibility Functions

FLOOR.MATH function

1. How to use the FLOOR.MATH function

FLOOR.PRECISE function

1. How to use the FLOOR.PRECISE function

FOR NEXT statement

1. Finding the shortest path – A * pathfinding

2. Working with comments – VBA

FORECAST function

1. Compatibility Functions

FORECAST.LINEAR function

1. How to use the FORECAST.LINEAR function

Form Controls

1. Create a Print button – macro

2. How to use the Scroll Bar

3. Working with COMBO BOXES [Form Controls]

4. Working with LIST BOXES (Form Controls)

5. Working with TEXT BOXES [Form Controls]

Formula characters

1. How to use the asterisk character

FORMULATEXT function

1. How to use the FORMULATEXT function

FREQUENCY function

Frequency table

1. How to list unique distinct values sorted by frequency

FTEST function

1. Compatibility Functions

Functions

1. How to copy non contiguous cell ranges

2. Working with COMBO BOXES [Form Controls]

Funnel chart

Fuzzy lookup

1. Fuzzy VLOOKUP

FV function

GAMMA.DIST function

1. How to use the GAMMA.DIST function

GAMMADIST function

1. Compatibility Functions

Gantt

GCD function

1. How to use the GCD function

GDC function

1. How to use the GCD function

GEOMEAN function

1. How to use the GEOMEAN function

GoTo statement

GROUPBY function

1. How to do tiered calculations in one formula

2. How to use the GROUPBY function

GROWTH function

1. How to use the GROWTH function

HARMEAN function

1. How to use the HARMEAN function

HEX2BIN function

1. Engineering functions – D to IMC

HEX2DEC function

1. Engineering functions – D to IMC

2. Working with classic ciphers in Excel

HEX2OCT function

1. Engineering functions – D to IMC

Highlight

1. Highlight a data series in a chart

Highlight Cells Rules

1. Conditional Formatting Basics

Highlight duplicates

Histogram chart

HLOOKUP function

1. How to use the HLOOKUP function

HOUR function

1. How to use the HOUR function

HSTACK function

1. Calculate machine utilization

2. Filter unique distinct records

3. Fuzzy VLOOKUP

4. Get date ranges from a schedule

5. How to create date ranges in Excel

6. How to use the HSTACK function

7. Merge cell ranges into one list

8. Time sheet for work

9. Working with classic ciphers in Excel

HYPERLINK function

1. How to perform a two-dimensional lookup

2. How to use the HYPERLINK function

3. INDEX MATCH – multiple results

Hyperlinks