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
5. Find numbers closest to sum
6. How to create date ranges in Excel
7. How to use the ABS function
8. How to use the asterisk character
9. Identify numbers in sum using Excel solver
ACCRINT function
1. How to use the ACCRINT function
ACCRINTM function
1. How to use the ACCRINTM function
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. How to use the AMORLINC function
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. 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. How to use the BASE function
2. 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. How to use the BIN2DEC function
2. Working with classic ciphers in Excel
BIN2HEX function
1. How to use the BIN2HEX function
BIN2OCT function
1. How to use the BIN2OCT function
BINOM.DIST function
1. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. How to use the BITAND function
BITLSHIFT function
1. How to use the BITLSHIFT function
BITOR function
1. How to use the BITOR function
BITRSHIFT function
1. How to use the BITRSHIFT function
BITXOR function
1. How to use the BITXOR function
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. 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. How to create random numbers, text strings, dates and time values
3. How to decode URL-encoded strings
4. How to extract email addresses from an Excel sheet
5. How to generate random numbers and text
6. How to use the CHAR function
7. Navigate to first empty cell using a hyperlink formula
8. Populate cells dynamically in a weekly schedule
9. 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
1. 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. How to use the COMPLEX function
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. How to use the CONVERT function
CORREL function
1. How to use the CORREL function
COS function
1. 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. Dependent drop-down lists in multiple rows
22. Distribute values across numerical ranges
24. Extract a list of alphabetically sorted duplicates based on a condition
25. Extract a list of duplicates from a column
26. Extract a list of duplicates from three columns combined
27. Extract a unique distinct list and ignore blanks
28. Extract a unique distinct list and sum amounts based on a condition
29. Extract a unique distinct list from three columns
30. Extract a unique distinct list from two columns
31. Extract a unique distinct list sorted from A to Z
32. Extract a unique distinct list sorted from A to Z ignore blanks
33. Extract all rows from a range that meet criteria in one column
34. Extract duplicate values with exceptions
35. Extract duplicates from a multi-column cell range
36. Extract shared values between two columns
37. Extract unique distinct values A to Z from a range and ignore blanks
38. Extract unique distinct values based on a filtered Excel defined Table
39. Extract unique distinct values from a multi-column cell range
40. Extract unique distinct values if the value contains the given string
41. Extract unique distinct values in a filtered list
42. Extract unique distinct values sorted based on sum of adjacent values
43. Extract unique distinct values sorted from A to Z
44. Filter duplicate values based on criteria
45. Filter unique distinct records
46. Filter unique distinct values based on a date range
47. Filter unique distinct values, sorted and blanks removed from a range
48. Filter unique values from a cell range
49. Filter unique values sorted from A to Z
50. Filter values in common between two cell ranges
51. Filter values occurring in range 1 but not in range 2
52. Filter values that exists in all three columns
53. Find all sequences of consecutive dates
55. Find min and max unique and duplicate numerical values
57. Find the most recent date that meets a particular condition
58. Get date ranges from a schedule
60. Group rows based on a condition
61. Highlight duplicates in a filtered Excel Table
62. Highlight unique values in a filtered Excel table
63. How to automatically add new items to a drop down list
64. How to build a Team Generator – different number of people per team
65. How to highlight duplicate values
66. How to list unique distinct values sorted by frequency
67. How to perform a two-dimensional lookup
68. How to rank text uniquely without duplicates
69. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
70. How to use the COUNTIF function
71. How to use the COUNTIF function to count not blank cells
72. How to use VLOOKUP/XLOOKUP with multiple conditions
73. If cell contains multiple values
75. If cell contains text from list
76. If cell equals value from list
77. INDEX MATCH – multiple results
78. Lookup with any number of criteria
79. Match two criteria and return multiple records
80. Most frequent value between two dates
81. Partial match and return multiple adjacent values
82. Partial match for multiple strings – AND logic
83. Plot date ranges in a calendar
84. Populate drop down list with unique distinct values sorted from A to Z
85. Repeat values across cells
86. Rotating unique groups with no repeat
87. SMALL function – multiple conditions
89. Sort a column alphabetically
90. Sort a range from A to Z [Array formula]
91. Sort based on frequency row-wise
92. Sort column based on frequency
93. Sort rows based on frequency and criteria
94. Sort text cells alphabetically from two columns
95. Sort values by corresponding text arranged in a column
98. SUMPRODUCT – multiple criteria
99. Team Generator
100. Time sheet for work
101. True round-robin tournament
102. Use a drop down list to filter and concatenate unique distinct values
103. Use IF + COUNTIF to evaluate multiple conditions
104. Use VLOOKUP and return multiple values sorted from A to Z
105. VLOOKUP – Return multiple unique distinct values
106. Vlookup a cell range and return multiple values
107. Vlookup with multiple matches returns a different value
108. What values are missing in List 1 that exists i List 2?
109. 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. How to use the CUMIPMT function
CUMPRINC function
1. How to use the CUMPRINC function
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
9. Get date ranges from a schedule
10. Highlight events in a yearly calendar
11. How to create date ranges in Excel
12. How to group items by quarter using formulas
13. How to track sector performance in the stock market – Excel template
14. Identify overlapping date ranges
15. List all unique distinct rows in a given month
17. Plot date ranges in a calendar
18. Watch schedule that populates vacation time
20. 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. Get date ranges from a schedule
8. How to calculate and plot pivots on an Excel chart
9. How to track sector performance in the stock market – Excel template
DAYS function
1. How to use the DAYS function
DB function
DCOUNT function
DDB function
1. How to use the DDB function
DEC2BIN function
1. How to use the DEC2BIN function
2. Working with classic ciphers in Excel
DEC2HEX function
1. How to use the DEC2HEX function
2. Working with classic ciphers in Excel
DEC2OCT function
1. How to use the DEC2OCT function
DECIMAL function
1. How to use the DECIMAL function
DEGREES function
1. How to use the DEGREES function
DELTA function
1. How to use the DELTA function
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. How to use the DOLLARFR function
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
2. How to use the EDATE function
EFFECT function
1. How to use the EFFECT function
ENCODEURL function
1. How to use the ENCODEURL function
EOMONTH function
1. How to use the EOMONTH function
ERROR.TYPE function
1. How to use the ERROR.TYPE function
Evaluate method
EVEN function
1. How to use the EVEN function
EXACT function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Count unique distinct values
4. 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. Extract a list of alphabetically sorted duplicates based on a condition
15. Extract a list of duplicates from a column
16. Extract a list of duplicates from three columns combined
17. Extract a unique distinct list and ignore blanks
18. Extract a unique distinct list sorted from A to Z
19. Extract a unique distinct list sorted from A to Z ignore blanks
20. Extract all rows from a range that meet criteria in one column
21. Extract dates from overlapping date ranges
22. Extract duplicate values with exceptions
23. Extract duplicates from a multi-column cell range
24. Extract numbers from a column
25. Extract records between two dates
26. Extract shared values between two columns
27. Extract unique distinct values A to Z from a range and ignore blanks
28. Extract unique distinct values in a filtered list
29. Extract unique distinct values sorted based on sum of adjacent values
30. Filter duplicate values based on criteria
31. Filter overlapping date ranges
32. Filter strings containing a given substring in a cell range
33. Filter unique distinct records
34. Filter unique distinct records case sensitive
35. Filter unique distinct values based on a date range
36. Filter values in common between two cell ranges
37. Filter values occurring in range 1 but not in range 2
38. Find all sequences of consecutive dates
39. Find empty dates in a set of date ranges
40. Find min and max unique and duplicate numerical values
42. Find the most recent date that meets a particular condition
43. Get date ranges from a schedule
44. Group rows based on a condition
45. How to compare two data sets
46. How to create date ranges in Excel
47. How to extract a case sensitive unique list from a column
48. How to extract email addresses from an Excel sheet
49. How to extract rows containing digits [Formula]
50. How to ignore zeros using the SMALL function
51. How to list unique distinct values sorted by frequency
52. How to use the FILTER function
53. How to use VLOOKUP/XLOOKUP with multiple conditions
54. Identify rows of overlapping records
55. If cell contains text from list
56. INDEX MATCH – multiple results
57. INDEX MATCH with multiple criteria
58. List all unique distinct rows in a given month
59. List dates outside specified date ranges
60. Lookup and return multiple sorted values based on corresponding values in another column
61. Lookup and return multiple values concatenated into one cell
62. Lookup multiple values across columns and return a single value
63. Lookup multiple values in one cell
64. Lookups in relational tables
65. Match two criteria and return multiple records
66. Merge two columns with possible blank cells
67. Partial match and return multiple adjacent values
68. Partial match for multiple strings – AND logic
69. Partial match with two conditions and return multiple results
70. Reverse a list ignoring blanks
71. Search for a sequence of cells based on wildcard search
72. Search for a sequence of values
73. Search for a text string in a data set and return multiple records
74. SMALL function – INDEX MATCH
76. Use VLOOKUP and return multiple values sorted from A to Z
77. VLOOKUP – Return multiple unique distinct values
78. Vlookup a cell range and return multiple values
79. Vlookup with multiple matches returns a different value
80. VLOOKUP/XLOOKUP of three columns to pull a single record
81. What values are missing in List 1 that exists i List 2?
82. Wildcard lookups and include or exclude criteria
84. 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
GAMMA function
1. How to use the GAMMA function
GAMMA.DIST function
1. How to use the GAMMA.DIST function
GAMMADIST function
Gantt
GCD function
1. How to use the GCD function
GDC function
1. How to use the GCD function
GEOMEAN function
1. How to use the GEOMEAN function
GoTo statement
GROWTH function
1. How to use the GROWTH function
HARMEAN function
1. How to use the HARMEAN function
HEX2BIN function
1. How to use the HEX2BIN function
HEX2DEC function
1. How to decode URL-encoded strings
2. How to use the HEX2DEC function
3. Working with classic ciphers in Excel
HEX2OCT function
1. How to use the HEX2OCT function
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
2. How to calculate overlapping time ranges
3. How to use the HOUR function
HSTACK function
1. Array Manipulation Functions
4. Get date ranges from a schedule
5. Group rows based on a condition
6. How to create date ranges in Excel
7. Sort rows based on frequency and criteria
8. 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. Dependent drop-down lists in multiple rows
42. Distribute values across numerical ranges
44. Excel calendar
45. Extract a list of alphabetically sorted duplicates based on a condition
46. Extract a list of duplicates from a column
47. Extract a unique distinct list from two columns
48. Extract a unique distinct list sorted from A to Z
49. Extract a unique distinct list sorted from A to Z ignore blanks
50. Extract all rows from a range that meet criteria in one column
51. Extract dates from overlapping date ranges
52. Extract duplicates from a multi-column cell range
53. Extract numbers from a column
54. Extract records between two dates
55. Extract shared values between two columns
56. Extract specific word based on position in cell value
57. Extract the most repeated adjacent values in a column
58. Extract unique distinct values A to Z from a range and ignore blanks
59. Extract unique distinct values from a multi-column cell range
60. Extract unique distinct values from a relational table
61. Extract unique distinct values in a filtered list
62. Extract unique distinct values sorted based on sum of adjacent values
63. Extract unique distinct values sorted from A to Z
64. Filter duplicate values based on criteria
65. Filter duplicates within same date, week or month
66. Filter overlapping date ranges
67. Filter strings containing a given substring in a cell range
68. Filter unique distinct records
69. Filter unique distinct values based on a date range
70. Filter unique distinct values, sorted and blanks removed from a range
71. Filter unique values from a cell range
72. Filter unique values sorted from A to Z
73. Filter values in common between two cell ranges
74. Filter values occurring in range 1 but not in range 2
75. Find all sequences of consecutive dates
76. Find and return the highest number and corresponding date based on a condition
78. Find earliest and latest overlapping dates in a set of date ranges based on a condition
79. Find empty dates in a set of date ranges
80. Find empty hours in a weekly schedule
81. Find min and max unique and duplicate numerical values
83. Find numbers closest to sum
84. Find the most recent date that meets a particular condition
85. Find the smallest number in a list that is larger than a given number
86. Follow stock market trends – Moving Average
87. Follow stock market trends – trailing stop
88. Formula for matching a date within a date range
89. Fuzzy VLOOKUP
90. Get date ranges from a schedule
92. Group rows based on a condition
93. Highlight duplicates in a filtered Excel Table
94. Highlight lookups in relational tables
95. Highlight unique values in a filtered Excel table
96. How to calculate and plot pivots on an Excel chart
97. How to color chart bars based on their values
98. How to compare two data sets
99. How to count repeating values
100. How to create date ranges in Excel
101. How to create random numbers, text strings, dates and time values
102. How to create running totals
103. How to decode URL-encoded strings
104. How to extract a case sensitive unique list from a column
105. How to extract email addresses from an Excel sheet
106. How to extract numbers from a cell value
107. How to extract rows containing digits [Formula]
108. How to group items by quarter using formulas
109. How to highlight duplicate values
110. How to ignore zeros using the SMALL function
111. How to list unique distinct values sorted by frequency
112. How to perform a two-dimensional lookup
113. How to replace part of formula in all cells
114. How to return a value if lookup value is in a range
115. How to select and delete blank cells
116. How to track sector performance in the stock market – Excel template
118. How to use nested IF functions
119. How to use the IF function
120. How to use VLOOKUP/XLOOKUP with multiple conditions
121. Identify rows of overlapping records
123. If cell contains text from list
124. If cell equals value from list
125. IF function with AND function – multiple conditions
126. IF with OR function
127. INDEX MATCH – multiple results
128. INDEX MATCH with multiple criteria
129. Label groups of duplicate records
130. List all unique distinct rows in a given month
131. List dates outside specified date ranges
132. Lookup and return multiple sorted values based on corresponding values in another column
133. Lookup and return multiple values concatenated into one cell
134. Lookup multiple values across columns and return a single value
136. Lookup with any number of criteria
137. Lookups in relational tables
138. Match two criteria and return multiple records
139. Merge cell ranges into one list
140. Merge tables based on a condition
141. Merge two columns with possible blank cells
142. Monthly calendar template
143. Most frequent value between two dates
144. Multiply numbers in each row by entire cell range
145. Partial match and return multiple adjacent values
146. Partial match and return value with highest level
147. Partial match for multiple strings – AND logic
148. Partial match with two conditions and return multiple results
149. Perform multiple partial matches and return records – AND logic
150. Pivot Table calendar
151. Plot buy and sell points in an Excel Chart based on two moving averages
152. Plot date ranges in a calendar
153. Populate cells dynamically in a weekly schedule
154. Populate drop down list with filtered Excel Table values
155. Populate drop down list with unique distinct values sorted from A to Z
156. Practice basic arithmetic calculations in Excel
157. Rearrange data
158. Remove common records between two data sets
159. Remove duplicates within same month or year
160. Repeat values across cells
161. Reverse a list ignoring blanks
162. Rotating unique groups with no repeat
163. Search each column for a string each and return multiple records – OR logic
164. Search for a sequence of cells based on wildcard search
165. Search for a sequence of values
166. Search for a text string in a data set and return multiple records
167. Search related table based on a date and date range
168. Shift Schedule
169. SMALL function – multiple conditions
171. SMALL function ignore duplicates
172. Sort a column alphabetically
173. Sort a range from A to Z [Array formula]
174. Sort based on frequency row-wise
175. Sort column based on frequency
176. Sort rows based on frequency and criteria
177. Sort values by corresponding text arranged in a column
178. Split expenses calculator
179. Split search value using a delimiter and search for each substring
180. Split values equally into groups
181. SUMPRODUCT and IF function
182. SUMPRODUCT and nested IF functions
183. Time sheet for work
184. Tracking a stock portfolio #2
185. True round-robin tournament
186. Unique distinct records sorted based on count or frequency
187. Use a drop down list to filter and concatenate unique distinct values
188. Use a drop down list to search and return multiple values
189. Use drop down lists and named ranges to filter chart values
190. Use IF + COUNTIF to evaluate multiple conditions
191. Use VLOOKUP and return multiple values sorted from A to Z
192. VLOOKUP – Return multiple unique distinct values
193. Vlookup a cell range and return multiple values
194. Vlookup across multiple sheets
195. Vlookup with multiple matches returns a different value
196. VLOOKUP/XLOOKUP of three columns to pull a single record
197. Watch schedule that populates vacation time
198. What values are missing in List 1 that exists i List 2?
199. Wildcard lookups and include or exclude criteria
200. Working with classic ciphers in Excel
202. Working with overlapping date ranges
203. 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
16. Excel calendar
17. Extract a list of duplicates from a column
18. Extract a list of duplicates from three columns combined
19. Extract a unique distinct list from three columns
20. Extract a unique distinct list from two columns
21. Extract a unique distinct list sorted from A to Z ignore blanks
22. Extract duplicate values with exceptions
23. Extract records between two dates
24. Extract specific word based on position in cell value
25. Extract unique distinct values from a relational table
26. Filter duplicate values based on criteria
27. Filter unique distinct records
28. Filter unique distinct values based on a date range
29. Filter unique distinct values, sorted and blanks removed from a range
30. Filter values that exists in all three columns
31. Find all sequences of consecutive dates
33. Follow stock market trends – Moving Average
34. Fuzzy VLOOKUP
36. Group rows based on a condition
37. How to automatically add new items to a drop down list
38. How to build a Team Generator – different number of people per team
39. How to calculate and plot pivots on an Excel chart
40. How to extract rows containing digits [Formula]
41. How to group items by quarter using formulas
42. How to perform a two-dimensional lookup
44. How to use the IFERROR function
46. Identify rows of overlapping records
47. If cell contains text from list
48. List all unique distinct rows in a given month
49. List dates outside specified date ranges
50. Lookup and return multiple values concatenated into one cell
52. Lookup with any number of criteria
53. Lookups in relational tables
54. Merge cell ranges into one list
55. Merge two columns with possible blank cells
56. Plot buy and sell points in an Excel Chart based on two moving averages
57. Plot date ranges in a calendar
58. Populate drop down list with filtered Excel Table values
59. Remove common records between two data sets
60. Search for a text string in a data set and return multiple records
61. Search related table based on a date and date range
62. Shift Schedule
63. Sort rows based on frequency and criteria
64. Sort text cells alphabetically from two columns
66. Split search value using a delimiter and search for each substring
67. Split values equally into groups
68. Team Generator
70. Tracking a stock portfolio #2
71. True round-robin tournament
72. Use a drop down list to search and return multiple values
73. Vlookup a cell range and return multiple values
74. Vlookup across multiple sheets
75. Watch schedule that populates vacation time
76. Wildcard lookups and include or exclude criteria
77. Working with classic ciphers in Excel
78. Working with three relational tables
79. 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. How to use the IMABS function
IMAGE function
1. How to use the IMAGE function
IMAGINARY function
1. How to use the IMAGINARY function
IMARGUMENT function
1. How to use the IMARGUMENT function
IMCONJUGATE function
1. How to use the IMCONJUGATE function
IMCOS function
1. How to use the IMCOS function
IMCOSH function
1. How to use the IMCOSH function
IMCOT function
1. How to use the IMCOT function
IMCSC function
1. How to use the IMCSC function
IMCSCH function
1. How to use the IMCSCH function
IMDIV function
1. How to use the IMDIV function
IMEXP function
1. How to use the IMEXP function
IMLN
1. How to use the IMLN function
IMLOG10 function
1. How to use the IMLOG10 function
IMLOG2 function
1. How to use the IMLOG2 function
IMPOWER function
1. How to use the IMPOWER function
IMPRODUCT function
1. How to use the IMPRODUCT function
IMREAL function
1. How to use the IMREAL function
IMSEC function
1. How to use the IMSEC function
IMSECH function
1. How to use the IMSECH function
IMSIN function
1. How to use the IMSIN function
IMSINH function
1. How to use the IMSINH function
IMSQRT function
1. How to use the IMSQRT function
IMSUB function
1. How to use the IMSUB function
IMSUM function
1. How to use the IMSUM function
IMTAN function
1. How to use the IMTAN function
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. Dependent drop-down lists in multiple rows
26. Excel calendar
27. Extract a list of alphabetically sorted duplicates based on a condition
28. Extract a list of duplicates from a column
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 duplicates from a multi-column cell range
36. Extract numbers from a column
37. Extract records between two dates
38. Extract shared values between two columns
39. Extract specific word based on position in cell value
40. Extract the most repeated adjacent values in a column
41. Extract unique distinct values A to Z from a range and ignore blanks
42. Extract unique distinct values based on a filtered Excel defined Table
43. Extract unique distinct values based on the 4 last characters
44. Extract unique distinct values from a multi-column cell range
45. Extract unique distinct values from a relational table
46. Extract unique distinct values in a filtered list
47. Extract unique distinct values sorted based on sum of adjacent values
48. Extract unique distinct values sorted from A to Z
49. Filter duplicate values based on criteria
50. Filter duplicates within same date, week or month
51. Filter unique distinct records
52. Filter unique distinct records case sensitive
53. Filter unique distinct values based on a date range
54. Filter unique distinct values, sorted and blanks removed from a range
55. Filter unique values from a cell range
56. Filter unique values sorted from A to Z
57. Filter values in common between two cell ranges
58. Filter values occurring in range 1 but not in range 2
59. Filter values that exists in all three columns
61. Find last value in a column
63. Find numbers closest to sum
64. Find the most recent date that meets a particular condition
65. Find the most/least consecutive repeated value [VBA]
66. Follow stock market trends – Moving Average
67. Formula for matching a date within a date range
68. Fuzzy lookups
69. Fuzzy VLOOKUP
70. Get date ranges from a schedule
72. Group rows based on a condition
73. Highlight a data series in a chart
74. Highlight lookups in relational tables
75. How to animate an Excel chart
76. How to automatically add new items to a drop down list
77. How to build a Team Generator – different number of people per team
78. How to build an interactive map in Excel
79. How to change a picture in a worksheet dynamically [VBA]
80. How to compare two data sets
81. How to copy non contiguous cell ranges
82. How to create date ranges in Excel
83. How to extract a case sensitive unique list from a column
84. How to extract email addresses from an Excel sheet
85. How to extract rows containing digits [Formula]
87. How to generate random numbers and text
88. How to group items by quarter using formulas
89. How to highlight differences and common values in lists
90. How to list unique distinct values sorted by frequency
91. How to perform a two-dimensional lookup
92. How to quickly find the maximum or minimum value [Formula]
93. How to replace part of formula in all cells
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 an Excel Table name in Data Validation Lists and Conditional Formatting formulas
98. How to use the INDEX function
99. How to use the MAKEARRAY function
100. How to use the Scroll Bar
101. How to use VLOOKUP/XLOOKUP with multiple conditions
102. If cell contains text from list
103. If cell equals value from list
104. INDEX MATCH – Case sensitive
105. INDEX MATCH – multiple results
106. INDEX MATCH with multiple criteria
107. Label groups of duplicate records
108. List all unique distinct rows in a given month
109. List permutations with repetition and how many to choose from
110. Lookup and return multiple sorted values based on corresponding values in another column
111. Lookup multiple values across columns and return a single value
114. Lookup with any number of criteria
115. Lookups in relational tables
116. Match two columns and return another value on the same row
117. Match two criteria and return multiple records
118. Merge cell ranges into one list
119. Merge tables based on a condition
120. Merge two columns with possible blank cells
121. Merge two relational data sets
122. Most frequent value between two dates
123. Multiply numbers in each row by entire cell range
124. Partial match and return multiple adjacent values
125. Partial match and return value with highest level
126. Partial match for multiple strings – AND logic
127. Partial match with two conditions and return multiple results
128. Perform multiple partial matches and return records – AND logic
129. Pivot Table calendar
130. Plot buy and sell points in an Excel Chart based on two moving averages
131. Plot date ranges in a calendar
132. Populate drop down list with filtered Excel Table values
133. Populate drop down list with unique distinct values sorted from A to Z
134. Rearrange values in a cell range to a single column
135. Rearrange values using formulas
136. Remove common records between two data sets
137. Remove duplicates within same month or year
138. Repeat values across cells
139. Reverse a list ignoring blanks
140. Rotating unique groups with no repeat
141. Search each column for a string each and return multiple records – OR logic
142. Search for a text string in a data set and return multiple records
143. Search related table based on a date and date range
144. Shift Schedule
145. SMALL function – INDEX MATCH
147. Sort a column alphabetically
148. Sort a range from A to Z [Array formula]
149. Sort based on frequency row-wise
151. Sort column based on frequency
152. Sort items by adjacent number in every other value
153. Sort rows based on frequency and criteria
154. Sort text cells alphabetically from two columns
155. Sort values by corresponding text arranged in a column
156. Split expenses calculator
157. Split values equally into groups
158. Team Generator
159. Time sheet for work
160. True round-robin tournament
161. Two-way lookup in multiple cross reference tables simultaneously
162. Unique distinct records sorted based on count or frequency
163. Use a drop down list to search and return multiple values
164. Use drop down lists and named ranges to filter chart values
165. Use VLOOKUP and return multiple values sorted from A to Z
167. VLOOKUP – Return multiple unique distinct values
168. Vlookup a cell range and return multiple values
169. Vlookup across multiple sheets
170. Vlookup with multiple matches returns a different value
171. VLOOKUP/XLOOKUP of three columns to pull a single record
172. Watch schedule that populates vacation time
173. What values are missing in List 1 that exists i List 2?
174. Wildcard lookups and include or exclude criteria
175. Working with classic ciphers in Excel
176. Working with overlapping date ranges
177. 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. Find empty dates in a set of date ranges
6. Find empty hours in a weekly schedule
7. Highlight a data series in a chart
8. Highlight duplicates in a filtered Excel Table
9. Highlight lookups in relational tables
10. Highlight unique values in a filtered Excel table
11. How to calculate overlapping time ranges
12. How to create permutations
13. How to use absolute and relative references
14. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
16. How to use the INDIRECT function
17. Plot date ranges in a calendar
18. Prevent duplicate records in a worksheet
19. Prevent overlapping date and time ranges using data validation
20. True round-robin tournament
21. Two-way lookup in multiple cross reference tables simultaneously
22. Watch schedule that populates vacation time
23. 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. How to use the IPMT function
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. How to use the ISPMT function
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. Extract duplicates from a multi-column cell range
4. Extract specific word based on position in cell value
5. Formula for matching a date within a date range
7. How to calculate and plot pivots on an Excel chart
8. How to extract email addresses from an Excel sheet
9. How to use the LEFT function
10. Lookup and return multiple values concatenated into one cell
11. VLOOKUP – Return multiple unique distinct values
12. 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. Extract duplicates from a multi-column cell range
9. Find last value in a column
10. Formula for matching a date within a date range
11. Fuzzy lookups
12. Fuzzy VLOOKUP
13. How to count the number of values separated by a delimiter
14. How to extract email addresses from an Excel sheet
15. How to extract numbers from a cell value
16. How to remove numbers from a cell value
17. How to use the LEN function
18. List all permutations with a condition
19. Lookup and return multiple values concatenated into one cell
20. Partial match and return multiple adjacent values
22. Sort a column alphabetically
23. VLOOKUP – Return multiple unique distinct values
24. 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
11. Extract a list of alphabetically sorted duplicates based on a condition
12. Extract a list of duplicates from a column
13. Extract a list of duplicates from three columns combined
14. Extract dates from overlapping date ranges
15. Extract duplicate values with exceptions
16. Extract duplicates from a multi-column cell range
17. Extract the most repeated adjacent values in a column
18. Extract unique distinct values A to Z from a range and ignore blanks
19. Extract unique distinct values in a filtered list
20. Extract unique distinct values sorted based on sum of adjacent values
21. Filter duplicate values based on criteria
22. Filter unique distinct records case sensitive
23. Find all sequences of consecutive dates
24. Find empty dates in a set of date ranges
25. Find empty hours in a weekly schedule
27. Find numbers closest to sum
28. Fuzzy lookups
29. Get date ranges from a schedule
30. How to calculate overlapping time ranges
31. How to create date ranges in Excel
32. How to decode URL-encoded strings
33. How to do tiered calculations in one formula
34. How to extract a case sensitive unique list from a column
35. How to extract email addresses from an Excel sheet
36. How to extract numbers from a cell value
37. How to list unique distinct values sorted by frequency
38. How to sum overlapping time
39. How to track sector performance in the stock market – Excel template
40. How to use the LET function
41. How to use VLOOKUP/XLOOKUP with multiple conditions
42. If cell contains text from list
43. List dates outside specified date ranges
44. Lookup and return multiple sorted values based on corresponding values in another column
45. Match two criteria and return multiple records
46. Merge two columns with possible blank cells
47. Reverse a list ignoring blanks
48. Search for a text string in a data set and return multiple records
49. Sort items by adjacent number in every other value
50. Sort rows based on frequency and criteria
51. Sort values by corresponding text arranged in a column
53. Sum numerical ranges between two numbers
54. Team Generator
55. Unique distinct records sorted based on count or frequency
56. VLOOKUP – Return multiple unique distinct values
57. Vlookup a cell range and return multiple values
58. Wildcard lookups and include or exclude criteria
59. 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. 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
63. Find last value in a column
65. Find numbers closest to sum
66. Find the most recent date that meets a particular condition
67. Find the most/least consecutive repeated value [VBA]
68. Follow stock market trends – Moving Average
69. Formula for matching a date within a date range
70. Get date ranges from a schedule
72. Group rows based on a condition
74. Highlight duplicates in a filtered Excel Table
75. Highlight lookups in relational tables
76. Highlight unique values in a filtered Excel table
77. How to animate an Excel chart
78. How to automatically add new items to a drop down list
79. How to build a Team Generator – different number of people per team
80. How to build an interactive map in Excel
81. How to change a picture in a worksheet dynamically [VBA]
82. How to color chart bars based on their values
83. How to compare two data sets
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 group items by quarter using formulas
89. How to highlight differences and common values in lists
90. How to list unique distinct values sorted by frequency
91. How to perform a two-dimensional lookup
92. How to quickly find the maximum or minimum value [Formula]
93. How to return a value if lookup value is in a range
94. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
95. How to use the MATCH function
96. How to use VLOOKUP/XLOOKUP with multiple conditions
97. If cell contains text from list
98. INDEX MATCH – Case sensitive
99. INDEX MATCH – multiple results
100. INDEX MATCH with multiple criteria
101. Label groups of duplicate records
102. List all unique distinct rows in a given month
103. Lookup and return multiple sorted values based on corresponding values in another column
104. Lookup and return multiple values concatenated into one cell
105. Lookup multiple values across columns and return a single value
108. Lookup with any number of criteria
109. Lookups in relational tables
110. Match two columns and return another value on the same row
111. Match two criteria and return multiple records
112. Merge tables based on a condition
113. Merge two relational data sets
114. Monthly calendar template
115. Most frequent value between two dates
116. Partial match and return multiple adjacent values
117. Partial match and return value with highest level
118. Partial match for multiple strings – AND logic
119. Partial match with two conditions and return multiple results
120. Perform multiple partial matches and return records – AND logic
121. Plot buy and sell points in an Excel Chart based on two moving averages
122. Plot date ranges in a calendar
123. Populate drop down list with filtered Excel Table values
124. Populate drop down list with unique distinct values sorted from A to Z
125. Remove common records between two data sets
126. Remove duplicates within same month or year
127. Repeat values across cells
128. Reverse a list ignoring blanks
129. Rotating unique groups with no repeat
130. Search each column for a string each and return multiple records – OR logic
131. Search for a sequence of cells based on wildcard search
132. Search for a sequence of values
133. Search for a text string in a data set and return multiple records
134. Search related table based on a date and date range
135. Shift Schedule
136. SMALL function – INDEX MATCH
138. Sort a column alphabetically
139. Sort a range from A to Z [Array formula]
140. Sort based on frequency row-wise
142. Sort column based on frequency
143. Sort items by adjacent number in every other value
144. Sort rows based on frequency and criteria
145. Sort text cells alphabetically from two columns
146. Sort values by corresponding text arranged in a column
147. Split expenses calculator
148. Team Generator
149. Time sheet for work
150. True round-robin tournament
151. Two-way lookup in multiple cross reference tables simultaneously
152. Unique distinct records sorted based on count or frequency
153. Use a drop down list to search and return multiple values
154. Use drop down lists and named ranges to filter chart values
155. Use IF + COUNTIF to evaluate multiple conditions
156. Use VLOOKUP and return multiple values sorted from A to Z
158. VLOOKUP – Return multiple unique distinct values
159. Vlookup a cell range and return multiple values
160. VLOOKUP/XLOOKUP of three columns to pull a single record
161. Watch schedule that populates vacation time
162. What values are missing in List 1 that exists i List 2?
163. Wildcard lookups and include or exclude criteria
164. Working with classic ciphers in Excel
165. Working with overlapping date ranges
166. 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
2. How to use the MINUTE function
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. Excel calendar
13. Get date ranges from a schedule
14. Highlight events in a yearly calendar
15. How to calculate and plot pivots on an Excel chart
16. How to track sector performance in the stock market – Excel template
17. How to use the MONTH function
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. How to use the NETWORKDAYS function
NETWORKDAYS.INTL function
1. How to use the NETWORKDAYS.INTL function
NOMINAL function
1. How to use the 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. How to use the NOW function
NPER function
1. How to use the NPER function
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. How to use the PDURATION function
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
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. How to use the PMT function
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. How to use the PPMT function
PRICEMAT function
1. How to use the PRICEMAT function
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. 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. How to use the RATE function
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. Extract specific word based on position in cell value
3. How to extract email addresses from an Excel sheet
4. How to use the REPT function
5. 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
1. How to use the ROUND function
2. Sort items by adjacent number in every other value
3. Sort values by corresponding text arranged in a column
4. 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. Hover with mouse cursor to change stock in a candlestick chart
4. How to create random numbers, text strings, dates and time values
5. How to use the ROUNDUP function
7. 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. Dependent drop-down lists in multiple rows
18. Extract a list of alphabetically sorted duplicates based on a condition
19. Extract a list of duplicates from a column
20. Extract a list of duplicates from three columns combined
21. Extract all rows from a range that meet criteria in one column
22. Extract dates from overlapping date ranges
23. Extract duplicate values with exceptions
24. Extract numbers from a column
25. Extract shared values between two columns
26. Extract the most repeated adjacent values in a column
27. Extract unique distinct values in a filtered list
28. Filter duplicate values based on criteria
29. Filter unique distinct records case sensitive
30. Filter unique values sorted from A to Z
31. Find all sequences of consecutive dates
32. Find empty dates in a set of date ranges
33. Find empty hours in a weekly schedule
35. Find numbers closest to sum
36. Find the most recent date that meets a particular condition
37. Follow stock market trends – Moving Average
38. Get date ranges from a schedule
39. How to compare two data sets
40. How to copy non contiguous cell ranges
41. How to create date ranges in Excel
42. How to decode URL-encoded strings
43. How to extract a case sensitive unique list from a column
44. How to extract rows containing digits [Formula]
45. How to ignore zeros using the SMALL function
46. How to replace part of formula in all cells
47. How to return a value if lookup value is in a range
48. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
50. How to use the MAKEARRAY function
51. How to use the ROWS function
52. How to use VLOOKUP/XLOOKUP with multiple conditions
53. INDEX MATCH – multiple results
54. INDEX MATCH with multiple criteria
55. Lookup and return multiple sorted values based on corresponding values in another column
56. Match two criteria and return multiple records
57. Merge cell ranges into one list
58. Multiply numbers in each row by entire cell range
59. Partial match and return multiple adjacent values
60. Partial match for multiple strings – AND logic
61. Partial match with two conditions and return multiple results
62. Perform multiple partial matches and return records – AND logic
63. Populate drop down list with filtered Excel Table values
64. Rearrange values in a cell range to a single column
65. Rearrange values using formulas
66. Remove duplicates within same month or year
67. Reverse a list ignoring blanks
68. Search each column for a string each and return multiple records – OR logic
69. Search for a sequence of values
70. Search for a text string in a data set and return multiple records
71. Search related table based on a date and date range
72. Shift Schedule
73. SMALL function – INDEX MATCH
74. SMALL function – multiple conditions
76. SMALL function ignore duplicates
77. Sort a column alphabetically
78. Sort a range from A to Z [Array formula]
79. Sort based on frequency row-wise
81. Sort rows based on frequency and criteria
82. Sort text cells alphabetically from two columns
83. Sort values by corresponding text arranged in a column
84. Split values equally into groups
85. Team Generator
86. True round-robin tournament
87. Use VLOOKUP and return multiple values sorted from A to Z
88. What values are missing in List 1 that exists i List 2?
RRI function
1. 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
2. How to use the SECOND function
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. Extract dates from overlapping date ranges
9. Extract the most repeated adjacent values in a column
10. Extract unique distinct values in a filtered list
11. Find empty dates in a set of date ranges
13. Find numbers closest to sum
14. Fuzzy VLOOKUP
15. Get date ranges from a schedule
16. How to calculate overlapping time ranges
17. How to copy non contiguous cell ranges
18. How to decode URL-encoded strings
19. How to extract numbers from a cell value
20. How to extract rows containing digits [Formula]
21. How to remove numbers from a cell value
22. How to use the SEQUENCE function
23. How to use VLOOKUP/XLOOKUP with multiple conditions
24. List all permutations with a condition
25. List dates outside specified date ranges
26. List permutations with repetition and how many to choose from
27. Rearrange values using formulas
28. Reverse a list ignoring blanks
29. Sort items by adjacent number in every other value
30. Sort values by corresponding text arranged in a column
32. Sum numerical ranges between two numbers
33. Team Generator
34. 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. 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. Dependent drop-down lists in multiple rows
17. Distribute values across numerical ranges
18. Excel calendar
19. Extract a list of alphabetically sorted duplicates based on a condition
20. Extract a list of duplicates from a column
21. Extract a unique distinct list sorted from A to Z
22. Extract a unique distinct list sorted from A to Z ignore blanks
23. Extract all rows from a range that meet criteria in one column
24. Extract dates from overlapping date ranges
25. Extract numbers from a column
26. Extract records between two dates
27. Extract shared values between two columns
28. Extract the most repeated adjacent values in a column
29. Extract unique distinct values A to Z from a range and ignore blanks
30. Extract unique distinct values from a relational table
31. Extract unique distinct values sorted from A to Z
32. Filter duplicate values based on criteria
33. Filter duplicates within same date, week or month
34. Filter overlapping date ranges
35. Filter unique distinct values, sorted and blanks removed from a range
36. Filter unique values sorted from A to Z
37. Find all sequences of consecutive dates
39. Find empty dates in a set of date ranges
40. Find empty hours in a weekly schedule
42. Find the most recent date that meets a particular condition
43. Find the smallest number in a list that is larger than a given number
44. Follow stock market trends – Moving Average
45. Formula for matching a date within a date range
46. Fuzzy VLOOKUP
47. Get date ranges from a schedule
48. Group rows based on a condition
49. How to compare two data sets
50. How to create date ranges in Excel
51. How to extract a case sensitive unique list from a column
52. How to extract rows containing digits [Formula]
53. How to group items by quarter using formulas
54. How to ignore zeros using the SMALL function
55. How to perform a two-dimensional lookup
56. How to replace part of formula in all cells
57. How to return a value if lookup value is in a range
58. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
60. How to use the SMALL function
61. How to use VLOOKUP/XLOOKUP with multiple conditions
62. Identify rows of overlapping records
63. If cell contains text from list
64. INDEX MATCH – multiple results
65. INDEX MATCH with multiple criteria
66. List all unique distinct rows in a given month
67. List dates outside specified date ranges
68. Lookup and return multiple sorted values based on corresponding values in another column
69. Lookup multiple values across columns and return a single value
71. Lookup with any number of criteria
72. Lookups in relational tables
73. Match two criteria and return multiple records
74. Merge two columns with possible blank cells
75. Partial match and return multiple adjacent values
76. Partial match for multiple strings – AND logic
77. Partial match with two conditions and return multiple results
78. Perform multiple partial matches and return records – AND logic
79. Plot date ranges in a calendar
80. Populate drop down list with filtered Excel Table values
81. Populate drop down list with unique distinct values sorted from A to Z
82. Remove common records between two data sets
83. Remove duplicates within same month or year
84. Search each column for a string each and return multiple records – OR logic
85. Search for a sequence of cells based on wildcard search
86. Search for a sequence of values
87. Search for a text string in a data set and return multiple records
88. Search related table based on a date and date range
89. Shift Schedule
90. SMALL function – INDEX MATCH
91. SMALL function – multiple conditions
93. SMALL function ignore duplicates
94. Sort a column alphabetically
95. Sort a range from A to Z [Array formula]
96. Sort values by corresponding text arranged in a column
98. True round-robin tournament
99. Use a drop down list to filter and concatenate unique distinct values
100. Use a drop down list to search and return multiple values
101. Use VLOOKUP and return multiple values sorted from A to Z
102. Vlookup a cell range and return multiple values
103. Vlookup across multiple sheets
104. Vlookup with multiple matches returns a different value
105. Watch schedule that populates vacation time
106. What values are missing in List 1 that exists i List 2?
107. Wildcard lookups and include or exclude criteria
109. 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. Extract a list of alphabetically sorted duplicates based on a condition
4. Extract a list of duplicates from a column
5. Extract a unique distinct list sorted from A to Z
6. Extract a unique distinct list sorted from A to Z ignore blanks
7. Extract unique distinct values A to Z from a range and ignore blanks
8. Filter unique values sorted from A to Z
9. Find all sequences of consecutive dates
10. Fuzzy lookups
11. Fuzzy VLOOKUP
12. How to extract numbers from a cell value
13. How to ignore zeros using the SMALL function
14. How to use the SORT function
15. SMALL function – INDEX MATCH
16. Sort a column alphabetically
17. Sort rows based on frequency and criteria
18. Sort values by corresponding text arranged in a column
19. Sort values in a cell based on a delimiting character
20. Use VLOOKUP and return multiple values sorted from A to Z
21. Working with classic ciphers in Excel
23. 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
3. Count a specific text string in a cell
4. Count cells containing text from list
6. Count groups of repeated values per row
7. Count identical values if they are on the same row
8. Count overlapping days across multiple date ranges
9. Count overlapping days in multiple date ranges
10. Count specific multiple text strings in a given cell range
11. Count unique distinct records
12. Count unique distinct values
13. Count unique distinct values based on a condition
14. Count unique distinct values in a filtered Excel defined Table
15. Count unique distinct values that meet multiple criteria
16. Create unique distinct list sorted based on text length
17. Excel calendar
19. Filter strings containing a given substring in a cell range
20. Filter unique distinct records case sensitive
21. Get date ranges from a schedule
22. Highlight duplicates in a filtered Excel Table
23. Highlight unique values in a filtered Excel table
24. How to build a Team Generator – different number of people per team
25. How to calculate overlapping time ranges
26. How to count the number of values separated by a delimiter
27. How to create running totals
28. How to sum overlapping time
30. How to use the asterisk character
31. How to use the SUM function
32. Identify numbers in sum using Excel solver
34. Label groups of duplicate records
35. List all permutations with a condition
36. Lookup with any number of criteria
37. Lookups in relational tables
38. Rotating unique groups with no repeat
39. Search for a text string in a data set and return multiple records
40. Sort a column alphabetically
42. Sum numerical ranges between two numbers
44. Vlookup a cell range and return multiple values
45. Working with classic ciphers in Excel
46. 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. Dependent drop-down lists in multiple rows
18. Excel calendar
19. Extract a unique distinct list and sum amounts based on a condition
20. Find empty hours in a weekly schedule
21. Find the most recent date that meets a particular condition
22. Formula for matching a date within a date range
23. How to calculate overlapping time ranges
24. How to create date ranges in Excel
25. How to create running totals
26. How to do tiered calculations in one formula
27. How to quickly find the maximum or minimum value [Formula]
28. How to rank text uniquely without duplicates
29. How to return a value if lookup value is in a range
30. How to use the COUNTIF function to count not blank cells
31. How to use the SUMPRODUCT function
32. Identify numbers in sum using Excel solver
33. Identify overlapping date ranges
34. If cell contains multiple values
35. List all permutations with a condition
36. Plot date ranges in a calendar
37. Prevent overlapping date and time ranges using data validation
38. Running totals based on criteria
39. Sort rows based on frequency and criteria
40. Sum numerical ranges between two numbers
42. SUMPRODUCT – multiple criteria
43. SUMPRODUCT and IF function
44. SUMPRODUCT and nested IF functions
46. Team Generator
47. Tracking a stock portfolio #2
48. True round-robin tournament
49. 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. How to calculate and plot pivots on an Excel chart
6. How to create date ranges in Excel
7. How to create running totals
8. How to extract numbers from a cell value
9. How to remove numbers from a cell value
10. How to use the TEXT function
11. Lookup and return multiple values concatenated into one cell
13. 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. Extract specific word based on position in cell value
5. Filter strings containing a given substring in a cell range
6. Filter unique strings from a cell range
7. How to decode URL-encoded strings
8. How to extract email addresses from an Excel sheet
9. How to use the TEXTSPLIT function
10. If cell contains text from list
11. Lookup multiple values in one cell
12. Rearrange data
13. Sort values in a cell based on a delimiting character
14. 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. Find empty hours in a weekly schedule
4. How to use the TIME function
TIMEVALUE function
1. How to use the TIMEVALUE function
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
4. How to track sector performance in the stock market – Excel template
5. How to use the TODAY function
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
7. Concatenate unique distinct values
9. Extract a list of duplicates from a column
10. Extract duplicates from a multi-column cell range
11. Extract specific word based on position in cell value
12. Filter unique distinct values, sorted and blanks removed from a range
13. Filter unique strings from a cell range
14. Filter unique values from a cell range
15. Filter unique values sorted from A to Z
16. Filter values in common between two cell ranges
17. Filter values occurring in range 1 but not in range 2
18. Find min and max unique and duplicate numerical values
19. Formula for matching a date within a date range
20. How to decode URL-encoded strings
21. How to extract email addresses from an Excel sheet
22. How to extract numbers from a cell value
23. How to list unique distinct values sorted by frequency
24. How to perform a two-dimensional lookup
25. How to remove numbers from a cell value
26. How to return a value if lookup value is in a range
27. How to use mouse hover on a worksheet [VBA]
28. How to use nested IF functions
29. How to use the TRUE function
30. How to use VLOOKUP/XLOOKUP with multiple conditions
31. Identify rows of overlapping records
33. If cell contains text from list
34. IF function with AND function – multiple conditions
35. INDEX MATCH – Case sensitive
36. INDEX MATCH – multiple results
37. Lookup and return multiple values concatenated into one cell
38. Lookup multiple values across columns and return a single value
39. Lookup multiple values in one cell
40. Match two columns and return another value on the same row
41. Partial match for multiple strings – AND logic
42. Populate cells dynamically in a weekly schedule
43. Rearrange data
44. Rearrange values in a cell range to a single column
45. Search for a sequence of cells based on wildcard search
46. Search for a text string in a data set and return multiple records
47. Split search value using a delimiter and search for each substring
49. SUMPRODUCT and IF function
51. VLOOKUP – Return multiple unique distinct values
52. Vlookup a cell range and return multiple values
53. 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. Extract a list of duplicates from a column
12. Extract a list of duplicates from three columns combined
13. Extract a unique distinct list and ignore blanks
14. Extract a unique distinct list from three columns
15. Extract a unique distinct list from two columns
16. Extract a unique distinct list sorted from A to Z
17. Extract a unique distinct list sorted from A to Z ignore blanks
18. Extract duplicate values with exceptions
19. Extract duplicates from a multi-column cell range
20. Extract unique distinct values A to Z from a range and ignore blanks
21. Extract unique distinct values from a multi-column cell range
22. Extract unique distinct values in a filtered list
23. Extract unique distinct values sorted based on sum of adjacent values
24. Filter strings containing a given substring in a cell range
25. Filter unique distinct records
26. Filter unique distinct values based on a date range
27. Filter unique strings from a cell range
28. Filter unique values sorted from A to Z
29. Filter values in common between two cell ranges
30. Filter values occurring in range 1 but not in range 2
31. Find min and max unique and duplicate numerical values
32. Group rows based on a condition
33. How to automatically add new items to a drop down list
34. How to extract numbers from a cell value
35. How to list unique distinct values sorted by frequency
36. How to use the UNIQUE function
37. Lookup and return multiple values concatenated into one cell
38. SMALL function ignore duplicates
39. Sort column based on frequency
40. Sort rows based on frequency and criteria
43. Unique distinct records sorted based on count or frequency
44. VLOOKUP – Return multiple unique distinct values
45. Working with classic ciphers in Excel
46. 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
5. How to track sector performance in the stock market – Excel template
6. How to use the WEEKDAY function
9. Populate cells dynamically in a weekly schedule
WEEKNUM function
1. Count unique distinct values
2. Filter duplicates within same date, week or month
3. How to use the WEEKNUM function
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. How to track sector performance in the stock market – Excel template
2. How to use the WORKDAY function
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. Filter duplicates within same date, week or month
12. How to calculate and plot pivots on an Excel chart
13. How to track sector performance in the stock market – Excel template
14. How to use the YEAR function
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. How to use the YEARFRAC function
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