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

2. Date and Time Functions – A to M

4. Find numbers closest to sum

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

6. How to create date ranges in Excel

7. How to use the ABS function

8. How to use the asterisk character

9. 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. How to quickly find the maximum or minimum value [Formula]

2. How to use the ADDRESS function

### Advanced filter

### AGGREGATE function

1. Convert array formula to a regular formula

2. Count cells containing text from list

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

4. How to use the AGGREGATE function

### AMORLINC function

### AND function

1. Count cells containing text from list

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

3. Extract specific word based on position in cell value

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

6. Formula for matching a date within a date range

7. How to create date ranges in Excel

8. How to do tiered calculations in one formula

9. How to extract numbers from a cell value

10. How to perform a two-dimensional lookup

11. How to replace part of formula in all cells

12. If cell contains text from list

13. INDEX MATCH – multiple results

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

15. Lookup with any number of criteria

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

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

4. Filter unique distinct records case sensitive

6. How to use the BYROW function

7. Rearrange values using formulas

8. 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. 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. Engineering functions – A to C

3. How to use the CHAR function

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

5. Working with classic ciphers in Excel

### Chart basics

1. Excel charts tips and tricks

### Chart elements

### Charts

1. Advanced Excel Chart Techniques

4. Excel charts tips and tricks

5. Highlight a data series in a chart

7. How to add horizontal line to chart

8. How to animate an Excel chart

9. How to create an interactive Excel chart

10. How to create charts in Excel

11. How to improve your Excel Chart

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

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

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

6. Compare two columns in different worksheets

7. Count cells containing text from list

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 duplicates from a multi-column cell range

14. Extract records between two dates

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

16. Filter unique distinct records

17. Filter unique distinct records case sensitive

18. Filter values in common between two cell ranges

19. Fuzzy VLOOKUP

20. Get date ranges from a schedule

21. How to generate a round-robin tournament

22. How to list unique distinct values sorted by frequency

23. How to perform a two-dimensional lookup

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

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

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

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

29. How to use the COLUMN function

31. INDEX MATCH – multiple results

32. Lookup with any number of criteria

33. Match two criteria and return multiple records

34. Merge cell ranges into one list

35. Merge tables based on a condition

36. Partial match for multiple strings – AND logic

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

38. Sort a column alphabetically

39. Split data across multiple sheets – VBA

41. Unique distinct records sorted based on count or frequency

42. VLOOKUP – Return multiple unique distinct values

43. Wildcard lookups and include or exclude criteria

44. Working with COMBO BOXES [Form Controls]

45. Working with Relational Tables in Excel

46. Working with unique values

### COLUMNS function

1. 5 easy ways to VLOOKUP and return multiple values

2. Array Manipulation Functions

3. Count cells containing text from list

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

6. Filter unique distinct records

7. Filter unique distinct records case sensitive

8. How to compare two data sets

9. How to copy non contiguous cell ranges

10. How to create date ranges in Excel

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

12. How to use the COLUMNS function

13. How to use the MAKEARRAY function

14. How to use VLOOKUP/XLOOKUP with multiple conditions

15. Identify rows of overlapping records

16. If cell contains text from list

17. Match two criteria and return multiple records

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

19. Rearrange values using formulas

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

21. Sort a column alphabetically

23. Split data across multiple sheets – VBA

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

25. 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. Extract shared values between two columns

5. Filter values in common between two cell ranges

6. How to highlight differences and common values in lists

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

4. Highlight date ranges overlapping selected record [VBA]

5. Highlight unique values in a filtered Excel table

6. How to highlight differences and common values in lists

7. How to highlight duplicate values

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

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

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

### Count text values

### Count unique distinct records

1. Count unique distinct records

### Count unique distinct values

1. Count unique distinct values

### Count values

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

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. Automate net asset value (NAV) calculation on your stock portfolio

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

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

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

7. Compare two columns and extract differences

8. Compare two columns in different worksheets

10. Convert array formula to a regular formula

11. Count unique distinct records

12. Count unique distinct values

13. Create dependent drop down lists containing unique distinct values

15. Date and Time Functions – N to Z

17. Extract a list of duplicates from a column

18. Extract a list of duplicates from three columns combined

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

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

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

22. Extract duplicates from a multi-column cell range

23. Extract shared values between two columns

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

25. Extract unique distinct values if the value contains the given string

26. Extract unique distinct values in an Excel Table filtered list

27. Extract unique distinct values sorted based on sum of adjacent values

28. Filter duplicate values based on criteria

29. Filter unique distinct records

30. Filter values in common between two cell ranges

31. Find all sequences of consecutive dates

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

35. Get date ranges from a schedule

36. Highlight unique values in a filtered Excel table

37. How to compare two data sets

38. How to generate a round-robin tournament

39. How to highlight duplicate values

40. How to list unique distinct values sorted by frequency

41. How to perform a two-dimensional lookup

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

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

44. How to use the COUNTIF function

45. How to use VLOOKUP/XLOOKUP with multiple conditions

46. If cell contains text from list

47. INDEX MATCH – multiple results

48. Lookup with any number of criteria

49. Match two criteria and return multiple records

50. Merge cell ranges into one list

51. Partial match and return multiple adjacent values

52. Partial match for multiple strings – AND logic

53. Plot date ranges in a calendar

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

55. Repeat values across cells

56. Rotating unique groups with no repeat

57. Sort a column alphabetically

58. Sort rows based on frequency and criteria

59. Sort text cells alphabetically from two columns

61. SUMPRODUCT – multiple criteria

62. Team Generator

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

65. VLOOKUP – Return multiple unique distinct values

66. Working with COMBO BOXES [Form Controls]

67. 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 in an Excel Table filtered list

9. Filter unique distinct records

11. Get date ranges from a schedule

12. How to compare two data sets

13. How to create date ranges in Excel

14. How to highlight differences and common values in lists

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

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

18. How to use the COUNTIFS function

19. How to use VLOOKUP/XLOOKUP with multiple conditions

20. Identify rows of overlapping records

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

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

23. Match two criteria and return multiple records

24. Merge tables based on a condition

25. Prevent duplicate records in a worksheet

26. Search for a sequence of cells based on wildcard search

27. Search for a sequence of values

28. Sort rows based on frequency and criteria

29. Split data across multiple sheets – VBA

30. Unique distinct records sorted based on count or frequency

31. Working with Conditional Formatting formulas

32. Working with overlapping date ranges

33. Working with Relational Tables in Excel

### COVAR function

### COVARIANCE.P function

1. How to use the COVARIANCE.P function

### COVARIANCE.S function

1. How to use the COVARIANCE.S function

### CRITBINOM function

### CSC function

1. How to use the CSC function

### CUMIPMT function

### CUMPRINC function

### Custom charts

1. Advanced Excel Chart Techniques

### Data labels

### Data validation

2. Prevent duplicate records in a worksheet

### Date and Time

### DATE function

1. Count unique distinct values

2. Create a quartely date range

3. Date and Time Functions – A to M

4. Date and Time Functions – N to Z

6. Filter unique distinct records

7. Get date ranges from a schedule

8. Highlight events in a yearly calendar

9. How to create date ranges in Excel

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

11. How to use the DATE function

13. Plot date ranges in a calendar

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

15. Split data across multiple sheets – VBA

17. Yet another Excel Calendar

### DATEDIF function

1. Date and Time Functions – A to M

2. 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. Highlight date ranges overlapping selected record [VBA]

8. How to create date ranges in Excel

9. Identify rows of overlapping records

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

### DATEVALUE function

1. Date and Time Functions – A to M

2. Formula for matching a date within a date range

3. How to use the DATEVALUE function

### DAVERAGE function

### DAY function

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

2. Date and Time Functions – A to M

3. Date and Time Functions – N to Z

4. Get date ranges from a schedule

5. How to calculate and plot pivots on an Excel chart

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

7. How to use the DAY function

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

### DAYS function

1. Date and Time Functions – A to M

2. How to use the DAYS function

### DB function

### DCOUNT function

### DDB function

### DEC2BIN function

1. Engineering functions – A to C

2. Engineering functions – D to IMC

3. 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. Engineering functions – D to IMC

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

### DMAX function

### DMIN function

### DO LOOP statement

### Doughnut chart

### DOUNTA function

### DPRODUCT function

### Drop down lists

1. Advanced Techniques for Conditional Formatting

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

2. Calculate machine utilization

3. Filter strings containing a given substring in a cell range

4. Filter unique distinct records case sensitive

5. How to create date ranges in Excel

6. Merge cell ranges into one list

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 a list of duplicates from three columns combined

3. Extract duplicates from a multi-column cell range

4. Filter duplicate values based on criteria

### DVARP function

### EDATE function

1. Date and Time Functions – A to M

3. How to use the EDATE function

### EFFECT function

### ENCODEURL function

1. How to use the ENCODEURL function

### EOMONTH function

1. Date and Time Functions – A to M

2. Date and Time Functions – N to Z

3. 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. Extract shared values between two columns

5. How to extract a case sensitive unique list from a column

6. How to use the EXACT function

7. If cell contains text from list

8. INDEX MATCH – multiple results

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

### Excel Basics

1. How to replace part of formula in all cells

2. How to select and delete blank cells

### Excel table

### EXP function

1. How to use the EXP function

### EXPAND function

1. Array Manipulation Functions

2. Filter unique distinct records case sensitive

### EXPON.DIST function

1. How to use the EXPON.DIST function

### EXPONDIST function

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

2. How to use the FACT function

### FALSE function

1. Advanced Excel Chart Techniques

2. Array Manipulation Functions

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

4. Extract a list of duplicates from a column

5. Get date ranges from a schedule

6. How to generate a round-robin tournament

7. How to use the asterisk character

8. How to use VLOOKUP/XLOOKUP with multiple conditions

9. If cell contains text from list

10. INDEX MATCH – multiple results

11. Match two criteria and return multiple records

12. Merge tables based on a condition

13. Plot date ranges in a calendar

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

15. Rearrange values using formulas

16. Repeat values across cells

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

18. SUMPRODUCT and IF function

19. Unique distinct records sorted based on count or frequency

20. VLOOKUP – Return multiple unique distinct values

21. Working with classic ciphers in Excel

22. Working with Relational Tables in Excel

23. Working with unique values

### FDIST function

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

6. Extract unique distinct values in 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

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

13. How to use the COMBIN function

15. How to use the Subtotal tool

16. Identify numbers in sum using Excel solver

17. Lookup with any number of criteria

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

20. Prevent duplicate records in a worksheet

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

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

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

### Filter emails

1. Filter strings containing a given substring in a cell range

### FILTER function

1. 5 easy ways to extract Unique Distinct Values

2. 5 easy ways to VLOOKUP and return multiple values

3. Array Manipulation Functions

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

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

6. Compare two columns and extract differences

7. Compare two columns in different worksheets

9. Count unique distinct records

10. Count unique distinct values

11. Create dependent drop down lists containing unique distinct values

12. Date and Time Functions – A to M

13. Date and Time Functions – N to Z

14. Engineering functions – A to C

15. Extract a list of duplicates from a column

16. Extract a list of duplicates from three columns combined

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

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

19. Extract dates from overlapping date ranges

20. Extract duplicates from a multi-column cell range

21. Extract records between two dates

22. Extract shared values between two columns

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

24. Extract unique distinct values in an Excel Table filtered list

25. Extract unique distinct values sorted based on sum of adjacent values

26. Filter duplicate values based on criteria

27. Filter strings containing a given substring in a cell range

28. Filter unique distinct records

29. Filter unique distinct records case sensitive

30. Filter values in common between two cell ranges

31. Find all sequences of consecutive dates

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

34. Get date ranges from a schedule

35. How to compare two data sets

36. How to create date ranges in Excel

37. How to extract a case sensitive unique list from a column

38. How to extract numbers from a cell value

39. How to list unique distinct values sorted by frequency

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

41. How to use the FILTER function

42. How to use VLOOKUP/XLOOKUP with multiple conditions

43. Identify rows of overlapping records

44. If cell contains text from list

45. INDEX MATCH – multiple results

46. Lookup and return multiple values concatenated into one cell

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

48. Lookup with any number of criteria

49. Match two criteria and return multiple records

50. Merge cell ranges into one list

52. Partial match and return multiple adjacent values

53. Partial match for multiple strings – AND logic

54. Search for a sequence of cells based on wildcard search

55. Search for a sequence of values

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

57. Sort a column alphabetically

59. VLOOKUP – Return multiple unique distinct values

60. Wildcard lookups and include or exclude criteria

62. Working with overlapping date ranges

63. Working with Relational Tables in Excel

64. 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 calculate and plot pivots on an Excel chart

5. 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 cells based on wildcard search

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

### 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. Create links to all sheets in a workbook programmatically

2. Finding the shortest path – A * pathfinding

3. Working with comments – VBA

### FORECAST function

### FORECAST.LINEAR function

1. How to use the FORECAST.LINEAR function

### Form Controls

1. Create a Print button – macro

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

2. Sort rows based on frequency and criteria

### FTEST function

### Functions

1. How to copy non contiguous cell ranges

2. Working with COMBO BOXES [Form Controls]

### Funnel chart

### Fuzzy lookup

### FV function

### GAMMA.DIST function

1. How to use the GAMMA.DIST function

### GAMMADIST function

### 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 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. Date and Time Functions – A to M

2. Date and Time Functions – N to Z

3. How to use the HOUR function

### HSTACK function

1. Array Manipulation Functions

2. Calculate machine utilization

3. Date and Time Functions – N to Z

4. Filter unique distinct records

6. Get date ranges from a schedule

7. How to create date ranges in Excel

8. Merge cell ranges into one list

9. Sort rows based on frequency and criteria

10. Working with classic ciphers in Excel

### HYPERLINK function

1. How to perform a two-dimensional lookup

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

3. How to use the HYPERLINK function

4. INDEX MATCH – multiple results

### Hyperlinks

1. Create links to all sheets in a workbook programmatically

2. List all hyperlinks in worksheet programmatically

### HYPGEOM.DIST function

1. How to use the HYPGEOM.DIST function

### IF

### IF function

1. 5 easy ways to extract Unique Distinct Values

2. 5 easy ways to VLOOKUP and return multiple values

3. A Comprehensive Guide to Splitting Text in Excel

4. Array Manipulation Functions

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

6. Calculate machine utilization

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

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

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

10. Compare two columns and extract differences

11. Compare two columns in different worksheets

12. Convert array formula to a regular formula

13. Count cells containing text from list

14. Count unique distinct records

15. Count unique distinct values

16. Create a quartely date range

17. Create dependent drop down lists containing unique distinct values

19. Date and Time Functions – A to M

20. Date and Time Functions – N to Z

22. Excel calendar

23. Extract a list of duplicates from a column

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

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

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

27. Extract dates from overlapping date ranges

28. Extract duplicates from a multi-column cell range

29. Extract records between two dates

30. Extract shared values between two columns

31. Extract specific word based on position in cell value

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

33. Extract unique distinct values in an Excel Table filtered list

34. Extract unique distinct values sorted based on sum of adjacent values

35. Filter duplicate values based on criteria

36. Filter strings containing a given substring in a cell range

37. Filter unique distinct records

38. Filter values in common between two cell ranges

39. Find all sequences of consecutive dates

40. Find and return the highest number and corresponding date based on a condition

43. Find numbers closest to sum

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

45. Follow stock market trends – Moving Average

46. Formula for matching a date within a date range

47. Fuzzy VLOOKUP

48. Get date ranges from a schedule

49. Highlight unique values in a filtered Excel table

50. How to calculate and plot pivots on an Excel chart

51. How to compare two data sets

52. How to create date ranges in Excel

53. How to extract a case sensitive unique list from a column

54. How to extract numbers from a cell value

55. How to generate a round-robin tournament

56. How to highlight duplicate values

57. How to list unique distinct values sorted by frequency

58. How to perform a two-dimensional lookup

59. How to replace part of formula in all cells

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

61. How to select and delete blank cells

62. How to solve simultaneous linear equations in Excel

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

65. How to use the IF function

66. How to use VLOOKUP/XLOOKUP with multiple conditions

67. Identify rows of overlapping records

68. If cell contains text from list

69.