Excel formula examples
This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.
#, hashtag
2D, two-dimensional, two-way
3D, multiple worksheets, multiple sheets
365
Address
Advanced Filter
Alternative
And logic
Autofilter
Average
Blank, space
Calendar
Case
Character
Column
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
Conditional formatting, cf, highlight
Count
Countif
Countifs
Criteria, multiple conditions, conditions
Date
Day
Decimal
Delete, remove
Digit
Duplicates
Dynamic
Empty
Equal, condition, criterion
Error, problem
Extend, expand
Extract, list, filter, get
Finance, stock, expense
First, last
Group, category
Hour
Hyperlink, link
If
Ifs
Ignore, avoid, prevent, exclude, hide
Image, picture
Index
Index match, index and match
Intersection
Lambda
Large, larger, highest, greater
Letter
Lookup, find, identify
Match
Max
Min
Minute
Month
Multiply, multiplication, product
Negative, minus, subtract
New line
Not equal
Or logic
Overlapping
Partial, wildcard, contain
Permut
Random
Rearrange, distribute
Record, row
Recursive
Reference
Relation, related
Reverse
Right, left
Running total
Schedule
Second
Sequence, consecutive
Shared, common, exist, occur
Small, smaller, less
Solver
Sort, A to Z, z to a, ascending, descending
Split
String
Substitute, replace
Subtotal
Sum, total
Sumif
Sumifs
Sumproduct
Tab
Table, excel table
Team, tournament
Text
Time
Unique
Vlookup
Week
Year
Categories
100% stacked column chart
ABS function
1. Calculate the number of weeks between given dates
2. Count cells between specified values
4. Date and Time Functions – A to M
5. Financial functions – PMT to RATE
7. Find numbers closest to sum
8. How to create date ranges in Excel
9. How to use the ABS function
10. How to use the asterisk character
11. Identify numbers in sum using Excel solver
ACCRINT function
1. Financial functions – A to PD
ACCRINTM function
1. Financial functions – A to PD
ACOS function
1. How to use the ACOS function
ACOSH function
1. How to use the ACOSH function
ACOT function
1. How to use the ACOT function
ACOTH function
1. How to use the ACOTH function
Add-in
1. How to save custom functions and macros to an Add-In
3. Split data across multiple sheets – VBA
4. Vlookup across multiple sheets
ADDRESS function
1. Easily select data using hyperlinks
2. How to quickly find the maximum or minimum value [Formula]
3. How to use the ADDRESS function
Advanced filter
AGGREGATE function
1. Convert array formula to a regular formula
2. Count cells between specified values
3. Extract the most repeated adjacent values in a column
4. Filter unique distinct values, sorted and blanks removed from a range
5. How to ignore zeros using the SMALL function
6. How to use the AGGREGATE function
AMORDEGRC function
1. How to use the AMORDEGRC function
AMORLINC function
1. Financial functions – A to PD
AND function
2. Highlight lookups in relational tables
3. How to use the AND function
4. IF function with AND function – multiple conditions
5. Search for a text string in a data set and return multiple records
Animate
1. How to animate an Excel chart
Area chart
AREAS function
1. How to use the AREAS function
ARRAY function
Arrays
1. A beginners guide to Excel array formulas
2. Working with ARRAY VARIABLES (VBA)
ARRAYTOTEXT Function
1. How to use the ARRAYTOTEXT function
ASC function
1. How to use the ASC function
ASIN function
1. How to use the ASIN function
ASINH function
1. How to use the ASINH function
ATAN function
1. Engineering functions – D to IMC
2. How to use the ATAN function
ATAN2 function
1. How to use the ATAN2 function
ATANH function
1. How to use the ATANH function
AVEDEV function
1. How to use the AVEDEV function
AVERAGE function
1. Add buy and sell points to a stock chart
5. Follow stock market trends – Moving Average
7. How to use the AVERAGE function
8. Plot buy and sell points in an Excel Chart based on two moving averages
AVERAGEA function
1. How to use the AVERAGEA function
AVERAGEIF function
3. How to use the AVERAGEIF function
AVERAGEIFS function
1. How to use the AVERAGEIFS function
Bar chart
BASE function
1. Engineering functions – D to IMC
2. How to use the BASE function
3. List permutations with repetition and how many to choose from
Basic formulas
1. Calculate the number of weeks between given dates
2. Count a specific text string in a cell
3. Count cells containing text from list
6. Count specific multiple text strings in a given cell range
8. Extract numbers from a column
9. Extract specific word based on position in cell value
11. Find last matching value in an unsorted list
12. Find last value in a column
13. Find the most recent date that meets a particular condition
14. Find the smallest number in a list that is larger than a given number
15. Formula for matching a date within a date range
18. How to calculate overlapping time ranges
19. How to create date ranges in Excel
20. How to create running totals
21. How to do tiered calculations in one formula
22. How to extract numbers from a cell value
23. How to ignore zeros using the SMALL function
24. How to perform a two-dimensional lookup
25. How to remove numbers from a cell value
26. How to replace part of formula in all cells
27. How to use nested IF functions
28. If cell contains multiple values
30. If cell contains text from list
31. If cell equals value from list
32. IF function with AND function – multiple conditions
33. INDEX MATCH – Case sensitive
34. INDEX MATCH – multiple results
35. INDEX MATCH with multiple criteria
36. Lookup multiple values across columns and return a single value
37. Lookup with any number of criteria
38. Match two columns and return another value on the same row
39. Running totals based on criteria
40. SMALL function – INDEX MATCH
41. SMALL function – multiple conditions
43. SMALL function ignore duplicates
44. Sum numerical ranges between two numbers
46. Use IF + COUNTIF to evaluate multiple conditions
BETA.DIST function
1. How to use the BETA.DIST function
BETA.INV function
1. How to use the BETA.INV function
BETADIST function
BETAINV function
BIN2DEC function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
BIN2HEX function
1. Engineering functions – A to C
BIN2OCT function
1. Engineering functions – A to C
BINOM.DIST function
2. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. Engineering functions – A to C
2. How to use the BITAND function
BITLSHIFT function
1. Engineering functions – A to C
2. How to use the BITLSHIFT function
BITOR function
1. Engineering functions – A to C
BITRSHIFT function
1. Engineering functions – A to C
BITXOR function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. Filter unique distinct records case sensitive
3. How to use the BYROW function
5. Search for a text string in a data set and return multiple records
6. Vlookup a cell range and return multiple values
Calendar
2. Create a drop down calendar
4. Highlight events in a yearly calendar
7. Plot date ranges in a calendar
Candlestick chart
Case sensitive
1. Count unique distinct values
2. INDEX MATCH – Case sensitive
CEILING function
1. How to use the CEILING function
CELL function
1. Find last value in a column
2. How to use the CELL function
CF-basic-formulas
1. Working with Conditional Formatting formulas
CF-built-in
CF-compare
1. How to highlight differences and common values in lists
CF-dates
1. Advanced Date Highlighting Techniques in Excel
2. Highlight date ranges overlapping selected record [VBA]
CF-duplicates
1. Highlight duplicates in a filtered Excel Table
2. How to highlight duplicate values
CF-min-max
CF-misc
1. Advanced Techniques for Conditional Formatting
CF-search
CF-unique-distinct
1. Highlight unique values in a filtered Excel table
CHAR function
1. Easily select data using hyperlinks
2. Engineering functions – A to C
3. How to create random numbers, text strings, dates and time values
4. How to decode URL-encoded strings
5. How to extract email addresses from an Excel sheet
6. How to generate random numbers and text
7. How to use the CHAR function
8. Navigate to first empty cell using a hyperlink formula
9. Populate cells dynamically in a weekly schedule
10. Working with classic ciphers in Excel
Chart basics
1. Excel charts tips and tricks
Chart elements
Charts
1. Add pictures to a chart axis
2. Advanced Excel Chart Techniques
3. Change chart axis range programmatically
4. Color chart columns based on cell color
5. Compare data in an Excel chart using drop down lists
8. Excel charts tips and tricks
10. Highlight a data series in a chart
11. Highlight group of values in an x y scatter chart programmatically
12. Hover with mouse cursor to change stock in a candlestick chart
14. How to add horizontal line to chart
15. How to animate an Excel chart
16. How to build an interactive map in Excel
17. How to color chart bars based on their values
18. How to create an interactive Excel chart [VBA]
19. How to create charts in Excel
21. How to improve your Excel Chart
22. How to position month and year between chart tick marks
23. How to use mouse hover on a worksheet [VBA]
24. Use drop down lists and named ranges to filter chart values
Check-boxes
1. Add checkboxes and copy values – VBA
2. Multi-level To-Do list template
3. Open Excel files in a folder [VBA]
4. Toggle a macro on/off using a button
CHIDIST function
CHIINV function
CHISQ.DIST function
2. How to use the CHISQ.DIST function
CHISQ.DIST.RT function
1. How to use the CHISQ.DIST.RT function
CHISQ.INV function
1. How to use the CHISQ.INV function
CHISQ.INV.RT function
1. How to use the CHISQ.INV.RT function
CHISQ.TEST function
1. How to use the CHISQ.TEST function
CHITEST function
CHOOSE function
1. How to group items by quarter using formulas
2. How to perform a two-dimensional lookup
3. How to use the CHOOSE function
CHOOSECOLS function
1. Array Manipulation Functions
CHOOSEROWS function
1. Array Manipulation Functions
CLEAN function
1. How to use the CLEAN function
CODE function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. How to use the CODE function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Column
Column chart
1. Color chart columns based on cell color
2. How to add horizontal line to chart
3. How to animate an Excel chart
4. How to create charts in Excel
COLUMN function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Apply dependent combo box selections to a filter
4. Array Manipulation Functions
7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
8. Compare tables: Filter records occurring only in one table
9. Count identical values if they are on the same row
10. Count unique distinct values
11. Create a quartely date range
12. Create numbers based on numerical ranges
14. Excel calendar
15. Extract a list of duplicates from a column
16. Extract a unique distinct list and sum amounts based on a condition
17. Extract duplicates from a multi-column cell range
18. Extract records between two dates
19. Filter unique distinct records
20. Filter unique distinct records case sensitive
21. Filter unique distinct values, sorted and blanks removed from a range
22. Filter unique values from a cell range
23. Filter values in common between two cell ranges
24. Filter values occurring in range 1 but not in range 2
25. Fuzzy VLOOKUP
26. Get date ranges from a schedule
27. Group rows based on a condition
28. How to extract email addresses from an Excel sheet
29. How to group items by quarter using formulas
30. How to list unique distinct values sorted by frequency
31. How to perform a two-dimensional lookup
32. How to quickly find the maximum or minimum value [Formula]
33. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
35. How to use the COLUMN function
37. INDEX MATCH with multiple criteria
38. List all unique distinct rows in a given month
39. Lookup with any number of criteria
40. Match two criteria and return multiple records
41. Merge tables based on a condition
42. Partial match for multiple strings – AND logic
43. Rearrange values in a cell range to a single column
44. Remove common records between two data sets
45. Search related table based on a date and date range
46. Sort based on frequency row-wise
47. Sort items by adjacent number in every other value
48. Sort values by corresponding text arranged in a column
49. True round-robin tournament
50. Unique distinct records sorted based on count or frequency
51. VLOOKUP – Return multiple unique distinct values
52. Vlookup a cell range and return multiple values
53. Wildcard lookups and include or exclude criteria
COLUMNS function
1. 5 easy ways to VLOOKUP and return multiple values
2. Array Manipulation Functions
3. Count identical values if they are on the same row
4. Create a drop down calendar
5. Distribute values across numerical ranges
7. Extract all rows from a range that meet criteria in one column
8. Filter unique distinct records
9. Filter unique distinct records case sensitive
10. How to color chart bars based on their values
11. How to compare two data sets
12. How to copy non contiguous cell ranges
13. How to create date ranges in Excel
14. How to extract rows containing digits [Formula]
15. How to use the COLUMNS function
16. How to use the MAKEARRAY function
17. Identify rows of overlapping records
18. If cell contains text from list
19. Match two criteria and return multiple records
20. Partial match with two conditions and return multiple results
21. Perform multiple partial matches and return records – AND logic
22. Rearrange values in a cell range to a single column
23. Rearrange values using formulas
24. Search each column for a string each and return multiple records – OR logic
25. Search for a text string in a data set and return multiple records
26. Search related table based on a date and date range
28. Sort items by adjacent number in every other value
29. Split values equally into groups
30. Use a drop down list to search and return multiple values
31. VLOOKUP/XLOOKUP of three columns to pull a single record
COMBIN function
1. How to use the COMBIN function
2. True round-robin tournament
COMBINA function
1. How to use the COMBINA function
Combination chart
Combinations
1. Identify numbers in sum using Excel solver
Combine Merge
1. Group rows based on a condition
2. Merge cell ranges into one list
4. Merge tables based on a condition
5. Merge two columns with possible blank cells
Combobox
1. Apply dependent combo box selections to a filter
2. Working with COMBO BOXES [Form Controls]
Compare
1. Compare tables: Filter records occurring only in one table
2. Compare two columns and extract differences
3. Compare two columns in different worksheets
4. Extract shared values between two columns
5. Filter values in common between two cell ranges
6. Filter values occurring in range 1 but not in range 2
7. Filter values that exists in all three columns
8. How to highlight differences and common values in lists
9. What values are missing in List 1 that exists i List 2?
COMPLEX function
1. Engineering functions – A to C
2. Engineering functions – IMD to Z
Complex numbers
CONCAT function
1. How to extract numbers from a cell value
2. How to use the CONCAT function
Concatenate
2. Concatenate unique distinct values
3. Lookup and return multiple values concatenated into one cell
4. Use a drop down list to filter and concatenate unique distinct values
CONCATENATE function
2. How to use the CONCATENATE function
Conditional formatting
1. Advanced Date Highlighting Techniques in Excel
2. Advanced Techniques for Conditional Formatting
3. Count Conditionally Formatted cells
4. Highlight date ranges overlapping selected record [VBA]
5. Highlight duplicates in a filtered Excel Table
6. Highlight unique values in a filtered Excel table
7. How to highlight differences and common values in lists
8. How to highlight duplicate values
9. Working with Conditional Formatting formulas
CONFIDENCE
CONFIDENCE.NORM
1. How to use the CONFIDENCE.NORM function
CONFIDENCE.T function
1. How to use the CONFIDENCE.T function
CONVERT function
1. Engineering functions – A to C
CORREL function
1. How to use the CORREL function
COS function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
3. How to use the COS function
COSH function
1. How to use the COSH function
COT function
1. How to use the COT function
COTH function
1. How to use the COTH function
Count
1. Count a specific text string in a cell
2. Count cells containing text from list
5. Count specific multiple text strings in a given cell range
6. How to use the COUNTIF function to count not blank cells
COUNT function
1. Count unique distinct values
2. Create a dynamic named range
3. Create dependent drop down lists containing unique distinct values
4. Extract specific word based on position in cell value
6. How to create date ranges in Excel
7. How to use the COUNT function
8. If cell contains multiple values
9. Search for a text string in a data set and return multiple records
Count text values
1. How to count the number of values separated by a delimiter
Count unique distinct records
1. Count unique distinct records
Count unique distinct values
1. Count unique distinct values
2. Count unique distinct values based on a condition
3. Count unique distinct values that meet multiple criteria
Count values
1. Count cells based on background color
2. Count cells between specified values
3. Count cells containing text from list
4. Count Conditionally Formatted cells
5. Count groups of repeated values per row
6. Count identical values if they are on the same row
7. Count overlapping days across multiple date ranges
8. Count overlapping days in multiple date ranges
9. Count overlapping days in multiple date ranges, part 2
10. Count unique distinct values
11. Count unique distinct values based on a condition
12. Count unique distinct values in a filtered Excel defined Table
13. Count unique distinct values that meet multiple criteria
14. How to count repeating values
15. How to count the number of values separated by a delimiter
16. How to sum overlapping time
17. Most frequent value between two dates
COUNTA function
1. Apply drop-down lists dynamically
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
7. Create dependent drop down lists containing unique distinct values
9. Filter values that exists in all three columns
10. How to build a Team Generator – different number of people per team
11. How to create a dynamic pivot table and refresh automatically
12. How to use the COUNTA function
13. How to use the COUNTIF function to count not blank cells
14. List permutations with repetition and how many to choose from
15. Lookup with any number of criteria
16. Match two criteria and return multiple records
17. Use drop down lists and named ranges to filter chart values
18. Wildcard lookups and include or exclude criteria
COUNTBLANK function
1. How to use the COUNTBLANK function
COUNTIF
1. How to use the COUNTIF function to count not blank cells
COUNTIF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Apply dependent combo box selections to a filter
4. Automate net asset value (NAV) calculation on your stock portfolio
6. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
7. Compare tables: Filter records occurring only in one table
8. Compare the performance of your stock portfolio to S&P 500 using Excel
9. Compare two columns and extract differences
10. Compare two columns in different worksheets
12. Convert array formula to a regular formula
13. Count unique distinct values
14. Count unique distinct values based on a condition
15. Count unique distinct values in a filtered Excel defined Table
16. Count unique distinct values that meet multiple criteria
18. Create dependent drop down lists containing unique distinct values
20. Create unique distinct list sorted based on text length
21. Date and Time Functions – N to Z
22. Dependent drop-down lists in multiple rows
23. Distribute values across numerical ranges
25. Extract a list of alphabetically sorted duplicates based on a condition
26. Extract a list of duplicates from a column
27. Extract a list of duplicates from three columns combined
28. Extract a unique distinct list and ignore blanks
29. Extract a unique distinct list and sum amounts based on a condition
30. Extract a unique distinct list from three columns
31. Extract a unique distinct list from two columns
32. Extract a unique distinct list sorted from A to Z
33. Extract a unique distinct list sorted from A to Z ignore blanks
34. Extract all rows from a range that meet criteria in one column
35. Extract duplicate values with exceptions
36. Extract duplicates from a multi-column cell range
37. Extract shared values between two columns
38. Extract unique distinct values A to Z from a range and ignore blanks
39. Extract unique distinct values based on a filtered Excel defined Table
40. Extract unique distinct values from a multi-column cell range
41. Extract unique distinct values if the value contains the given string
42. Extract unique distinct values in a filtered list
43. Extract unique distinct values sorted based on sum of adjacent values
44. Extract unique distinct values sorted from A to Z
45. Filter duplicate values based on criteria
46. Filter unique distinct records
47. Filter unique distinct values based on a date range
48. Filter unique distinct values, sorted and blanks removed from a range
49. Filter unique values from a cell range
50. Filter unique values sorted from A to Z
51. Filter values in common between two cell ranges
52. Filter values occurring in range 1 but not in range 2
53. Filter values that exists in all three columns
54. Find all sequences of consecutive dates
56. Find min and max unique and duplicate numerical values
58. Find the most recent date that meets a particular condition
59. Get date ranges from a schedule
61. Group rows based on a condition
62. Highlight duplicates in a filtered Excel Table
63. Highlight unique values in a filtered Excel table
64. How to automatically add new items to a drop down list
65. How to build a Team Generator – different number of people per team
66. How to highlight duplicate values
67. How to list unique distinct values sorted by frequency
68. How to perform a two-dimensional lookup
69. How to rank text uniquely without duplicates
70. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
71. How to use the COUNTIF function
72. How to use the COUNTIF function to count not blank cells
73. How to use VLOOKUP/XLOOKUP with multiple conditions
74. If cell contains multiple values
76. If cell contains text from list
77. If cell equals value from list
78. INDEX MATCH – multiple results
79. Lookup with any number of criteria
80. Match two criteria and return multiple records
81. Most frequent value between two dates
82. Partial match and return multiple adjacent values
83. Partial match for multiple strings – AND logic
84. Plot date ranges in a calendar
85. Populate drop down list with unique distinct values sorted from A to Z
86. Repeat values across cells
87. Rotating unique groups with no repeat
88. SMALL function – multiple conditions
90. Sort a column alphabetically
91. Sort a range from A to Z [Array formula]
92. Sort based on frequency row-wise
93. Sort column based on frequency
94. Sort rows based on frequency and criteria
95. Sort text cells alphabetically from two columns
96. Sort values by corresponding text arranged in a column
99. SUMPRODUCT – multiple criteria
100. Team Generator
101. Time sheet for work
102. True round-robin tournament
103. Use a drop down list to filter and concatenate unique distinct values
104. Use IF + COUNTIF to evaluate multiple conditions
105. Use VLOOKUP and return multiple values sorted from A to Z
106. VLOOKUP – Return multiple unique distinct values
107. Vlookup a cell range and return multiple values
108. Vlookup with multiple matches returns a different value
109. What values are missing in List 1 that exists i List 2?
110. Working with unique values
COUNTIFS function
1. Assign records unique random text strings
3. Calculate machine utilization
4. Compare tables: Filter records occurring only in one table
5. Convert date ranges into dates
6. Count cells containing text from list
7. Count unique distinct values based on a condition
8. Create numbers based on numerical ranges
9. Extract a list of alphabetically sorted duplicates based on a condition
10. Extract a list of duplicates from a column
11. Extract dates from overlapping date ranges
12. Extract unique distinct values from a relational table
13. Extract unique distinct values in a filtered list
14. Filter duplicates within same date, week or month
15. Filter overlapping date ranges
16. Filter unique distinct records
18. Find empty dates in a set of date ranges
19. How to compare two data sets
20. How to group items by quarter using formulas
21. How to highlight differences and common values in lists
22. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
23. How to use the COUNTIFS function
24. IF function with AND function – multiple conditions
25. Label groups of duplicate records
26. List dates outside specified date ranges
27. Lookup multiple values across columns and return a single value
28. Match two columns and return another value on the same row
29. Match two criteria and return multiple records
30. Merge tables based on a condition
31. Prevent duplicate records in a worksheet
32. Remove common records between two data sets
33. Search for a sequence of cells based on wildcard search
34. Search for a sequence of values
35. SMALL function – multiple conditions
36. Sort rows based on frequency and criteria
37. Unique distinct records sorted based on count or frequency
38. VLOOKUP/XLOOKUP of three columns to pull a single record
39. Watch schedule that populates vacation time
40. Working with Conditional Formatting formulas
41. Working with three relational tables
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
1. Financial functions – A to PD
CUMPRINC function
1. Financial functions – A to PD
Custom charts
1. Advanced Excel Chart Techniques
Data labels
Data validation
1. Apply drop-down lists dynamically
2. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
3. Prevent duplicate records in a worksheet
4. Prevent overlapping date and time ranges using data validation
Date and Time
1. Calculate time between time zones
DATE function
2. Count unique distinct values
3. Count unique distinct values that meet multiple criteria
4. Create a drop down calendar
5. Create a quartely date range
6. Create date ranges that stay within month
7. Date and Time Functions – A to M
8. Date and Time Functions – N to Z
10. Financial functions – A to PD
11. Get date ranges from a schedule
12. Highlight events in a yearly calendar
13. How to create date ranges in Excel
14. How to group items by quarter using formulas
15. How to track sector performance in the stock market – Excel template
16. Identify overlapping date ranges
17. List all unique distinct rows in a given month
19. Plot date ranges in a calendar
20. Watch schedule that populates vacation time
22. Yet another Excel Calendar
DATEDIF function
1. Date and Time Functions – A to M
Dates
1. Calculate machine utilization
2. Convert date ranges into dates
3. Count overlapping days across multiple date ranges
4. Count overlapping days in multiple date ranges
5. Create date ranges that stay within month
6. Extract dates from overlapping date ranges
7. Filter duplicates within same date, week or month
8. Filter overlapping date ranges
9. Filter unique distinct values based on a date range
10. Find all sequences of consecutive dates
11. Find earliest and latest overlapping dates in a set of date ranges based on a condition
12. Find empty dates in a set of date ranges
13. Find the most recent date that meets a particular condition
14. Formula for matching a date within a date range
15. Get date ranges from a schedule
16. Highlight date ranges overlapping selected record [VBA]
17. How to calculate overlapping time ranges
18. How to create date ranges in Excel
19. How to sum overlapping time
20. Identify overlapping date ranges
21. Identify rows of overlapping records
22. List all unique distinct rows in a given month
23. List dates outside specified date ranges
25. Most frequent value between two dates
26. Prevent overlapping date and time ranges using data validation
27. Sum numerical ranges between two numbers
28. Units contained in a range that overlap another range
30. Working with overlapping date ranges
Dates
1. Calculate machine utilization
2. Convert date ranges into dates
3. Create date ranges that stay within month
4. Extract dates from overlapping date ranges
5. Filter duplicates within same date, week or month
6. Filter unique distinct values based on a date range
7. Find all sequences of consecutive dates
8. Find empty dates in a set of date ranges
9. Find the most recent date that meets a particular condition
10. Formula for matching a date within a date range
11. Get date ranges from a schedule
12. How to calculate overlapping time ranges
13. How to create date ranges in Excel
14. List all unique distinct rows in a given month
16. Most frequent value between two dates
DATEVALUE function
1. Date and Time Functions – A to M
2. Formula for matching a date within a date range
DAVERAGE function
DAY function
1. Automate net asset value (NAV) calculation on your stock portfolio
4. Change chart axis range programmatically
5. Create a drop down calendar
6. Date and Time Functions – A to M
7. Date and Time Functions – N to Z
8. Get date ranges from a schedule
9. How to calculate and plot pivots on an Excel chart
10. How to track sector performance in the stock market – Excel template
DAYS function
1. Date and Time Functions – A to M
DB function
1. Financial functions – A to PD
DCOUNT function
DDB function
1. Financial functions – A to PD
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. Apply dependent combo box selections to a filter
2. Create dependent drop down lists containing unique distinct values
3. Dependent drop-down lists in multiple rows
DGET function
Dialog boxes
DMAX function
DMIN function
DO LOOP statement
1. How to use the DO LOOP statement
DOLLARFR function
1. Financial functions – A to PD
Doughnut chart
DOUNTA function
DPRODUCT function
Drop down lists
1. Add or remove a value in a drop down list programmatically
2. Advanced Techniques for Conditional Formatting
3. Compare data in an Excel chart using drop down lists
4. Create a drop down calendar
5. Highlight group of values in an x y scatter chart programmatically
6. How to automatically add new items to a drop down list
7. How to build an interactive map in Excel
9. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
10. Populate drop down list with filtered Excel Table values
11. Populate drop down list with unique distinct values sorted from A to Z
12. Run a Macro from a Drop Down list [VBA]
13. Use a drop down list to display data in worksheet header [VBA]
14. Use a drop down list to filter and concatenate unique distinct values
15. Use a drop down list to search and return multiple values
DROP function
1. Array Manipulation Functions
2. Convert date ranges into dates
3. Filter strings containing a given substring in a cell range
4. Filter unique distinct records case sensitive
5. Group rows based on a condition
6. Multiply numbers in each row by entire cell range
7. Working with classic ciphers in Excel
DSTDEV function
DSTDEVP function
DSUM function
Duplicate records
Duplicate values
1. Extract a list of alphabetically sorted duplicates based on a condition
2. Extract a list of duplicates from a column
3. Extract a list of duplicates from three columns combined
4. Extract duplicate values with exceptions
5. Extract duplicates from a multi-column cell range
6. Filter duplicate values based on criteria
7. Filter duplicates within same date, week or month
8. Filter values that exists in all three columns
9. Find min and max unique and duplicate numerical values
10. Label groups of duplicate records
DVARP function
EDATE function
1. Date and Time Functions – A to M
EFFECT function
1. Financial functions – A to PD
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
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 equals value from list
8. INDEX MATCH – Case sensitive
9. Match two columns and return another value on the same row
Excel Basics
1. How to improve worksheet readability in Excel
2. How to replace part of formula in all cells
3. How to select and delete blank cells
4. How to use absolute and relative references
5. Remove print preview lines (Page Breaks)
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 numbers from a column
2. Extract specific word based on position in cell value
3. 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
3. List permutations with repetition and how many to choose from
FACTDOUBLE function
1. How to use the FACTDOUBLE function
FALSE function
1. Advanced Excel Chart Techniques
2. Array Manipulation Functions
3. Automate net asset value (NAV) calculation on your stock portfolio
4. Create a drop down calendar
5. Extract a list of duplicates from a column
6. Filter unique strings from a cell range
7. Filter unique values from a cell range
8. Get date ranges from a schedule
9. Highlight lookups in relational tables
10. How to use mouse hover on a worksheet [VBA]
11. How to use nested IF functions
12. How to use the asterisk character
13. How to use the FALSE function
14. How to use VLOOKUP/XLOOKUP with multiple conditions
16. IF function with AND function – multiple conditions
17. INDEX MATCH – multiple results
18. Match two criteria and return multiple records
19. Merge tables based on a condition
20. Plot date ranges in a calendar
21. Rearrange values in a cell range to a single column
22. Repeat values across cells
23. Search for a text string in a data set and return multiple records
25. SUMPRODUCT and IF function
26. True round-robin tournament
27. Unique distinct records sorted based on count or frequency
28. VLOOKUP – Return multiple unique distinct values
29. Working with classic ciphers in Excel
FDIST function
Features
1. 5 easy ways to extract Unique Distinct Values
2. Add or remove a value in a drop down list programmatically
3. Advanced Techniques for Conditional Formatting
4. Analyze trends using pivot tables
5. Apply dependent combo box selections to a filter
6. Apply drop-down lists dynamically
8. Compare data in an Excel chart using drop down lists
9. Count unique distinct values in a filtered Excel defined Table
10. Create a drop down calendar
11. Create a dynamic named range
12. Create dependent drop down lists containing unique distinct values
13. Dependent drop-down lists in multiple rows
15. Extract unique distinct values based on a filtered Excel defined Table
16. Extract unique distinct values in a filtered list
17. Highlight duplicates in a filtered Excel Table
18. Highlight group of values in an x y scatter chart programmatically
19. How to automatically add new items to a drop down list
20. How to build an interactive map in Excel
21. How to compare two data sets
22. How to create a dynamic pivot table and refresh automatically
24. How to solve simultaneous linear equations in Excel
25. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
26. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
28. How to use Pivot Tables – Excel’s most powerful feature and also least known
29. How to use the COMBIN function
31. How to use the Subtotal tool
32. Identify numbers in sum using Excel solver
33. Lookup with any number of criteria
34. Macro creates links to all sheets, tables, pivot tables and named ranges
36. Populate drop down list with filtered Excel Table values
37. Populate drop down list with unique distinct values sorted from A to Z
38. Prepare data for Pivot Table – How to split concatenated values?
39. Prevent duplicate records in a worksheet
40. Prevent overlapping date and time ranges using data validation
41. Run a Macro from a Drop Down list [VBA]
42. Use a drop down list to display data in worksheet header [VBA]
43. Use a drop down list to filter and concatenate unique distinct values
44. Use a drop down list to search and return multiple values
45. Working with Excel tables programmatically
Files and folders
1. Compare file names in two different folder locations and their sub folders
2. Copy data from workbooks in folder and subfolders
3. Filter duplicate files in a folder and subfolders
4. Find and replace strings in file names, folder name and subfolders
5. List files in folder and create hyperlinks (VBA)
7. Open Excel files in a folder [VBA]
8. Search all workbooks in a folder
9. Search all workbooks in a folder and sub folders – VBA
10. Search for a file in folder and subfolders [UDF]
11. Which Excel files in folder are password protected?
Filter emails
1. Filter strings containing a given substring in a cell range
2. How to extract email addresses from an Excel sheet
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
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare two columns and extract differences
7. Compare two columns in different worksheets
9. Count unique distinct values based on a condition
10. Count unique distinct values that meet multiple criteria
11. Create dependent drop down lists containing unique distinct values
12. Create numbers based on numerical ranges
13. Date and Time Functions – A to M
14. Date and Time Functions – N to Z
15. Engineering functions – A to C
16. Extract a list of alphabetically sorted duplicates based on a condition
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 and ignore blanks
20. Extract a unique distinct list sorted from A to Z
21. Extract a unique distinct list sorted from A to Z ignore blanks
22. Extract all rows from a range that meet criteria in one column
23. Extract dates from overlapping date ranges
24. Extract duplicate values with exceptions
25. Extract duplicates from a multi-column cell range
26. Extract numbers from a column
27. Extract records between two dates
28. Extract shared values between two columns
29. Extract unique distinct values A to Z from a range and ignore blanks
30. Extract unique distinct values in a filtered list
31. Extract unique distinct values sorted based on sum of adjacent values
32. Filter duplicate values based on criteria
33. Filter overlapping date ranges
34. Filter strings containing a given substring in a cell range
35. Filter unique distinct records
36. Filter unique distinct records case sensitive
37. Filter unique distinct values based on a date range
38. Filter values in common between two cell ranges
39. Filter values occurring in range 1 but not in range 2
40. Find all sequences of consecutive dates
41. Find empty dates in a set of date ranges
42. Find min and max unique and duplicate numerical values
44. Find the most recent date that meets a particular condition
45. Get date ranges from a schedule
46. Group rows based on a condition
47. How to compare two data sets
48. How to create date ranges in Excel
49. How to extract a case sensitive unique list from a column
50. How to extract email addresses from an Excel sheet
51. How to extract rows containing digits [Formula]
52. How to ignore zeros using the SMALL function
53. How to list unique distinct values sorted by frequency
54. How to use the FILTER function
55. How to use VLOOKUP/XLOOKUP with multiple conditions
56. Identify rows of overlapping records
57. If cell contains text from list
58. INDEX MATCH – multiple results
59. INDEX MATCH with multiple criteria
60. List all unique distinct rows in a given month
61. List dates outside specified date ranges
62. Lookup and return multiple sorted values based on corresponding values in another column
63. Lookup and return multiple values concatenated into one cell
64. Lookup multiple values across columns and return a single value
65. Lookup multiple values in one cell
66. Lookups in relational tables
67. Match two criteria and return multiple records
68. Merge two columns with possible blank cells
69. Partial match and return multiple adjacent values
70. Partial match for multiple strings – AND logic
71. Partial match with two conditions and return multiple results
72. Reverse a list ignoring blanks
73. Search for a sequence of cells based on wildcard search
74. Search for a sequence of values
75. Search for a text string in a data set and return multiple records
76. SMALL function – INDEX MATCH
78. Use VLOOKUP and return multiple values sorted from A to Z
79. VLOOKUP – Return multiple unique distinct values
80. Vlookup a cell range and return multiple values
81. Vlookup with multiple matches returns a different value
82. VLOOKUP/XLOOKUP of three columns to pull a single record
83. What values are missing in List 1 that exists i List 2?
84. Wildcard lookups and include or exclude criteria
86. 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. How to extract rows containing digits [Formula]
4. Match two criteria and return multiple records
5. 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. Fetching values from ThingSpeak programmatically
3. How to use the FILTERXML function
4. Rearrange values in a cell range to a single column
5. Sort values in a cell based on a delimiting character
6. Split search value using a delimiter and search for each substring
Finance
1. Add buy and sell points to a stock chart
2. All you need to know about calculating NAV units for your stock portfolio
3. Automate net asset value (NAV) calculation on your stock portfolio
5. Compare the performance of your stock portfolio to S&P 500 using Excel
6. Follow stock market trends – Moving Average
7. Follow stock market trends – trailing stop
8. How to calculate and plot pivots on an Excel chart
9. How to track sector performance in the stock market – Excel template
10. Plot buy and sell points in an Excel Chart based on two moving averages
11. Tracking a stock portfolio #2
FIND function
1. Count a specific text string in a cell
2. Formula for matching a date within a date range
3. How to use the FIND function
4. INDEX MATCH – Case sensitive
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. How to use the FOR NEXT statement
4. Resize a range of values (UDF)
5. 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 based on frequency row-wise
3. Sort rows based on frequency and criteria
FTEST function
Functions
1. How to change a picture in a worksheet dynamically [VBA]
2. How to copy non contiguous cell ranges
Funnel chart
Fuzzy lookup
FV function
1. Financial functions – A to PD
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
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. How to decode URL-encoded strings
3. 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
4. How to calculate overlapping time ranges
HSTACK function
1. Array Manipulation Functions
2. Date and Time Functions – N to Z
5. Get date ranges from a schedule
6. Group rows based on a condition
7. How to create date ranges in Excel
8. Sort rows based on frequency and criteria
9. Working with classic ciphers in Excel
HYPERLINK function
1. Create a hyperlink linked to the result of a two-dimensional lookup
2. Easily select data using hyperlinks
3. Find last value in a column
4. Hover with mouse cursor to change stock in a candlestick chart
5. How to quickly find the maximum or minimum value [Formula]
6. How to use mouse hover on a worksheet [VBA]
7. How to use the HYPERLINK function
8. Navigate to first empty cell using a hyperlink formula
Hyperlinks
1. Create links to all sheets in a workbook programmatically
2. Easily select data using hyperlinks
3. List all hyperlinks in worksheet programmatically
4. List files in folder and create hyperlinks (VBA)
5. Macro creates links to all sheets, tables, pivot tables and named ranges
6. Navigate to first empty cell using a hyperlink formula
HYPGEOM.DIST function
1. How to use the HYPGEOM.DIST function
IF
1. Find the smallest number in a list that is larger than a given number
3. SUMPRODUCT and nested IF functions
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. Add buy and sell points to a stock chart
5. Apply dependent combo box selections to a filter
6. Array Manipulation Functions
8. Automate net asset value (NAV) calculation on your stock portfolio
13. Calculate machine utilization
15. Change chart axis range programmatically
16. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
17. Compare tables: Filter records occurring only in one table
18. Compare the performance of your stock portfolio to S&P 500 using Excel
19. Compare two columns and extract differences
20. Compare two columns in different worksheets
21. Concatenate unique distinct values
22. Convert array formula to a regular formula
23. Convert date ranges into dates
24. Count a specific text string in a cell
25. Count cells between specified values
27. Count unique distinct records
28. Count unique distinct values
29. Count unique distinct values based on a condition
30. Count unique distinct values in a filtered Excel defined Table
31. Count unique distinct values that meet multiple criteria
32. Create a drop down calendar
33. Create a hyperlink linked to the result of a two-dimensional lookup
34. Create a quartely date range
36. Create date ranges that stay within month
37. Create dependent drop down lists containing unique distinct values
39. Create numbers based on numerical ranges
40. Create unique distinct list sorted based on text length
41. Date and Time Functions – A to M
42. Date and Time Functions – N to Z
43. Dependent drop-down lists in multiple rows
44. Distribute values across numerical ranges
46. Excel calendar
47. Extract a list of alphabetically sorted duplicates based on a condition
48. Extract a list of duplicates from a column
49. Extract a unique distinct list from two columns
50. Extract a unique distinct list sorted from A to Z
51. Extract a unique distinct list sorted from A to Z ignore blanks
52. Extract all rows from a range that meet criteria in one column
53. Extract dates from overlapping date ranges
54. Extract duplicates from a multi-column cell range
55. Extract numbers from a column
56. Extract records between two dates
57. Extract shared values between two columns
58. Extract specific word based on position in cell value
59. Extract the most repeated adjacent values in a column
60. Extract unique distinct values A to Z from a range and ignore blanks
61. Extract unique distinct values from a multi-column cell range
62. Extract unique distinct values from a relational table
63. Extract unique distinct values in a filtered list
64. Extract unique distinct values sorted based on sum of adjacent values
65. Extract unique distinct values sorted from A to Z
66. Filter duplicate values based on criteria
67. Filter duplicates within same date, week or month
68. Filter overlapping date ranges
69. Filter strings containing a given substring in a cell range
70. Filter unique distinct records
71. Filter unique distinct values based on a date range
72. Filter unique distinct values, sorted and blanks removed from a range
73. Filter unique values from a cell range
74. Filter unique values sorted from A to Z
75. Filter values in common between two cell ranges
76. Filter values occurring in range 1 but not in range 2
77. Financial functions – PMT to RATE
78. Find all sequences of consecutive dates
79. Find and return the highest number and corresponding date based on a condition
81. Find earliest and latest overlapping dates in a set of date ranges based on a condition
82. Find empty dates in a set of date ranges
83. Find empty hours in a weekly schedule
84. Find min and max unique and duplicate numerical values
86. Find numbers closest to sum
87. Find the most recent date that meets a particular condition
88. Find the smallest number in a list that is larger than a given number
89. Follow stock market trends – Moving Average
90. Follow stock market trends – trailing stop
91. Formula for matching a date within a date range
92. Fuzzy VLOOKUP
93. Get date ranges from a schedule
95. Group rows based on a condition
96. Highlight duplicates in a filtered Excel Table
97. Highlight lookups in relational tables
98. Highlight unique values in a filtered Excel table
99. How to calculate and plot pivots on an Excel chart
100. How to color chart bars based on their values
101. How to compare two data sets
102. How to count repeating values
103. How to create date ranges in Excel
104. How to create random numbers, text strings, dates and time values
105. How to create running totals
106. How to decode URL-encoded strings
107. How to extract a case sensitive unique list from a column
108. How to extract email addresses from an Excel sheet
109. How to extract numbers from a cell value
110. How to extract rows containing digits [Formula]
111. How to group items by quarter using formulas
112. How to highlight duplicate values
113. How to ignore zeros using the SMALL function
114. How to list unique distinct values sorted by frequency
115. How to perform a two-dimensional lookup
116. How to replace part of formula in all cells
117. How to return a value if lookup value is in a range
118. How to select and delete blank cells
119. How to track sector performance in the stock market – Excel template
121. How to use nested IF functions
122. How to use the IF function
123. How to use VLOOKUP/XLOOKUP with multiple conditions
124. Identify rows of overlapping records
126. If cell contains text from list
127. If cell equals value from list
128. IF function with AND function – multiple conditions
129. IF with OR function
130. INDEX MATCH – multiple results
131. INDEX MATCH with multiple criteria
132. Label groups of duplicate records
133. List all unique distinct rows in a given month
134. List dates outside specified date ranges
135. Lookup and return multiple sorted values based on corresponding values in another column
136. Lookup and return multiple values concatenated into one cell
137. Lookup multiple values across columns and return a single value
139. Lookup with any number of criteria
140. Lookups in relational tables
141. Match two criteria and return multiple records
142. Merge cell ranges into one list
143. Merge tables based on a condition
144. Merge two columns with possible blank cells
145. Monthly calendar template
146. Most frequent value between two dates
147. Multiply numbers in each row by entire cell range
148. Partial match and return multiple adjacent values
149. Partial match and return value with highest level
150. Partial match for multiple strings – AND logic
151. Partial match with two conditions and return multiple results
152. Perform multiple partial matches and return records – AND logic
153. Pivot Table calendar
154. Plot buy and sell points in an Excel Chart based on two moving averages
155. Plot date ranges in a calendar
156. Populate cells dynamically in a weekly schedule
157. Populate drop down list with filtered Excel Table values
158. Populate drop down list with unique distinct values sorted from A to Z
159. Practice basic arithmetic calculations in Excel
160. Rearrange data
161. Remove common records between two data sets
162. Remove duplicates within same month or year
163. Repeat values across cells
164. Reverse a list ignoring blanks
165. Rotating unique groups with no repeat
166. Search each column for a string each and return multiple records – OR logic
167. Search for a sequence of cells based on wildcard search
168. Search for a sequence of values
169. Search for a text string in a data set and return multiple records
170. Search related table based on a date and date range
171. Shift Schedule
172. SMALL function – multiple conditions
174. SMALL function ignore duplicates
175. Sort a column alphabetically
176. Sort a range from A to Z [Array formula]
177. Sort based on frequency row-wise
178. Sort column based on frequency
179. Sort rows based on frequency and criteria
180. Sort values by corresponding text arranged in a column
181. Split expenses calculator
182. Split search value using a delimiter and search for each substring
183. Split values equally into groups
184. SUMPRODUCT and IF function
185. SUMPRODUCT and nested IF functions
186. Time sheet for work
187. Tracking a stock portfolio #2
188. True round-robin tournament
189. Unique distinct records sorted based on count or frequency
190. Use a drop down list to filter and concatenate unique distinct values
191. Use a drop down list to search and return multiple values
192. Use drop down lists and named ranges to filter chart values
193. Use IF + COUNTIF to evaluate multiple conditions
194. Use VLOOKUP and return multiple values sorted from A to Z
195. VLOOKUP – Return multiple unique distinct values
196. Vlookup a cell range and return multiple values
197. Vlookup across multiple sheets
198. Vlookup with multiple matches returns a different value
199. VLOOKUP/XLOOKUP of three columns to pull a single record
200. Watch schedule that populates vacation time
201. What values are missing in List 1 that exists i List 2?
202. Wildcard lookups and include or exclude criteria
203. Working with classic ciphers in Excel
205. Working with overlapping date ranges
206. Working with three relational tables
IF THEN ELSE statement
2. Find the most/least consecutive repeated value [VBA]
3. How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
4. Run a Macro from a Drop Down list [VBA]
5. Show / hide a picture using a button
6. Working with comments – VBA
IFERROR 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. Analyze word frequency in a cell range
5. Apply dependent combo box selections to a filter
9. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
10. Compare the performance of your stock portfolio to S&P 500 using Excel
11. Compare two columns and extract differences
12. Count a specific text string in a cell
13. Count cells between specified values
14. Count unique distinct records
15. Date and Time Functions – N to Z
17. Excel calendar
18. Extract a list of duplicates from a column
19. Extract a list of duplicates from three columns combined
20. Extract a unique distinct list from three columns
21. Extract a unique distinct list from two columns
22. Extract a unique distinct list sorted from A to Z ignore blanks
23. Extract duplicate values with exceptions
24. Extract records between two dates
25. Extract specific word based on position in cell value
26. Extract unique distinct values from a relational table
27. Filter duplicate values based on criteria
28. Filter unique distinct records
29. Filter unique distinct values based on a date range
30. Filter unique distinct values, sorted and blanks removed from a range
31. Filter values that exists in all three columns
32. Find all sequences of consecutive dates
34. Follow stock market trends – Moving Average
35. Fuzzy VLOOKUP
37. Group rows based on a condition
38. How to automatically add new items to a drop down list
39. How to build a Team Generator – different number of people per team
40. How to calculate and plot pivots on an Excel chart
41. How to extract rows containing digits [Formula]
42. How to group items by quarter using formulas
43. How to perform a two-dimensional lookup
45. How to use the IFERROR function
47. Identify rows of overlapping records
48. If cell contains text from list
49. List all unique distinct rows in a given month
50. List dates outside specified date ranges
51. Lookup and return multiple values concatenated into one cell
53. Lookup with any number of criteria
54. Lookups in relational tables
55. Merge cell ranges into one list
56. Merge two columns with possible blank cells
57. Plot buy and sell points in an Excel Chart based on two moving averages
58. Plot date ranges in a calendar
59. Populate drop down list with filtered Excel Table values
60. Remove common records between two data sets
61. Search for a text string in a data set and return multiple records
62. Search related table based on a date and date range
63. Shift Schedule
64. Sort rows based on frequency and criteria
65. Sort text cells alphabetically from two columns
67. Split search value using a delimiter and search for each substring
68. Split values equally into groups
69. Team Generator
71. Tracking a stock portfolio #2
72. True round-robin tournament
73. Use a drop down list to search and return multiple values
74. Vlookup a cell range and return multiple values
75. Vlookup across multiple sheets
76. Watch schedule that populates vacation time
77. Wildcard lookups and include or exclude criteria
78. Working with classic ciphers in Excel
79. Working with three relational tables
80. Working with unique values
IFNA function
1. Array Manipulation Functions
2. Filter unique distinct records
3. Get date ranges from a schedule
4. How to use the IFNA function
5. Lookups in relational tables
IFS function
1. How to use the IFS function
IMABS function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMAGE function
1. How to use the IMAGE function
IMAGINARY function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMARGUMENT function
1. Engineering functions – D to IMC
IMCONJUGATE function
1. Engineering functions – D to IMC
IMCOS function
1. Engineering functions – D to IMC
IMCOSH function
1. Engineering functions – D to IMC
IMCOT function
1. Engineering functions – D to IMC
IMCSC function
1. Engineering functions – D to IMC
IMCSCH function
1. Engineering functions – D to IMC
IMDIV function
1. Engineering functions – IMD to Z
IMEXP function
1. Engineering functions – IMD to Z
IMLN
IMLOG10 function
1. Engineering functions – IMD to Z
IMLOG2 function
1. Engineering functions – IMD to Z
IMPOWER function
1. Engineering functions – IMD to Z
2. How to use the IMPOWER function
IMPRODUCT function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMREAL function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMSEC function
1. Engineering functions – IMD to Z
IMSECH function
1. Engineering functions – IMD to Z
IMSIN function
1. Engineering functions – IMD to Z
IMSINH function
1. Engineering functions – IMD to Z
IMSQRT function
1. Engineering functions – IMD to Z
IMSUB function
1. Engineering functions – IMD to Z
IMSUM function
1. Engineering functions – IMD to Z
IMTAN function
1. Engineering functions – IMD to Z
INDEX + MATCH
1. INDEX MATCH – Case sensitive
2. INDEX MATCH – multiple results
3. INDEX MATCH with multiple criteria
4. Lookup multiple values across columns and return a single value
5. SMALL function – INDEX MATCH
INDEX function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Apply dependent combo box selections to a filter
4. Array Manipulation Functions
5. Assign records unique random text strings
7. Automate net asset value (NAV) calculation on your stock portfolio
9. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
10. Compare tables: Filter records occurring only in one table
11. Compare the performance of your stock portfolio to S&P 500 using Excel
12. Compare two columns and extract differences
13. Compare two columns in different worksheets
15. Convert array formula to a regular formula
16. Count a specific text string in a cell
17. Count specific multiple text strings in a given cell range
18. Create a drop down calendar
19. Create a hyperlink linked to the result of a two-dimensional lookup
21. Create dependent drop down lists containing unique distinct values
22. Create unique distinct list sorted based on text length
23. Date and Time Functions – A to M
24. Dependent drop-down lists in multiple rows
27. Excel calendar
28. Extract a list of alphabetically sorted duplicates based on a condition
29. Extract a list of duplicates from a column
30. Extract a unique distinct list and sum amounts based on a condition
31. Extract a unique distinct list from three columns
32. Extract a unique distinct list from two columns
33. Extract a unique distinct list sorted from A to Z
34. Extract a unique distinct list sorted from A to Z ignore blanks
35. Extract all rows from a range that meet criteria in one column
36. Extract duplicates from a multi-column cell range
37. Extract numbers from a column
38. Extract records between two dates
39. Extract shared values between two columns
40. Extract specific word based on position in cell value
41. Extract the most repeated adjacent values in a column
42. Extract unique distinct values A to Z from a range and ignore blanks
43. Extract unique distinct values based on a filtered Excel defined Table
44. Extract unique distinct values based on the 4 last characters
45. Extract unique distinct values from a multi-column cell range
46. Extract unique distinct values from a relational table
47. Extract unique distinct values in a filtered list
48. Extract unique distinct values sorted based on sum of adjacent values
49. Extract unique distinct values sorted from A to Z
50. Filter duplicate values based on criteria
51. Filter duplicates within same date, week or month
52. Filter unique distinct records
53. Filter unique distinct records case sensitive
54. Filter unique distinct values based on a date range
55. Filter unique distinct values, sorted and blanks removed from a range
56. Filter unique values from a cell range
57. Filter unique values sorted from A to Z
58. Filter values in common between two cell ranges
59. Filter values occurring in range 1 but not in range 2
60. Filter values that exists in all three columns
62. Find last value in a column
64. Find numbers closest to sum
65. Find the most recent date that meets a particular condition
66. Find the most/least consecutive repeated value [VBA]
67. Follow stock market trends – Moving Average
68. Formula for matching a date within a date range
69. Fuzzy lookups
70. Fuzzy VLOOKUP
71. Get date ranges from a schedule
73. Group rows based on a condition
74. Highlight a data series in a chart
75. Highlight lookups in relational tables
76. How to animate an Excel chart
77. How to automatically add new items to a drop down list
78. How to build a Team Generator – different number of people per team
79. How to build an interactive map in Excel
80. How to change a picture in a worksheet dynamically [VBA]
81. How to compare two data sets
82. How to copy non contiguous cell ranges
83. How to create date ranges in Excel
84. How to extract a case sensitive unique list from a column
85. How to extract email addresses from an Excel sheet
86. How to extract rows containing digits [Formula]
88. How to generate random numbers and text
89. How to group items by quarter using formulas
90. How to highlight differences and common values in lists
91. How to list unique distinct values sorted by frequency
92. How to perform a two-dimensional lookup
93. How to quickly find the maximum or minimum value [Formula]
94. How to replace part of formula in all cells
95. How to return a value if lookup value is in a range
96. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
97. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
99. How to use the INDEX function
100. How to use the MAKEARRAY function
101. How to use the Scroll Bar
102. How to use VLOOKUP/XLOOKUP with multiple conditions
103. If cell contains text from list
104. If cell equals value from list
105. INDEX MATCH – Case sensitive
106. INDEX MATCH – multiple results
107. INDEX MATCH with multiple criteria
108. Label groups of duplicate records
109. List all unique distinct rows in a given month
110. List permutations with repetition and how many to choose from
111. Lookup and return multiple sorted values based on corresponding values in another column
112. Lookup multiple values across columns and return a single value
115. Lookup with any number of criteria
116. Lookups in relational tables
117. Match two columns and return another value on the same row
118. Match two criteria and return multiple records
119. Merge cell ranges into one list
120. Merge tables based on a condition
121. Merge two columns with possible blank cells
122. Merge two relational data sets
123. Most frequent value between two dates
124. Multiply numbers in each row by entire cell range
125. Partial match and return multiple adjacent values
126. Partial match and return value with highest level
127. Partial match for multiple strings – AND logic
128. Partial match with two conditions and return multiple results
129. Perform multiple partial matches and return records – AND logic
130. Pivot Table calendar
131. Plot buy and sell points in an Excel Chart based on two moving averages
132. Plot date ranges in a calendar
133. Populate drop down list with filtered Excel Table values
134. Populate drop down list with unique distinct values sorted from A to Z
135. Rearrange values in a cell range to a single column
136. Rearrange values using formulas
137. Remove common records between two data sets
138. Remove duplicates within same month or year
139. Repeat values across cells
140. Reverse a list ignoring blanks
141. Rotating unique groups with no repeat
142. Search each column for a string each and return multiple records – OR logic
143. Search for a text string in a data set and return multiple records
144. Search related table based on a date and date range
145. Shift Schedule
146. SMALL function – INDEX MATCH
148. Sort a column alphabetically
149. Sort a range from A to Z [Array formula]
150. Sort based on frequency row-wise
152. Sort column based on frequency
153. Sort items by adjacent number in every other value
154. Sort rows based on frequency and criteria
155. Sort text cells alphabetically from two columns
156. Sort values by corresponding text arranged in a column
157. Split expenses calculator
158. Split values equally into groups
159. Team Generator
160. Time sheet for work
161. True round-robin tournament
162. Two-way lookup in multiple cross reference tables simultaneously
163. Unique distinct records sorted based on count or frequency
164. Use a drop down list to search and return multiple values
165. Use drop down lists and named ranges to filter chart values
166. Use VLOOKUP and return multiple values sorted from A to Z
168. VLOOKUP – Return multiple unique distinct values
169. Vlookup a cell range and return multiple values
170. Vlookup across multiple sheets
171. Vlookup with multiple matches returns a different value
172. VLOOKUP/XLOOKUP of three columns to pull a single record
173. Watch schedule that populates vacation time
174. What values are missing in List 1 that exists i List 2?
175. Wildcard lookups and include or exclude criteria
176. Working with classic ciphers in Excel
177. Working with overlapping date ranges
178. Working with three relational tables
INDIRECT function
1. Add or remove a value in a drop down list programmatically
2. Add values to a regular drop-down list programmatically
3. Advanced Techniques for Conditional Formatting
4. Compare data in an Excel chart using drop down lists
5. Date and Time Functions – N to Z
6. Find empty dates in a set of date ranges
7. Find empty hours in a weekly schedule
8. Highlight a data series in a chart
9. Highlight duplicates in a filtered Excel Table
10. Highlight lookups in relational tables
11. Highlight unique values in a filtered Excel table
12. How to calculate overlapping time ranges
13. How to create permutations
14. How to use absolute and relative references
15. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
17. How to use the INDIRECT function
18. Plot date ranges in a calendar
19. Prevent duplicate records in a worksheet
20. Prevent overlapping date and time ranges using data validation
21. True round-robin tournament
22. Two-way lookup in multiple cross reference tables simultaneously
23. Watch schedule that populates vacation time
24. Working with overlapping date ranges
INFO function
1. How to use the INFO function
INT function
1. Calculate machine utilization
2. Calculate the number of weeks between given dates
4. Date and Time Functions – A to M
6. Find numbers closest to sum
9. How to use the INT function
10. True round-robin tournament
INT function
1. Calculate machine utilization
2. Calculate the number of weeks between given dates
4. Date and Time Functions – A to M
6. Find numbers closest to sum
9. How to use the INT function
10. True round-robin tournament
Interactive
1. Highlight group of values in an x y scatter chart programmatically
2. Hover with mouse cursor to change stock in a candlestick chart
3. How to build an interactive map in Excel
4. How to create an interactive Excel chart [VBA]
6. How to use mouse hover on a worksheet [VBA]
7. Use drop down lists and named ranges to filter chart values
INTERCEPT function
1. How to use the INTERCEPT function
Invoice
IPMT function
1. Financial functions – A to PD
ISBLANK function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. Count groups of repeated values per row
3. Extract a unique distinct list sorted from A to Z ignore blanks
4. Extract unique distinct values A to Z from a range and ignore blanks
5. How to use the ISBLANK function
6. Merge two columns with possible blank cells
ISERR function
1. How to use the ISERR function
ISERROR function
1. A Comprehensive Guide to Splitting Text in Excel
3. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Extract a list of duplicates from a column
6. Extract a unique distinct list from two columns
7. Extract unique distinct values from a relational table
10. Highlight lookups in relational tables
11. How to extract email addresses from an Excel sheet
12. How to highlight differences and common values in lists
13. How to perform a two-dimensional lookup
14. How to use the ISERROR function
15. Lookups in relational tables
16. Match two criteria and return multiple records
17. Merge cell ranges into one list
18. Merge tables based on a condition
20. True round-robin tournament
21. What values are missing in List 1 that exists i List 2?
22. Working with three relational tables
ISEVEN funtion
ISFORMULA function
1. How to use the ISFORMULA function
ISLOGICAL function
1. How to use the ISLOGICAL function
ISNA function
1. 5 easy ways to extract Unique Distinct Values
2. Automate net asset value (NAV) calculation on your stock portfolio
3. How to use the ISNA function
ISNONTEXT function
1. How to use the ISNONTEXT function
ISNUMBER function
1. 5 easy ways to VLOOKUP and return multiple values
2. Count a specific text string in a cell
3. Count cells containing text from list
5. Extract a unique distinct list sorted from A to Z ignore blanks
6. Extract duplicates from a multi-column cell range
7. Extract numbers from a column
8. Extract unique distinct values if the value contains the given string
9. Filter strings containing a given substring in a cell range
10. Filter unique distinct values, sorted and blanks removed from a range
11. How to extract email addresses from an Excel sheet
12. How to extract numbers from a cell value
13. How to use the ISNUMBER function
15. INDEX MATCH – Case sensitive
16. INDEX MATCH – multiple results
17. INDEX MATCH with multiple criteria
18. Match two columns and return another value on the same row
19. Match two criteria and return multiple records
20. Partial match and return multiple adjacent values
21. Partial match and return value with highest level
22. Partial match for multiple strings – AND logic
23. Partial match with two conditions and return multiple results
24. Perform multiple partial matches and return records – AND logic
25. Search each column for a string each and return multiple records – OR logic
26. Search for a sequence of cells based on wildcard search
27. Search for a text string in a data set and return multiple records
28. VLOOKUP – Return multiple unique distinct values
29. Wildcard lookups and include or exclude criteria
30. Working with classic ciphers in Excel
ISODD function
1. How to use the ISODD function
ISPMT function
1. Financial functions – A to PD
ISREF function
1. How to use the ISREF function
ISTEXT function
2. Extract a unique distinct list sorted from A to Z ignore blanks
3. Filter unique distinct values, sorted and blanks removed from a range
4. How to use the ISTEXT function
5. Lookup multiple values in one cell
6. Sort values by corresponding text arranged in a column
7. VLOOKUP – Return multiple unique distinct values
JOIN function
KURT function
1. How to use the KURT function
LAMBDA function
1. Analyze word frequency in a cell range
2. Convert date ranges into dates
3. Filter strings containing a given substring in a cell range
4. Filter unique distinct records case sensitive
7. Group rows based on a condition
8. How to replace part of formula in all cells
9. How to use the LAMBDA function
10. How to use the MAKEARRAY function
11. Multiply numbers in each row by entire cell range
12. Rearrange data
13. Search for a text string in a data set and return multiple records
14. Two-way lookup in multiple cross reference tables simultaneously
15. Vlookup a cell range and return multiple values
16. Working with classic ciphers in Excel
LARGE function
1. Assign records unique random text strings
3. Date and Time Functions – A to M
5. Extract the most repeated adjacent values in a column
6. Extract unique distinct values from a multi-column cell range
7. Find the most recent date that meets a particular condition
8. Find the most/least consecutive repeated value [VBA]
9. Find the smallest number in a list that is larger than a given number
10. How to build a Team Generator – different number of people per team
11. How to use the LARGE function
12. Plot buy and sell points in an Excel Chart based on two moving averages
13. Reverse a list ignoring blanks
14. Rotating unique groups with no repeat
15. Sort a column alphabetically
16. Sort based on frequency row-wise
18. Sort column based on frequency
19. Sort items by adjacent number in every other value
20. Sort rows based on frequency and criteria
21. Team Generator
22. True round-robin tournament
23. Unique distinct records sorted based on count or frequency
Lbound Ubound function
LCM function
1. How to use the LCM function
LEFT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Date and Time Functions – A to M
3. Engineering functions – A to C
4. Extract duplicates from a multi-column cell range
5. Extract specific word based on position in cell value
6. Formula for matching a date within a date range
8. How to calculate and plot pivots on an Excel chart
9. How to extract email addresses from an Excel sheet
10. How to use the LEFT function
11. Lookup and return multiple values concatenated into one cell
12. VLOOKUP – Return multiple unique distinct values
13. Working with classic ciphers in Excel
LEN function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Analyze word frequency in a cell range
4. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Count a specific text string in a cell
6. Count specific multiple text strings in a given cell range
7. Create unique distinct list sorted based on text length
8. Engineering functions – A to C
9. Extract duplicates from a multi-column cell range
10. Find last value in a column
11. Formula for matching a date within a date range
12. Fuzzy lookups
13. Fuzzy VLOOKUP
14. How to count the number of values separated by a delimiter
15. How to extract email addresses from an Excel sheet
16. How to extract numbers from a cell value
17. How to remove numbers from a cell value
18. How to use the LEN function
19. List all permutations with a condition
20. Lookup and return multiple values concatenated into one cell
21. Partial match and return multiple adjacent values
23. Sort a column alphabetically
24. VLOOKUP – Return multiple unique distinct values
25. Working with classic ciphers in Excel
LET function
1. 5 easy ways to extract Unique Distinct Values
2. A Comprehensive Guide to Splitting Text in Excel
3. Array Manipulation Functions
4. Calculate the number of weeks between given dates
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare two columns and extract differences
8. Count overlapping days in multiple date ranges
9. Create numbers based on numerical ranges
10. Date and Time Functions – N to Z
12. Extract a list of alphabetically sorted duplicates based on a condition
13. Extract a list of duplicates from a column
14. Extract a list of duplicates from three columns combined
15. Extract dates from overlapping date ranges
16. Extract duplicate values with exceptions
17. Extract duplicates from a multi-column cell range
18. Extract the most repeated adjacent values in a column
19. Extract unique distinct values A to Z from a range and ignore blanks
20. Extract unique distinct values in a filtered list
21. Extract unique distinct values sorted based on sum of adjacent values
22. Filter duplicate values based on criteria
23. Filter unique distinct records case sensitive
24. Find all sequences of consecutive dates
25. Find empty dates in a set of date ranges
26. Find empty hours in a weekly schedule
28. Find numbers closest to sum
29. Fuzzy lookups
30. Get date ranges from a schedule
31. How to calculate overlapping time ranges
32. How to create date ranges in Excel
33. How to decode URL-encoded strings
34. How to do tiered calculations in one formula
35. How to extract a case sensitive unique list from a column
36. How to extract email addresses from an Excel sheet
37. How to extract numbers from a cell value
38. How to list unique distinct values sorted by frequency
39. How to sum overlapping time
40. How to track sector performance in the stock market – Excel template
41. How to use the LET function
42. How to use VLOOKUP/XLOOKUP with multiple conditions
43. If cell contains text from list
44. List dates outside specified date ranges
45. Lookup and return multiple sorted values based on corresponding values in another column
46. Match two criteria and return multiple records
47. Merge two columns with possible blank cells
48. Reverse a list ignoring blanks
49. Search for a text string in a data set and return multiple records
50. Sort items by adjacent number in every other value
51. Sort rows based on frequency and criteria
52. Sort values by corresponding text arranged in a column
54. Sum numerical ranges between two numbers
55. Team Generator
56. Unique distinct records sorted based on count or frequency
57. VLOOKUP – Return multiple unique distinct values
58. Vlookup a cell range and return multiple values
59. Wildcard lookups and include or exclude criteria
60. Working with classic ciphers in Excel
Line
Line chart
LINEST function
1. How to use the LINEST function
Listbox
1. Working with LIST BOXES (Form Controls)
LN function
LOG function
1. Financial functions – A to PD
2. How to use the LOG function
LOG10 function
1. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
2. How to use the LOG10 function
LOGEST function
1. How to use the LOGEST function
Logic
1. How to use nested IF functions
2. If cell contains multiple values
4. If cell contains text from list
5. If cell equals value from list
6. IF function with AND function – multiple conditions
7. Use IF + COUNTIF to evaluate multiple conditions
LOGNORM.DIST function
1. How to use the LOGNORM.DIST function
LOGNORMDIST function
LOOKUP function
1. 5 easy ways to extract Unique Distinct Values
3. Distribute values across numerical ranges
4. Extract a list of duplicates from a column
5. Extract a list of duplicates from three columns combined
6. Extract a unique distinct list and ignore blanks
7. Extract a unique distinct list from three columns
8. Extract a unique distinct list from two columns
9. Extract duplicate values with exceptions
10. Extract unique distinct values if the value contains the given string
11. Filter duplicates within same date, week or month
12. Find last matching value in an unsorted list
13. Find last value in a column
14. Formula for matching a date within a date range
15. How to return a value if lookup value is in a range
16. How to use the LOOKUP function
17. How to use VLOOKUP/XLOOKUP with multiple conditions
18. Lookup and match last value – reverse lookup
19. Partial match and return multiple adjacent values
20. Partial match for multiple strings – AND logic
21. Split search value using a delimiter and search for each substring
22. SUMPRODUCT and nested IF functions
23. VLOOKUP – Return multiple unique distinct values
25. Working with unique values
Lookup numerical ranges
1. Distribute values across numerical ranges
Lookups
2. Find last matching value in an unsorted list
3. Find last value in a column
5. How to perform a two-dimensional lookup
6. Lookup with any number of criteria
LOWER function
1. How to use the LOWER function
Macro
1. Add or remove a value in a drop down list programmatically
2. Add values to a regular drop-down list programmatically
3. Add values to a two-dimensional table based on conditions [VBA]
4. Apply drop-down lists dynamically
5. Auto resize columns as you type
7. Copy a dynamic cell range [VBA]
8. Copy data from workbooks in folder and subfolders
9. Copy worksheets in active workbook to new workbooks
10. Count text string in all formulas in a worksheet [VBA]
11. Create a Print button – macro
12. Create new worksheets programmatically based on values in a cell range [VBA]
13. Customize the ribbon and how to add your macros
14. Excel calendar
15. Excel template: Getting Things Done [VBA]
16. Extract cell references populated with values [VBA]
17. Find cells containing formulas with literal (hardcoded) values
19. Find the most/least consecutive repeated value [VBA]
20. Hide specific worksheets programmatically
21. Highlight date ranges overlapping selected record [VBA]
22. How to change a picture in a worksheet dynamically [VBA]
23. How to copy non contiguous cell ranges
24. How to create an interactive Excel chart [VBA]
25. How to highlight row of the selected cell programmatically
26. How to save custom functions and macros to an Add-In
27. How to save specific multiple worksheets to a pdf file programmatically
30. Locate a shape in a workbook
32. Multiply numbers in each row by entire cell range
33. Open Excel files in a folder [VBA]
34. Prepare data for Pivot Table – How to split concatenated values?
35. Run a Macro from a Drop Down list [VBA]
37. Show / hide a picture using a button
38. Sort values in a cell based on a delimiting character
39. Split data across multiple sheets – VBA
40. Toggle a macro on/off using a button
41. User opens or closes a workbook creates an event
42. Working with COMBO BOXES [Form Controls]
43. Working with comments – VBA
44. Working with Excel tables programmatically
46. Working with TEXT BOXES [Form Controls]
MAKEARRAY function
1. How to use the MAKEARRAY function
Map chart
MAP function
1. How to use the MAP function
2. Two-way lookup in multiple cross reference tables simultaneously
Maps
2. How to build an interactive map in Excel
MATCH function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Apply dependent combo box selections to a filter
4. Assign records unique random text strings
6. Automate net asset value (NAV) calculation on your stock portfolio
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
13. Concatenate unique distinct values
14. Convert array formula to a regular formula
15. Count cells between specified values
16. Count rows containing data
17. Count unique distinct values
18. Create a drop down calendar
19. Create a hyperlink linked to the result of a two-dimensional lookup
21. Create dependent drop down lists containing unique distinct values
23. Create unique distinct list sorted based on text length
24. Date and Time Functions – A to M
25. Dependent drop-down lists in multiple rows
28. Easily select data using hyperlinks
29. Excel calendar
30. Extract a list of alphabetically sorted duplicates based on a condition
31. Extract a list of duplicates from a column
32. Extract a list of duplicates from three columns combined
33. Extract a unique distinct list and sum amounts based on a condition
34. Extract a unique distinct list from three columns
35. Extract a unique distinct list from two columns
36. Extract a unique distinct list sorted from A to Z
37. Extract a unique distinct list sorted from A to Z ignore blanks
38. Extract all rows from a range that meet criteria in one column
39. Extract duplicate values with exceptions
40. Extract duplicates from a multi-column cell range
41. Extract records between two dates
42. Extract shared values between two columns
43. Extract the most repeated adjacent values in a column
44. Extract unique distinct values A to Z from a range and ignore blanks
45. Extract unique distinct values based on a filtered Excel defined Table
46. Extract unique distinct values based on the 4 last characters
47. Extract unique distinct values from a multi-column cell range
48. Extract unique distinct values from a relational table
49. Extract unique distinct values in a filtered list
50. Extract unique distinct values sorted based on sum of adjacent values
51. Extract unique distinct values sorted from A to Z
52. Filter duplicate values based on criteria
53. Filter duplicates within same date, week or month
54. Filter unique distinct records
55. Filter unique distinct values based on a date range
56. Filter unique distinct values, sorted and blanks removed from a range
57. Filter unique values from a cell range
58. Filter unique values sorted from A to Z
59. Filter values in common between two cell ranges
60. Filter values occurring in range 1 but not in range 2
61. Filter values that exists in all three columns
62. Financial functions – PMT to RATE
64. Find last value in a column
66. Find numbers closest to sum
67. Find the most recent date that meets a particular condition
68. Find the most/least consecutive repeated value [VBA]
69. Follow stock market trends – Moving Average
70. Formula for matching a date within a date range
71. Get date ranges from a schedule
73. Group rows based on a condition
75. Highlight duplicates in a filtered Excel Table
76. Highlight lookups in relational tables
77. Highlight unique values in a filtered Excel table
78. How to animate an Excel chart
79. How to automatically add new items to a drop down list
80. How to build a Team Generator – different number of people per team
81. How to build an interactive map in Excel
82. How to change a picture in a worksheet dynamically [VBA]
83. How to color chart bars based on their values
84. How to compare two data sets
85. How to extract a case sensitive unique list from a column
86. How to extract email addresses from an Excel sheet
87. How to extract rows containing digits [Formula]
89. How to group items by quarter using formulas
90. How to highlight differences and common values in lists
91. How to list unique distinct values sorted by frequency
92. How to perform a two-dimensional lookup
93. How to quickly find the maximum or minimum value [Formula]
94. How to return a value if lookup value is in a range
95. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
96. How to use the MATCH function
97. How to use VLOOKUP/XLOOKUP with multiple conditions
98. If cell contains text from list
99. INDEX MATCH – Case sensitive
100. INDEX MATCH – multiple results
101. INDEX MATCH with multiple criteria
102. Label groups of duplicate records
103. List all unique distinct rows in a given month
104. Lookup and return multiple sorted values based on corresponding values in another column
105. Lookup and return multiple values concatenated into one cell
106. Lookup multiple values across columns and return a single value
109. Lookup with any number of criteria
110. Lookups in relational tables
111. Match two columns and return another value on the same row
112. Match two criteria and return multiple records
113. Merge tables based on a condition
114. Merge two relational data sets
115. Monthly calendar template
116. Most frequent value between two dates
117. Partial match and return multiple adjacent values
118. Partial match and return value with highest level
119. Partial match for multiple strings – AND logic
120. Partial match with two conditions and return multiple results
121. Perform multiple partial matches and return records – AND logic
122. Plot buy and sell points in an Excel Chart based on two moving averages
123. Plot date ranges in a calendar
124. Populate drop down list with filtered Excel Table values
125. Populate drop down list with unique distinct values sorted from A to Z
126. Remove common records between two data sets
127. Remove duplicates within same month or year
128. Repeat values across cells
129. Reverse a list ignoring blanks
130. Rotating unique groups with no repeat
131. Search each column for a string each and return multiple records – OR logic
132. Search for a sequence of cells based on wildcard search
133. Search for a sequence of values
134. Search for a text string in a data set and return multiple records
135. Search related table based on a date and date range
136. Shift Schedule
137. SMALL function – INDEX MATCH
139. Sort a column alphabetically
140. Sort a range from A to Z [Array formula]
141. Sort based on frequency row-wise
143. Sort column based on frequency
144. Sort items by adjacent number in every other value
145. Sort rows based on frequency and criteria
146. Sort text cells alphabetically from two columns
147. Sort values by corresponding text arranged in a column
148. Split expenses calculator
149. Team Generator
150. Time sheet for work
151. True round-robin tournament
152. Two-way lookup in multiple cross reference tables simultaneously
153. Unique distinct records sorted based on count or frequency
154. Use a drop down list to search and return multiple values
155. Use drop down lists and named ranges to filter chart values
156. Use IF + COUNTIF to evaluate multiple conditions
157. Use VLOOKUP and return multiple values sorted from A to Z
159. VLOOKUP – Return multiple unique distinct values
160. Vlookup a cell range and return multiple values
161. VLOOKUP/XLOOKUP of three columns to pull a single record
162. Watch schedule that populates vacation time
163. What values are missing in List 1 that exists i List 2?
164. Wildcard lookups and include or exclude criteria
165. Working with classic ciphers in Excel
166. Working with overlapping date ranges
167. Working with three relational tables
Mathematics
1. How to solve simultaneous linear equations in Excel
MAX function
1. Change chart axis range programmatically
3. Convert date ranges into dates
4. Count overlapping days across multiple date ranges
5. Count overlapping days in multiple date ranges, part 2
6. Create unique distinct list sorted based on text length
7. Extract dates from overlapping date ranges
8. Extract specific word based on position in cell value
9. Extract the most repeated adjacent values in a column
10. Extract unique distinct values sorted based on sum of adjacent values
11. Find and return the highest number and corresponding date based on a condition
12. Find earliest and latest overlapping dates in a set of date ranges based on a condition
13. Find empty dates in a set of date ranges
14. Find min and max unique and duplicate numerical values
15. Find the most recent date that meets a particular condition
16. Find the most/least consecutive repeated value [VBA]
17. Find the smallest number in a list that is larger than a given number
18. Follow stock market trends – trailing stop
19. Fuzzy VLOOKUP
21. Hover with mouse cursor to change stock in a candlestick chart
22. How to calculate and plot pivots on an Excel chart
23. How to count repeating values
24. How to list unique distinct values sorted by frequency
25. How to quickly find the maximum or minimum value [Formula]
26. How to sum overlapping time
28. How to use the MAX function
31. Working with overlapping date ranges
MAXIFS function
Maze
1. Build a maze programmatically in Excel
3. Solve a maze programmatically in Excel
MEDIAN function
1. How to calculate overlapping time ranges
2. How to use the MEDIAN function
3. Units contained in a range that overlap another range
MID function
1. A Comprehensive Guide to Splitting Text in Excel
2. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
3. Count a specific text string in a cell
4. Date and Time Functions – A to M
5. Extract specific word based on position in cell value
6. Find last value in a column
8. How to decode URL-encoded strings
9. How to extract email addresses from an Excel sheet
10. How to extract numbers from a cell value
11. How to remove numbers from a cell value
12. How to return a value if lookup value is in a range
13. How to use the MID function
14. List all permutations with a condition
15. List permutations with repetition and how many to choose from
16. Search for a text string in a data set and return multiple records
17. Working with classic ciphers in Excel
MIN function
1. A beginners guide to Excel array formulas
2. Change chart axis range programmatically
3. Compare two columns in different worksheets
4. Convert date ranges into dates
5. Count overlapping days across multiple date ranges
6. Count overlapping days in multiple date ranges, part 2
7. Extract a list of duplicates from a column
8. Extract dates from overlapping date ranges
9. Extract duplicates from a multi-column cell range
10. Extract the most repeated adjacent values in a column
11. Extract unique distinct values A to Z from a range and ignore blanks
12. Extract unique distinct values from a multi-column cell range
13. Extract unique distinct values sorted from A to Z
14. Filter unique distinct values, sorted and blanks removed from a range
15. Filter unique values from a cell range
16. Filter values in common between two cell ranges
17. Filter values occurring in range 1 but not in range 2
18. Find and return the highest number and corresponding date based on a condition
20. Find earliest and latest overlapping dates in a set of date ranges based on a condition
21. Find empty dates in a set of date ranges
22. Find min and max unique and duplicate numerical values
23. Find numbers closest to sum
24. Find the most recent date that meets a particular condition
25. Find the most/least consecutive repeated value [VBA]
26. Find the smallest number in a list that is larger than a given number
27. Follow stock market trends – trailing stop
28. Hover with mouse cursor to change stock in a candlestick chart
29. How to extract email addresses from an Excel sheet
30. How to highlight duplicate values
31. How to list unique distinct values sorted by frequency
32. How to perform a two-dimensional lookup
33. How to quickly find the maximum or minimum value [Formula]
34. How to sum overlapping time
35. How to use the MIN function
36. How to use VLOOKUP/XLOOKUP with multiple conditions
37. Label groups of duplicate records
39. Lookup with any number of criteria
40. Partial match and return value with highest level
41. Repeat values across cells
42. SMALL function ignore duplicates
43. Sort a range from A to Z [Array formula]
46. Tracking a stock portfolio #2
47. VLOOKUP – Return multiple unique distinct values
48. Working with overlapping date ranges
MINA function
1. How to use the MINA function
MINIFS function
1. Compare two columns in different worksheets
2. Find and return the highest number and corresponding date based on a condition
3. Find the smallest number in a list that is larger than a given number
4. How to use the MINIFS function
6. SMALL function ignore duplicates
MINUTE function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
MINVERSE function
1. How to solve simultaneous linear equations in Excel
2. How to use the MINVERSE function
Misc
1. Convert array formula to a regular formula
3. How to decode URL-encoded strings
Missing values
1. Find empty dates in a set of date ranges
3. What values are missing in List 1 that exists i List 2?
MMULT function
1. 5 easy ways to extract Unique Distinct Values
2. Count cells containing text from list
3. Count identical values if they are on the same row
4. Count overlapping days across multiple date ranges
5. Count overlapping days in multiple date ranges
6. Count overlapping days in multiple date ranges, part 2
8. Count unique distinct values
10. Extract shared values between two columns
11. Extract unique distinct values based on the 4 last characters
12. Filter unique distinct records case sensitive
13. Find earliest and latest overlapping dates in a set of date ranges based on a condition
14. Find numbers closest to sum
15. Get date ranges from a schedule
16. How to extract a case sensitive unique list from a column
17. How to extract numbers from a cell value
18. How to extract rows containing digits [Formula]
19. How to solve simultaneous linear equations in Excel
20. How to sum overlapping time
21. How to use the MMULT function
22. INDEX MATCH with multiple criteria
23. Lookup multiple values in one cell
24. Match two criteria and return multiple records
25. Partial match and return multiple adjacent values
26. Perform multiple partial matches and return records – AND logic
27. Search each column for a string each and return multiple records – OR logic
28. Search for a text string in a data set and return multiple records
29. Sort based on frequency row-wise
30. Wildcard lookups and include or exclude criteria
31. Working with overlapping date ranges
MOD function
MODE function
MODE.MULT function
1. How to use the MODE.MULT function
MODE.SNGL function
1. How to use the MODE.SNGL function
2. Most frequent value between two dates
MONTH function
1. Automate net asset value (NAV) calculation on your stock portfolio
4. Change chart axis range programmatically
6. Count unique distinct values
7. Count unique distinct values that meet multiple criteria
8. Create a drop down calendar
9. Create a quartely date range
10. Create date ranges that stay within month
11. Date and Time Functions – A to M
12. Date and Time Functions – N to Z
13. Excel calendar
14. Get date ranges from a schedule
15. Highlight events in a yearly calendar
16. How to calculate and plot pivots on an Excel chart
17. How to track sector performance in the stock market – Excel template
18. List all unique distinct rows in a given month
19. Lookup and match last value – reverse lookup
22. Plot date ranges in a calendar
23. Remove duplicates within same month or year
MROUND function
1. How to use the MROUND function
MULTINOMIAL function
1. How to use the MULTINOMIAL function
MUNIT function
1. How to use the MUNIT function
N function
NA function
1. Array Manipulation Functions
4. Lookup with any number of criteria
Named range
1. Create a dynamic named range
2. Macro creates links to all sheets, tables, pivot tables and named ranges
3. Populate drop down list with filtered Excel Table values
NETWORKDAYS function
1. Date and Time Functions – N to Z
NETWORKDAYS.INTL function
1. Date and Time Functions – N to Z
NOMINAL function
NORM.DIST function
1. Advanced Excel Chart Techniques
2. How to use the NORM.DIST function
NORM.INV function
1. How to use the NORM.INV function
Normalize data
1. Prepare data for Pivot Table – How to split concatenated values?
NOT function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
3. Create unique distinct list sorted based on text length
4. Extract duplicate values with exceptions
5. Extract unique distinct values from a relational table
6. Extract unique distinct values sorted based on sum of adjacent values
7. Filter unique distinct records
8. Filter values in common between two cell ranges
9. Filter values that exists in all three columns
10. How to use the NOT function
11. If cell contains text from list
12. List all unique distinct rows in a given month
13. Merge two columns with possible blank cells
15. True round-robin tournament
16. Wildcard lookups and include or exclude criteria
NOW function
1. Calculate time between time zones
2. Date and Time Functions – N to Z
NPER function
1. Financial functions – A to PD
OFFSET function
1. Apply drop-down lists dynamically
2. Array Manipulation Functions
3. Calculate machine utilization
4. Change chart axis range programmatically
5. Create dependent drop down lists containing unique distinct values
6. Dependent drop-down lists in multiple rows
7. Extract dates from overlapping date ranges
8. Extract unique distinct values based on a filtered Excel defined Table
9. Extract unique distinct values in a filtered list
11. Highlight duplicates in a filtered Excel Table
12. Highlight unique values in a filtered Excel table
14. How to use the OFFSET function
15. How to use VLOOKUP/XLOOKUP with multiple conditions
16. Plot buy and sell points in an Excel Chart based on two moving averages
17. Populate drop down list with filtered Excel Table values
18. True round-robin tournament
19. Use drop down lists and named ranges to filter chart values
OR function
1. Automate net asset value (NAV) calculation on your stock portfolio
3. How to track sector performance in the stock market – Excel template
6. If cell contains text from list
7. If cell equals value from list
9. Search for a text string in a data set and return multiple records
10. Vlookup a cell range and return multiple values
Overlapping
1. Count overlapping days across multiple date ranges
2. Count overlapping days in multiple date ranges
3. Count overlapping days in multiple date ranges, part 2
4. Filter overlapping date ranges
5. Find earliest and latest overlapping dates in a set of date ranges based on a condition
6. Find empty dates in a set of date ranges
7. Highlight date ranges overlapping selected record [VBA]
8. How to calculate overlapping time ranges
9. How to sum overlapping time
10. Identify overlapping date ranges
11. Identify rows of overlapping records
12. List dates outside specified date ranges
13. Prevent overlapping date and time ranges using data validation
14. Sum numerical ranges between two numbers
15. Units contained in a range that overlap another range
16. Working with overlapping date ranges
Pareto chart
Pathfinding
1. A quicker A * pathfinding algorithm
2. Finding the shortest path – A * pathfinding
1. How to save specific multiple worksheets to a pdf file programmatically
PDURATION function
1. Financial functions – A to PD
PERCENTRANK function
PERCENTRANK.EXC function
1. How to use the PERCENTRANK.EXC function
PERCENTRANK.INC function
1. How to use the PERCENTRANK.INC function
PERMUT function
2. How to use the PERMUT function
3. List all permutations with a condition
4. List permutations with repetition and how many to choose from
PERMUTATIONA function
Permutations
1. Find numbers closest to sum
3. List all permutations with a condition
4. List permutations with repetition and how many to choose from
6. Rotating unique groups with no repeat
PHI function
1. How to use the PHI function
PI function
1. Engineering functions – D to IMC
Pie chart
Pivot table
1. Analyze trends using pivot tables
3. How to create a dynamic pivot table and refresh automatically
4. How to use Pivot Tables – Excel’s most powerful feature and also least known
6. Prepare data for Pivot Table – How to split concatenated values?
PMT function
1. Financial functions – PMT to RATE
POWER function
1. Count overlapping days in multiple date ranges
2. How to use the POWER function
3. Sort based on frequency row-wise
PPMT function
1. Financial functions – PMT to RATE
PRICEMAT function
1. Financial functions – PMT to RATE
1. Create a Print button – macro
2. Print consecutive page numbers across multiple worksheets
3. Print screen the entire worksheet
4. Remove print preview lines (Page Breaks)
PROB function
1. How to use the PROB function
PRODUCT function
1. How to use the asterisk character
2. How to use the PRODUCT function
PV Function
QUARTILE function
QUARTILE.EXC function
1. How to use the QUARTILE.EXC function
QUARTILE.INC function
1. How to use the QUARTILE.INC function
QUOTIENT function
Radar chart
RADIANS function
1. Engineering functions – IMD to Z
2. How to use the RADIANS function
RAND function
1. How to create random numbers, text strings, dates and time values
2. How to generate random numbers and text
3. How to use the RAND function
RANDARRAY function
1. Array Manipulation Functions
2. How to use the RANDARRAY function
4. Working with classic ciphers in Excel
RANDBETWEEN function
1. Assign records unique random text strings
3. How to build a Team Generator – different number of people per team
4. How to create random numbers, text strings, dates and time values
5. How to generate random numbers and text
6. How to use the RANDBETWEEN function
7. Rotating unique groups with no repeat
9. True round-robin tournament
10. Working with classic ciphers in Excel
Random
1. Assign records unique random text strings
3. How to build a Team Generator – different number of people per team
4. How to create random numbers, text strings, dates and time values
5. How to generate a round-robin tournament
7. True round-robin tournament
Range
1. Create numbers based on numerical ranges
Range.Find method
1. How to use the RANGE.FIND method
RANGE.OFFSET property
Rank
1. How to rank text uniquely without duplicates
RANK function
2. Find the most recent date that meets a particular condition
3. How to rank text uniquely without duplicates
RANK.AVG function
1. How to use the RANK.AVG function
RANK.EQ function
1. How to use the RANK.EQ function
RATE function
1. Financial functions – PMT to RATE
Rearrange values
1. Prepare data for Pivot Table – How to split concatenated values?
2. Rearrange values in a cell range to a single column
3. Rearrange values using formulas
4. Resize a range of values (UDF)
Records
1. Compare tables: Filter records occurring only in one table
2. Remove common records between two data sets
3. Unique distinct records sorted based on count or frequency
Recursive
REDUCE function
1. Analyze word frequency in a cell range
2. Convert date ranges into dates
3. Filter strings containing a given substring in a cell range
4. Group rows based on a condition
5. How to use the REDUCE function
7. Working with classic ciphers in Excel
Regular expressions
1. Count matching strings using regular expressions
2. Extract cell references from a formula
3. Fetching values from ThingSpeak programmatically
4. How to use the LIKE OPERATOR
Relational tables
REPLACE function
1. How to use the REPLACE function
REPT function
1. A Comprehensive Guide to Splitting Text in Excel
2. Engineering functions – A to C
3. Extract specific word based on position in cell value
4. How to extract email addresses from an Excel sheet
5. How to use the REPT function
6. Working with classic ciphers in Excel
RIGHT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Date and Time Functions – A to M
3. Extract specific word based on position in cell value
4. Extract unique distinct values based on the 4 last characters
5. Formula for matching a date within a date range
7. How to group items by quarter using formulas
8. How to use the RIGHT function
9. Working with classic ciphers in Excel
ROUND function
2. Engineering functions – IMD to Z
3. How to use the ROUND function
4. Sort items by adjacent number in every other value
5. Sort values by corresponding text arranged in a column
6. Sum numerical ranges between two numbers
ROUNDDOWN function
1. Calculate the number of weeks between given dates
2. Change chart axis range programmatically
3. Hover with mouse cursor to change stock in a candlestick chart
4. How to use the ROUNDDOWN function
5. Rearrange values using formulas
ROUNDUP function
1. Array Manipulation Functions
2. Change chart axis range programmatically
3. Financial functions – A to PD
4. Hover with mouse cursor to change stock in a candlestick chart
5. How to create random numbers, text strings, dates and time values
6. How to use the ROUNDUP function
8. Working with classic ciphers in Excel
ROW function
ROWS 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 two columns and extract differences
6. Compare two columns in different worksheets
7. Convert date ranges into dates
8. Count unique distinct values based on a condition
9. Count unique distinct values that meet multiple criteria
10. Create a drop down calendar
11. Create a quartely date range
12. Create dependent drop down lists containing unique distinct values
14. Create numbers based on numerical ranges
15. Date and Time Functions – A to M
16. Date and Time Functions – N to Z
17. Dependent drop-down lists in multiple rows
19. Engineering functions – D to IMC
20. Extract a list of alphabetically sorted duplicates based on a condition
21. Extract a list of duplicates from a column
22. Extract a list of duplicates from three columns combined
23. Extract all rows from a range that meet criteria in one column
24. Extract dates from overlapping date ranges
25. Extract duplicate values with exceptions
26. Extract numbers from a column
27. Extract shared values between two columns
28. Extract the most repeated adjacent values in a column
29. Extract unique distinct values in a filtered list
30. Filter duplicate values based on criteria
31. Filter unique distinct records case sensitive
32. Filter unique values sorted from A to Z
33. Find all sequences of consecutive dates
34. Find empty dates in a set of date ranges
35. Find empty hours in a weekly schedule
37. Find numbers closest to sum
38. Find the most recent date that meets a particular condition
39. Follow stock market trends – Moving Average
40. Get date ranges from a schedule
41. How to compare two data sets
42. How to copy non contiguous cell ranges
43. How to create date ranges in Excel
44. How to decode URL-encoded strings
45. How to extract a case sensitive unique list from a column
46. How to extract rows containing digits [Formula]
47. How to ignore zeros using the SMALL function
48. How to replace part of formula in all cells
49. How to return a value if lookup value is in a range
50. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
52. How to use the MAKEARRAY function
53. How to use the ROWS function
54. How to use VLOOKUP/XLOOKUP with multiple conditions
55. INDEX MATCH – multiple results
56. INDEX MATCH with multiple criteria
57. Lookup and return multiple sorted values based on corresponding values in another column
58. Match two criteria and return multiple records
59. Merge cell ranges into one list
60. Multiply numbers in each row by entire cell range
61. Partial match and return multiple adjacent values
62. Partial match for multiple strings – AND logic
63. Partial match with two conditions and return multiple results
64. Perform multiple partial matches and return records – AND logic
65. Populate drop down list with filtered Excel Table values
66. Rearrange values in a cell range to a single column
67. Rearrange values using formulas
68. Remove duplicates within same month or year
69. Reverse a list ignoring blanks
70. Search each column for a string each and return multiple records – OR logic
71. Search for a sequence of values
72. Search for a text string in a data set and return multiple records
73. Search related table based on a date and date range
74. Shift Schedule
75. SMALL function – INDEX MATCH
76. SMALL function – multiple conditions
78. SMALL function ignore duplicates
79. Sort a column alphabetically
80. Sort a range from A to Z [Array formula]
81. Sort based on frequency row-wise
83. Sort rows based on frequency and criteria
84. Sort text cells alphabetically from two columns
85. Sort values by corresponding text arranged in a column
86. Split values equally into groups
87. Team Generator
88. True round-robin tournament
89. Use VLOOKUP and return multiple values sorted from A to Z
90. What values are missing in List 1 that exists i List 2?
RRI function
1. Financial functions – PMT to RATE
2. How to use the RRI function
SCAN function
1. How to use the SCAN function
2. Working with classic ciphers in Excel
SCATTER (x y) chart
1. Add pictures to a chart axis
2. Advanced Excel Chart Techniques
3. Highlight group of values in an x y scatter chart programmatically
4. How to add horizontal line to chart
5. How to build an interactive map in Excel
6. How to improve your Excel Chart
Schedule
1. Find empty hours in a weekly schedule
2. Get date ranges from a schedule
3. Populate cells dynamically in a weekly schedule
5. Watch schedule that populates vacation time
Scroll bar
Search and return multiple values
1. Distribute values across numerical ranges
3. Partial match and return multiple adjacent values
4. Partial match and return value with highest level
5. Partial match for multiple strings – AND logic
6. Partial match with two conditions and return multiple results
7. Perform multiple partial matches and return records – AND logic
8. Search each column for a string each and return multiple records – OR logic
9. Wildcard lookups and include or exclude criteria
SEARCH function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Count cells containing text from list
4. Extract duplicates from a multi-column cell range
5. Extract specific word based on position in cell value
6. Extract unique distinct values if the value contains the given string
7. Filter strings containing a given substring in a cell range
8. Filter unique distinct records
9. Find last value in a column
10. Fuzzy VLOOKUP
11. How to extract email addresses from an Excel sheet
12. How to extract numbers from a cell value
13. How to extract rows containing digits [Formula]
14. How to use the SEARCH function
15. If cell contains multiple values
17. INDEX MATCH with multiple criteria
18. Lookup and return multiple values concatenated into one cell
19. Match two columns and return another value on the same row
20. Match two criteria and return multiple records
21. Partial match and return multiple adjacent values
22. Partial match and return value with highest level
23. Partial match for multiple strings – AND logic
24. Partial match with two conditions and return multiple results
25. Perform multiple partial matches and return records – AND logic
26. Search each column for a string each and return multiple records – OR logic
27. Search for a text string in a data set and return multiple records
28. Split search value using a delimiter and search for each substring
29. VLOOKUP – Return multiple unique distinct values
30. Wildcard lookups and include or exclude criteria
31. Working with classic ciphers in Excel
SEC function
1. How to use the SEC function
SECH function
1. How to use the SECH function
SECOND function
1. Date and Time Functions – N to Z
SELECT CASE statement
Sequence
2. Extract the most repeated adjacent values in a column
3. Find the most/least consecutive repeated value [VBA]
5. Search for a sequence of cells based on wildcard search
6. Search for a sequence of values
SEQUENCE function
1. 5 easy ways to extract Unique Distinct 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 two columns and extract differences
6. Convert date ranges into dates
7. Count overlapping days in multiple date ranges
8. Date and Time Functions – A to M
9. Date and Time Functions – N to Z
10. Extract dates from overlapping date ranges
11. Extract the most repeated adjacent values in a column
12. Extract unique distinct values in a filtered list
13. Financial functions – A to PD
14. Find empty dates in a set of date ranges
16. Find numbers closest to sum
17. Fuzzy VLOOKUP
18. Get date ranges from a schedule
19. How to calculate overlapping time ranges
20. How to copy non contiguous cell ranges
21. How to decode URL-encoded strings
22. How to extract numbers from a cell value
23. How to extract rows containing digits [Formula]
24. How to remove numbers from a cell value
25. How to use the SEQUENCE function
26. How to use VLOOKUP/XLOOKUP with multiple conditions
27. List all permutations with a condition
28. List dates outside specified date ranges
29. List permutations with repetition and how many to choose from
30. Rearrange values using formulas
31. Reverse a list ignoring blanks
32. Sort items by adjacent number in every other value
33. Sort values by corresponding text arranged in a column
35. Sum numerical ranges between two numbers
36. Team Generator
37. Working with classic ciphers in Excel
SERIESSUM function
1. How to use the SERIESSUM function
SET statement
SGN function
SHEET function
1. How to use the SHEET function
SHEETS function
1. How to use the SHEETS function
SIGN function
1. Count a specific text string in a cell
2. How to use the SIGN function
SIN function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
3. How to use the SIN function
SINH function
1. How to use the SINH function
SKEW function
1. How to use the SKEW function
SLOPE function
1. How to use the SLOPE function
Small
1. Find the smallest number in a list that is larger than a given number
2. How to ignore zeros using the SMALL function
3. SMALL function – INDEX MATCH
4. SMALL function – multiple conditions
6. SMALL function ignore duplicates
SMALL 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
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare two columns and extract differences
8. Compare two columns in different worksheets
9. Convert array formula to a regular formula
10. Convert date ranges into dates
11. Count a specific text string in a cell
12. Count cells between specified values
13. Create a drop down calendar
14. Create dependent drop down lists containing unique distinct values
15. Create numbers based on numerical ranges
16. Date and Time Functions – N to Z
17. Dependent drop-down lists in multiple rows
18. Distribute values across numerical ranges
19. Excel calendar
20. Extract a list of alphabetically sorted duplicates based on a condition
21. Extract a list of duplicates from a column
22. Extract a unique distinct list sorted from A to Z
23. Extract a unique distinct list sorted from A to Z ignore blanks
24. Extract all rows from a range that meet criteria in one column
25. Extract dates from overlapping date ranges
26. Extract numbers from a column
27. Extract records between two dates
28. Extract shared values between two columns
29. Extract the most repeated adjacent values in a column
30. Extract unique distinct values A to Z from a range and ignore blanks
31. Extract unique distinct values from a relational table
32. Extract unique distinct values sorted from A to Z
33. Filter duplicate values based on criteria
34. Filter duplicates within same date, week or month
35. Filter overlapping date ranges
36. Filter unique distinct values, sorted and blanks removed from a range
37. Filter unique values sorted from A to Z
38. Find all sequences of consecutive dates
40. Find empty dates in a set of date ranges
41. Find empty hours in a weekly schedule
43. Find the most recent date that meets a particular condition
44. Find the smallest number in a list that is larger than a given number
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. Group rows based on a condition
50. How to compare two data sets
51. How to create date ranges in Excel
52. How to extract a case sensitive unique list from a column
53. How to extract rows containing digits [Formula]
54. How to group items by quarter using formulas
55. How to ignore zeros using the SMALL function
56. How to perform a two-dimensional lookup
57. How to replace part of formula in all cells
58. How to return a value if lookup value is in a range
59. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
61. How to use the SMALL function
62. How to use VLOOKUP/XLOOKUP with multiple conditions
63. Identify rows of overlapping records
64. If cell contains text from list
65. INDEX MATCH – multiple results
66. INDEX MATCH with multiple criteria
67. List all unique distinct rows in a given month
68. List dates outside specified date ranges
69. Lookup and return multiple sorted values based on corresponding values in another column
70. Lookup multiple values across columns and return a single value
72. Lookup with any number of criteria
73. Lookups in relational tables
74. Match two criteria and return multiple records
75. Merge two columns with possible blank cells
76. Partial match and return multiple adjacent values
77. Partial match for multiple strings – AND logic
78. Partial match with two conditions and return multiple results
79. Perform multiple partial matches and return records – AND logic
80. Plot date ranges in a calendar
81. Populate drop down list with filtered Excel Table values
82. Populate drop down list with unique distinct values sorted from A to Z
83. Remove common records between two data sets
84. Remove duplicates within same month or year
85. Search each column for a string each and return multiple records – OR logic
86. Search for a sequence of cells based on wildcard search
87. Search for a sequence of values
88. Search for a text string in a data set and return multiple records
89. Search related table based on a date and date range
90. Shift Schedule
91. SMALL function – INDEX MATCH
92. SMALL function – multiple conditions
94. SMALL function ignore duplicates
95. Sort a column alphabetically
96. Sort a range from A to Z [Array formula]
97. Sort values by corresponding text arranged in a column
99. True round-robin tournament
100. Use a drop down list to filter and concatenate unique distinct values
101. Use a drop down list to search and return multiple values
102. Use VLOOKUP and return multiple values sorted from A to Z
103. Vlookup a cell range and return multiple values
104. Vlookup across multiple sheets
105. Vlookup with multiple matches returns a different value
106. Watch schedule that populates vacation time
107. What values are missing in List 1 that exists i List 2?
108. Wildcard lookups and include or exclude criteria
110. Working with three relational tables
Solver
2. How to solve simultaneous linear equations in Excel
3. How to use the COMBIN function
4. Identify numbers in sum using Excel solver
SORT function
1. Compare two columns in different worksheets
2. Convert date ranges into dates
3. Engineering functions – A to C
4. Extract a list of alphabetically sorted duplicates based on a condition
5. Extract a list of duplicates from a column
6. Extract a unique distinct list sorted from A to Z
7. Extract a unique distinct list sorted from A to Z ignore blanks
8. Extract unique distinct values A to Z from a range and ignore blanks
9. Filter unique values sorted from A to Z
10. Find all sequences of consecutive dates
11. Fuzzy lookups
12. Fuzzy VLOOKUP
13. How to extract numbers from a cell value
14. How to ignore zeros using the SMALL function
15. How to use the SORT function
16. SMALL function – INDEX MATCH
17. Sort a column alphabetically
18. Sort rows based on frequency and criteria
19. Sort values by corresponding text arranged in a column
20. Sort values in a cell based on a delimiting character
21. Use VLOOKUP and return multiple values sorted from A to Z
22. Working with classic ciphers in Excel
24. Working with unique values
Sort values
1. Distribute values across numerical ranges
2. Extract a unique distinct list sorted from A to Z ignore blanks
3. Filter unique values sorted from A to Z
4. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
5. Lookup and return multiple sorted values based on corresponding values in another column
6. Reverse a list ignoring blanks
7. Sort a column alphabetically
8. Sort a range from A to Z [Array formula]
9. Sort column based on frequency
10. Sort items by adjacent number in every other value
11. Sort text cells alphabetically from two columns
12. Sort values by corresponding text arranged in a column
13. Sort values in a cell based on a delimiting character
SORTBY function
1. Array Manipulation Functions
3. Extract unique distinct values sorted based on sum of adjacent values
5. How to list unique distinct values sorted by frequency
6. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
7. How to use the SORTBY function
8. Lookup and return multiple sorted values based on corresponding values in another column
10. Sort a column alphabetically
11. Sort based on frequency row-wise
13. Sort column based on frequency
14. Sort items by adjacent number in every other value
15. Team Generator
16. Unique distinct records sorted based on count or frequency
17. Working with classic ciphers in Excel
Sparkline
SPLIT function
Split values
1. A Comprehensive Guide to Splitting Text in Excel
2. How to group items by quarter using formulas
3. Split data across multiple sheets – VBA
5. Split values equally into groups
SQRT function
1. How to use the SQRT function
STACKED COLUMN chart
STANDARDIZE function
1. How to use the STANDARDIZE function
Statistical
1. How to use the INTERCEPT function
STDEV function
STDEV.P
1. How to use the STDEV.P function
STDEV.S function
1. How to use the STDEV.S function
STDEVA function
1. How to use the STDEVA function
STDEVPA function
1. How to use the STDEVPA function
stock chart
1. Change chart axis range programmatically
Stock market trend
1. Add buy and sell points to a stock chart
2. Follow stock market trends – Moving Average
3. Follow stock market trends – trailing stop
4. How to calculate and plot pivots on an Excel chart
5. Plot buy and sell points in an Excel Chart based on two moving averages
Stock portfolio
1. All you need to know about calculating NAV units for your stock portfolio
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
STOCKHISTORY function
2. How to use the STOCKHISTORY function
SUBSTITUTE function
1. A Comprehensive Guide to Splitting Text in Excel
2. Analyze word frequency in a cell range
3. Count a specific text string in a cell
4. Count specific multiple text strings in a given cell range
5. Date and Time Functions – A to M
6. Extract specific word based on position in cell value
8. How to count the number of values separated by a delimiter
9. How to extract email addresses from an Excel sheet
10. How to replace part of formula in all cells
11. How to use the SUBSTITUTE function
12. Partial match and return multiple adjacent values
13. Split search value using a delimiter and search for each substring
14. Working with classic ciphers in Excel
Substitute Replace
SUBTOTAL function
1. Count cells based on background color
2. Count Conditionally Formatted cells
3. Count unique distinct values in a filtered Excel defined Table
4. Extract unique distinct values based on a filtered Excel defined Table
5. Extract unique distinct values in a filtered list
6. Filter duplicate values based on criteria
7. Highlight duplicates in a filtered Excel Table
8. Highlight unique values in a filtered Excel table
9. How to use the SUBTOTAL function
10. How to use the Subtotal tool
11. How to use VLOOKUP/XLOOKUP with multiple conditions
12. Most frequent value between two dates
13. Populate drop down list with filtered Excel Table values
Sum
2. How to create running totals
3. How to do tiered calculations in one formula
4. Running totals based on criteria
5. Sum numerical ranges between two numbers
SUM function
1. Analyze word frequency in a cell range
2. Automate net asset value (NAV) calculation on your stock portfolio
4. Count a specific text string in a cell
5. Count cells containing text from list
7. Count groups of repeated values per row
8. Count identical values if they are on the same row
9. Count overlapping days across multiple date ranges
10. Count overlapping days in multiple date ranges
11. Count specific multiple text strings in a given cell range
12. Count unique distinct records
13. Count unique distinct values
14. Count unique distinct values based on a condition
15. Count unique distinct values in a filtered Excel defined Table
16. Count unique distinct values that meet multiple criteria
17. Create unique distinct list sorted based on text length
18. Excel calendar
20. Filter strings containing a given substring in a cell range
21. Filter unique distinct records case sensitive
22. Financial functions – PMT to RATE
23. Get date ranges from a schedule
24. Highlight duplicates in a filtered Excel Table
25. Highlight unique values in a filtered Excel table
26. How to build a Team Generator – different number of people per team
27. How to calculate overlapping time ranges
28. How to count the number of values separated by a delimiter
29. How to create running totals
30. How to sum overlapping time
32. How to use the asterisk character
33. How to use the SUM function
34. Identify numbers in sum using Excel solver
36. Label groups of duplicate records
37. List all permutations with a condition
38. Lookup with any number of criteria
39. Lookups in relational tables
40. Rotating unique groups with no repeat
41. Search for a text string in a data set and return multiple records
42. Sort a column alphabetically
44. Sum numerical ranges between two numbers
46. Vlookup a cell range and return multiple values
47. Working with classic ciphers in Excel
48. Working with three relational tables
SUMIF function
1. Extract unique distinct values sorted based on sum of adjacent values
2. How to create running totals
3. How to use the SUMIF function
4. Lookups in relational tables
SUMIFS function
2. Extract a unique distinct list and sum amounts based on a condition
3. How to use the SUMIFS function
4. Running totals based on criteria
SUMPRODUCT
1. How to use the COUNTIF function to count not blank cells
2. SUMPRODUCT – multiple criteria
4. SUMPRODUCT and nested IF functions
SUMPRODUCT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Automate net asset value (NAV) calculation on your stock portfolio
4. Calculate machine utilization
5. Compare the performance of your stock portfolio to S&P 500 using Excel
6. Count a specific text string in a cell
7. Count cells containing text from list
9. Count groups of repeated values per row
10. Count identical values if they are on the same row
11. Count rows containing data
12. Count unique distinct records
13. Count unique distinct values
14. Create a quartely date range
17. Date and Time Functions – N to Z
18. Dependent drop-down lists in multiple rows
19. Excel calendar
20. Extract a unique distinct list and sum amounts based on a condition
21. Find empty hours in a weekly schedule
22. Find the most recent date that meets a particular condition
23. Formula for matching a date within a date range
24. How to calculate overlapping time ranges
25. How to create date ranges in Excel
26. How to create running totals
27. How to do tiered calculations in one formula
28. How to quickly find the maximum or minimum value [Formula]
29. How to rank text uniquely without duplicates
30. How to return a value if lookup value is in a range
31. How to use the COUNTIF function to count not blank cells
32. How to use the SUMPRODUCT function
33. Identify numbers in sum using Excel solver
34. Identify overlapping date ranges
35. If cell contains multiple values
36. List all permutations with a condition
37. Plot date ranges in a calendar
38. Prevent overlapping date and time ranges using data validation
39. Running totals based on criteria
40. Sort rows based on frequency and criteria
41. Sum numerical ranges between two numbers
43. SUMPRODUCT – multiple criteria
44. SUMPRODUCT and IF function
45. SUMPRODUCT and nested IF functions
47. Team Generator
48. Tracking a stock portfolio #2
49. True round-robin tournament
50. Working with overlapping date ranges
SUMSQ function
1. How to use the SUMSQ function
SUMX2MY2 function
1. How to use the SUMX2MY2 function
SUMX2PY2 function
1. How to use the SUMX2PY2 function
SUMXMY2 function
1. How to use the SUMXMY2 function
Sunburst chart
Surface chart
SWITCH function
1. Calculate the number of weeks between given dates
3. How to use the SWITCH function
SYD function
1. How to use the SYD function
T function
TAKE function
1. Array Manipulation Functions
TAN function
1. How to use the TAN function
TANH function
1. How to use the TANH function
TBILLEQ function
1. How to use the TBILLEQ function
TBILLPRICE function
1. How to use the TBILLPRICE function
TBILLYIELD function
1. How to use the TBILLYIELD function
Team generator
1. How to build a Team Generator – different number of people per team
Templates
2. Excel template: Getting Things Done [VBA]
3. Highlight events in a yearly calendar
5. Multi-level To-Do list template
Text boxes
1. Working with TEXT BOXES [Form Controls]
TEXT function
1. Add buy and sell points to a stock chart
2. Create a quartely date range
4. Date and Time Functions – A to M
5. Date and Time Functions – N to Z
6. How to calculate and plot pivots on an Excel chart
7. How to create date ranges in Excel
8. How to create running totals
9. How to extract numbers from a cell value
10. How to remove numbers from a cell value
11. How to use the TEXT function
12. Lookup and return multiple values concatenated into one cell
14. Working with classic ciphers in Excel
Text string manipulation
1. How to replace part of formula in all cells
Text string manipultion
1. How to remove numbers from a cell value
2. How to replace part of formula in all cells
TEXTAFTER function
1. A Comprehensive Guide to Splitting Text in Excel
2. How to use the TEXTAFTER function
TEXTBEFORE function
1. How to use the TEXTBEFORE function
TEXTJOIN function
TEXTSPLIT function
1. A Comprehensive Guide to Splitting Text in Excel
2. Analyze word frequency in a cell range
3. Array Manipulation Functions
4. Engineering functions – A to C
5. Extract specific word based on position in cell value
6. Filter strings containing a given substring in a cell range
7. Filter unique strings from a cell range
8. How to decode URL-encoded strings
9. How to extract email addresses from an Excel sheet
10. How to use the TEXTSPLIT function
11. If cell contains text from list
12. Lookup multiple values in one cell
13. Rearrange data
14. Sort values in a cell based on a delimiting character
15. Split search value using a delimiter and search for each substring
TextToColumns method
1. How to use the TEXTTOCOLUMNS method
Time
2. How to calculate overlapping time ranges
TIME function
1. Calculate time between time zones
2. Date and Time Functions – N to Z
3. Find empty hours in a weekly schedule
TIMEVALUE function
1. Date and Time Functions – N to Z
TOCOL function
1. Analyze word frequency in a cell range
2. Array Manipulation Functions
3. Convert date ranges into dates
4. Count unique distinct values
5. Extract a list of duplicates from three columns combined
6. Extract a unique distinct list from three columns
7. Extract a unique distinct list from two columns
8. Extract duplicates from a multi-column cell range
9. Extract unique distinct values A to Z from a range and ignore blanks
10. Extract unique distinct values from a multi-column cell range
11. Filter values in common between two cell ranges
12. Filter values occurring in range 1 but not in range 2
13. Find empty hours in a weekly schedule
14. Get date ranges from a schedule
15. How to extract email addresses from an Excel sheet
16. How to list unique distinct values sorted by frequency
17. List dates outside specified date ranges
18. Rearrange values in a cell range to a single column
19. VLOOKUP – Return multiple unique distinct values
20. Vlookup a cell range and return multiple values
21. Working with classic ciphers in Excel
TODAY function
2. Date and Time Functions – A to M
3. Date and Time Functions – N to Z
5. How to track sector performance in the stock market – Excel template
Top/Bottom Rules
TOROW function
1. Array Manipulation Functions
2. Rearrange values in a cell range to a single column
Tournament
1. How to generate a round-robin tournament
2. True round-robin tournament
TRANSPOSE function
Treemap chart
TREND function
1. How to use the TREND function
TRIM function
TRIMMEAN function
1. How to use the TRIMMEAN function
TRUE function
1. 5 easy ways to extract Unique Distinct Values
2. A Comprehensive Guide to Splitting Text in Excel
3. Array Manipulation Functions
4. Automate net asset value (NAV) calculation on your stock portfolio
5. Calculate the number of weeks between given dates
6. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
8. Concatenate unique distinct values
10. Extract a list of duplicates from a column
11. Extract duplicates from a multi-column cell range
12. Extract specific word based on position in cell value
13. Filter unique distinct values, sorted and blanks removed from a range
14. Filter unique strings from a cell range
15. Filter unique values from a cell range
16. Filter unique values sorted from A to Z
17. Filter values in common between two cell ranges
18. Filter values occurring in range 1 but not in range 2
19. Find min and max unique and duplicate numerical values
20. Formula for matching a date within a date range
21. How to decode URL-encoded strings
22. How to extract email addresses from an Excel sheet
23. How to extract numbers from a cell value
24. How to list unique distinct values sorted by frequency
25. How to perform a two-dimensional lookup
26. How to remove numbers from a cell value
27. How to return a value if lookup value is in a range
28. How to use mouse hover on a worksheet [VBA]
29. How to use nested IF functions
30. How to use the TRUE function
31. How to use VLOOKUP/XLOOKUP with multiple conditions
32. Identify rows of overlapping records
34. If cell contains text from list
35. IF function with AND function – multiple conditions
36. INDEX MATCH – Case sensitive
37. INDEX MATCH – multiple results
38. Lookup and return multiple values concatenated into one cell
39. Lookup multiple values across columns and return a single value
40. Lookup multiple values in one cell
41. Match two columns and return another value on the same row
42. Partial match for multiple strings – AND logic
43. Populate cells dynamically in a weekly schedule
44. Rearrange data
45. Rearrange values in a cell range to a single column
46. Search for a sequence of cells based on wildcard search
47. Search for a text string in a data set and return multiple records
48. Split search value using a delimiter and search for each substring
50. SUMPRODUCT and IF function
52. VLOOKUP – Return multiple unique distinct values
53. Vlookup a cell range and return multiple values
54. Working with classic ciphers in Excel
TRUNC function
1. How to use the TRUNC function
Two-dimensional lookup
1. Get date ranges from a schedule
2. How to perform a two-dimensional lookup
TYPE function
1. How to use the TYPE function
UNICHAR function
1. How to use the UNICHAR function
UNICODE function
1. How to use the UNICODE function
Unique distinct records
1. Filter unique distinct records
2. Filter unique distinct records case sensitive
3. Unique distinct records sorted based on count or frequency
Unique distinct values
1. 5 easy ways to extract Unique Distinct Values
2. Assign records unique random text strings
3. Create unique distinct list sorted based on text length
4. Extract a unique distinct list and ignore blanks
5. Extract a unique distinct list and sum amounts based on a condition
6. Extract a unique distinct list from three columns
7. Extract a unique distinct list from two columns
8. Extract a unique distinct list sorted from A to Z
9. Extract unique distinct values A to Z from a range and ignore blanks
10. Extract unique distinct values based on the 4 last characters
11. Extract unique distinct values from a multi-column cell range
12. Extract unique distinct values if the value contains the given string
13. Extract unique distinct values in a filtered list
14. Extract unique distinct values sorted based on sum of adjacent values
15. Extract unique distinct values sorted from A to Z
16. Filter unique distinct values based on a date range
17. Filter unique distinct values, sorted and blanks removed from a range
18. List all unique distinct rows in a given month
19. Remove duplicates within same month or year
20. VLOOKUP – Return multiple unique distinct values
UNIQUE function
1. 5 easy ways to extract Unique Distinct Values
2. Analyze word frequency in a cell range
3. Array Manipulation Functions
5. Convert date ranges into dates
6. Count unique distinct values
7. Count unique distinct values based on a condition
8. Count unique distinct values that meet multiple criteria
9. Create dependent drop down lists containing unique distinct values
10. Distribute values across numerical ranges
11. Engineering functions – A to C
12. Extract a list of duplicates from a column
13. Extract a list of duplicates from three columns combined
14. Extract a unique distinct list and ignore blanks
15. Extract a unique distinct list from three columns
16. Extract a unique distinct list from two columns
17. Extract a unique distinct list sorted from A to Z
18. Extract a unique distinct list sorted from A to Z ignore blanks
19. Extract duplicate values with exceptions
20. Extract duplicates from a multi-column cell range
21. Extract unique distinct values A to Z from a range and ignore blanks
22. Extract unique distinct values from a multi-column cell range
23. Extract unique distinct values in a filtered list
24. Extract unique distinct values sorted based on sum of adjacent values
25. Filter strings containing a given substring in a cell range
26. Filter unique distinct records
27. Filter unique distinct values based on a date range
28. Filter unique strings from a cell range
29. Filter unique values sorted from A to Z
30. Filter values in common between two cell ranges
31. Filter values occurring in range 1 but not in range 2
32. Find min and max unique and duplicate numerical values
33. Group rows based on a condition
34. How to automatically add new items to a drop down list
35. How to extract numbers from a cell value
36. How to list unique distinct values sorted by frequency
37. How to use the UNIQUE function
38. Lookup and return multiple values concatenated into one cell
39. SMALL function ignore duplicates
40. Sort column based on frequency
41. Sort rows based on frequency and criteria
44. Unique distinct records sorted based on count or frequency
45. VLOOKUP – Return multiple unique distinct values
46. Working with classic ciphers in Excel
47. Working with unique values
Unique values
1. 5 easy ways to extract Unique Distinct Values
2. Create numbers based on numerical ranges
3. Filter unique strings from a cell range
4. Filter unique values from a cell range
5. Filter unique values sorted from A to Z
6. Find min and max unique and duplicate numerical values
7. How to extract a case sensitive unique list from a column
8. List all unique distinct rows in a given month
UPPER function
1. Count a specific text string in a cell
2. Count specific multiple text strings in a given cell range
4. How to use the UPPER function
5. Working with classic ciphers in Excel
User Defined Function
1. Analyze word frequency in a cell range
2. Count unique distinct values by cell color
3. Extract unique distinct values in a filtered list
4. Filter unique strings from a cell range
5. How to count the number of values separated by a delimiter
6. How to save custom functions and macros to an Add-In
7. Lookup multiple values in one cell
9. Search for a file in folder and subfolders [UDF]
10. Split search value using a delimiter and search for each substring
11. Split values equally into groups
12. Two-way lookup in multiple cross reference tables simultaneously
VALUE function
1. How to use the VALUE function
VALUETOTEXT function
1. How to use the VALUETOTEXT function
VAR.P function
1. How to use the VAR.P function
VAR.S function
1. How to use the VAR.S function
VBA
1. A beginners guide to Excel array formulas
2. Add checkboxes and copy values – VBA
3. Add or remove a value in a drop down list programmatically
4. Add values to a regular drop-down list programmatically
5. Add values to a two-dimensional table based on conditions [VBA]
6. Analyze word frequency in a cell range
7. Apply dependent combo box selections to a filter
8. Apply drop-down lists dynamically
9. Auto resize columns as you type
11. Compare file names in two different folder locations and their sub folders
12. Copy a dynamic cell range [VBA]
13. Copy data from workbooks in folder and subfolders
14. Copy worksheets in active workbook to new workbooks
15. Count matching strings using regular expressions
16. Count text string in all formulas in a worksheet [VBA]
17. Count unique distinct values by cell color
18. Create a Print button – macro
19. Create links to all sheets in a workbook programmatically
20. Create new worksheets programmatically based on values in a cell range [VBA]
22. Customize the ribbon and how to add your macros
23. Excel calendar
24. Excel template: Getting Things Done [VBA]
26. Extract cell references from a formula
27. Extract cell references populated with values [VBA]
28. Extract unique distinct values in a filtered list
29. Fetching values from ThingSpeak programmatically
30. Filter duplicate files in a folder and subfolders
31. Filter unique strings from a cell range
32. Find and replace strings in file names, folder name and subfolders
33. Find cells containing formulas with literal (hardcoded) values
35. Find the most/least consecutive repeated value [VBA]
36. Hide specific worksheets programmatically
37. Highlight date ranges overlapping selected record [VBA]
38. How to change a picture in a worksheet dynamically [VBA]
39. How to copy non contiguous cell ranges
40. How to count the number of values separated by a delimiter
41. How to create an interactive Excel chart [VBA]
42. How to highlight row of the selected cell programmatically
43. How to save custom functions and macros to an Add-In
44. How to save specific multiple worksheets to a pdf file programmatically
46. How to use the DO LOOP statement
47. How to use the FOR NEXT statement
48. How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
49. How to use the LIKE OPERATOR
50. How to use the RANGE.FIND method
52. How to use the TEXTTOCOLUMNS method
53. List all hyperlinks in worksheet programmatically
54. List files in folder and create hyperlinks (VBA)
55. Locate a shape in a workbook
56. Lookup multiple values in one cell
59. Multi-level To-Do list template
60. Multiply numbers in each row by entire cell range
61. Open Excel files in a folder [VBA]
62. Prepare data for Pivot Table – How to split concatenated values?
63. Print consecutive page numbers across multiple worksheets
64. Print screen the entire worksheet
65. Rearrange data
66. Remove print preview lines (Page Breaks)
67. Resize a range of values (UDF)
68. Run a Macro from a Drop Down list [VBA]
70. Search all workbooks in a folder
71. Search all workbooks in a folder and sub folders – VBA
72. Search for a file in folder and subfolders [UDF]
73. Show / hide a picture using a button
74. Sort values in a cell based on a delimiting character
75. Split data across multiple sheets – VBA
76. Split search value using a delimiter and search for each substring
77. Split values equally into groups
78. Toggle a macro on/off using a button
79. Working with ARRAY VARIABLES (VBA)
80. Working with COMBO BOXES [Form Controls]
81. Working with comments – VBA
82. Working with Excel tables programmatically
84. Working with LIST BOXES (Form Controls)
85. Working with TEXT BOXES [Form Controls]
VDB function
1. How to use the VDB function
VLOOKUP
1. How to use VLOOKUP/XLOOKUP with multiple conditions
3. VLOOKUP/XLOOKUP of three columns to pull a single record
VLOOKUP and return multiple values
1. 5 easy ways to VLOOKUP and return multiple values
2. Use a drop down list to search and return multiple values
3. Use VLOOKUP and return multiple values sorted from A to Z
4. Vlookup a cell range and return multiple values
5. Vlookup across multiple sheets
6. Vlookup with multiple matches returns a different value
VLOOKUP function
1. Formula for matching a date within a date range
2. How to return a value if lookup value is in a range
3. How to use nested IF functions
4. How to use the asterisk character
5. How to use the VLOOKUP function
6. How to use VLOOKUP/XLOOKUP with multiple conditions
7. Merge tables based on a condition
9. VLOOKUP/XLOOKUP of three columns to pull a single record
VSTACK function
1. Analyze word frequency in a cell range
2. Array Manipulation Functions
3. Compare two columns and extract differences
4. Convert date ranges into dates
5. Extract a list of duplicates from a column
6. Filter strings containing a given substring in a cell range
7. Filter unique distinct records
8. Filter unique distinct records case sensitive
10. Find the most recent date that meets a particular condition
11. Group rows based on a condition
12. Merge cell ranges into one list
13. Merge two columns with possible blank cells
14. Multiply numbers in each row by entire cell range
15. Working with classic ciphers in Excel
16. Working with unique values
Waterfall chart
WEBSERVICE function
1. How to use the WEBSERVICE function
WEEKDAY function
1. Calculate machine utilization
3. Create date ranges that stay within month
4. Date and Time Functions – N to Z
6. How to track sector performance in the stock market – Excel template
9. Populate cells dynamically in a weekly schedule
WEEKNUM function
1. Count unique distinct values
2. Date and Time Functions – N to Z
3. Filter duplicates within same date, week or month
Wildcard Search
Win/loss
WITH ... END WITH Statement
2. Extract cell references from a formula
3. How to highlight row of the selected cell programmatically
WORKDAY function
1. Date and Time Functions – N to Z
2. How to track sector performance in the stock market – Excel template
Worksheet
1. Hide specific worksheets programmatically
2. List all hyperlinks in worksheet programmatically
WRAPCOLS function
1. Array Manipulation Functions
WRAPROWS function
1. Array Manipulation Functions
2. How to use the WRAPROWS function
XLOOKUP
1. How to use VLOOKUP/XLOOKUP with multiple conditions
XLOOKUP function
1. How to use the XLOOKUP function
2. How to use VLOOKUP/XLOOKUP with multiple conditions
3. VLOOKUP/XLOOKUP of three columns to pull a single record
XMATCH function
1. How to use the XMATCH function
XNPV function
1. How to use the XNPV function
XOR function
1. How to use the XOR function
YEAR function
1. Add buy and sell points to a stock chart
2. Automate net asset value (NAV) calculation on your stock portfolio
4. Change chart axis range programmatically
6. Count unique distinct values
7. Create a quartely date range
8. Create date ranges that stay within month
10. Date and Time Functions – A to M
11. Date and Time Functions – N to Z
12. Filter duplicates within same date, week or month
13. How to calculate and plot pivots on an Excel chart
14. How to track sector performance in the stock market – Excel template
15. List all unique distinct rows in a given month
16. Lookup and match last value – reverse lookup
18. Remove duplicates within same month or year
19. Yet another Excel Calendar
YEARFRAC function
1. Date and Time Functions – N to Z
YIELD function
Comments Off on Excel formula examples
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form