Excel formula examples
This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.
#, hashtag
2D, two-dimensional, two-way
3D, multiple worksheets, multiple sheets
365
Address
Advanced Filter
Alternative
And logic
Autofilter
Average
Blank, space
Calendar
Case
Character
Column
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
Conditional formatting, cf, highlight
Count
Countif
Countifs
Criteria, multiple conditions, conditions
Date
Day
Decimal
Delete, remove
Digit
Duplicates
Dynamic
Empty
Equal, condition, criterion
Error, problem
Extend, expand
Extract, list, filter, get
Finance, stock, expense
First, last
Group, category
Hour
Hyperlink, link
If
Ifs
Ignore, avoid, prevent, exclude, hide
Image, picture
Index
Index match, index and match
Intersection
Lambda
Large, larger, highest, greater
Letter
Lookup, find, identify
Match
Max
Min
Minute
Month
Multiply, multiplication, product
Negative, minus, subtract
New line
Not equal
Or logic
Overlapping
Partial, wildcard, contain
Permut
Random
Rearrange, distribute
Record, row
Recursive
Reference
Relation, related
Reverse
Right, left
Running total
Schedule
Second
Sequence, consecutive
Shared, common, exist, occur
Small, smaller, less
Solver
Sort, A to Z, z to a, ascending, descending
Split
String
Substitute, replace
Subtotal
Sum, total
Sumif
Sumifs
Sumproduct
Tab
Table, excel table
Team, tournament
Text
Time
Unique
Vlookup
Week
Year
Categories
100% stacked column chart
ABS function
1. Calculate the number of weeks between given dates
2. Count cells between specified values
4. Date and Time Functions – A to M
6. Find numbers closest to sum
7. Find the most recent date that meets a particular condition
8. How to create date ranges in Excel
9. How to use the ABS function
10. How to use the asterisk character
11. Identify numbers in sum using Excel solver
ACCRINT function
ACCRINTM function
ACOS function
1. How to use the ACOS function
ACOT function
1. How to use the ACOT function
Add-in
1. Split data across multiple sheets – VBA
ADDRESS function
1. 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 unique distinct values from a multi-column cell range
4. How to use the AGGREGATE function
AMORLINC function
AND function
2. How to use the AND function
3. Search for a text string in a data set and return multiple records
4. Working with Relational Tables in Excel
Animate
1. How to animate an Excel chart
Area chart
AREAS function
1. How to use the AREAS function
ARRAY function
Arrays
1. A beginners guide to Excel array formulas
2. Working with ARRAY VARIABLES (VBA)
ARRAYTOTEXT Function
1. How to use the ARRAYTOTEXT function
ASIN function
1. How to use the ASIN function
ATAN function
1. Engineering functions – D to IMC
2. How to use the ATAN function
ATAN2 function
1. How to use the ATAN2 function
AVEDEV function
1. How to use the AVEDEV function
AVERAGE function
2. Follow stock market trends – Moving Average
3. How to use the AVERAGE function
AVERAGEA function
1. How to use the AVERAGEA function
AVERAGEIF function
1. How to use the AVERAGEIF function
AVERAGEIFS function
1. How to use the AVERAGEIFS function
Bar chart
BASE function
1. Engineering functions – D to IMC
2. How to use the BASE function
Basic formulas
1. 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. Extract numbers from a column
7. Extract specific word based on position in cell value
9. Find the most recent date that meets a particular condition
10. Formula for matching a date within a date range
11. How to create date ranges in Excel
12. How to do tiered calculations in one formula
13. How to extract numbers from a cell value
14. How to perform a two-dimensional lookup
15. How to remove numbers from a cell value
16. How to replace part of formula in all cells
17. If cell contains text from list
18. INDEX MATCH – multiple results
19. Lookup multiple values across columns and return a single value
20. Lookup with any number of criteria
21. Match two columns and return another value on the same row
22. Working with running totals
BETA.DIST function
1. How to use the BETA.DIST function
BETA.INV function
1. How to use the BETA.INV function
BETADIST function
BETAINV function
BIN2DEC function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
BIN2HEX function
1. Engineering functions – A to C
BIN2OCT function
1. Engineering functions – A to C
BINOM.DIST function
2. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. Engineering functions – A to C
2. How to use the BITAND function
BITLSHIFT function
1. Engineering functions – A to C
2. How to use the BITLSHIFT function
BITOR function
1. Engineering functions – A to C
BITRSHIFT function
1. Engineering functions – A to C
BITXOR function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Filter unique distinct records case sensitive
5. How to use the BYROW function
7. Search for a text string in a data set and return multiple records
Calendar
2. Highlight events in a yearly calendar
5. Plot date ranges in a calendar
Candlestick chart
Case sensitive
1. Count unique distinct values
CEILING function
1. How to use the CEILING function
CELL function
1. How to use the CELL function
2. INDEX MATCH – multiple results
CF-basic-formulas
1. Working with Conditional Formatting formulas
CF-built-in
CF-compare
1. How to highlight differences and common values in lists
CF-dates
1. Advanced Date Highlighting Techniques in Excel
2. Highlight date ranges overlapping selected record [VBA]
CF-duplicates
1. Highlight duplicates in a filtered Excel Table
2. How to highlight duplicate values
CF-min-max
CF-misc
1. Advanced Techniques for Conditional Formatting
CF-search
CF-unique-distinct
1. Highlight unique values in a filtered Excel table
CHAR function
1. Easily select data using hyperlinks
2. Engineering functions – A to C
4. How to create random numbers, text strings, dates and time values
5. How to decode URL-encoded strings
6. How to extract email addresses from an Excel sheet
7. How to generate random numbers and text
8. How to use the CHAR function
9. Navigate to first empty cell using a hyperlink formula
10. Working with classic ciphers in Excel
Chart basics
1. Excel charts tips and tricks
Chart elements
Charts
1. Add pictures to a chart axis
2. Advanced Excel Chart Techniques
3. Change chart axis range programmatically
4. Color chart columns based on cell color
5. Compare data in an Excel chart using drop down lists
8. Excel charts tips and tricks
10. Highlight a data series in a chart
12. How to add horizontal line to chart
13. How to animate an Excel chart
14. How to color chart bars based on their values
15. How to create an interactive Excel chart
16. How to create charts in Excel
17. How to improve your Excel Chart
18. How to position month and year between chart tick marks
19. How to use mouse hover on a worksheet [VBA]
20. Use drop down lists and named ranges to filter chart values
Check-boxes
1. Add checkboxes and copy values – VBA
CHIDIST function
CHIINV function
CHISQ.DIST function
2. How to use the CHISQ.DIST function
CHISQ.DIST.RT function
1. How to use the CHISQ.DIST.RT function
CHISQ.INV function
1. How to use the CHISQ.INV function
CHISQ.INV.RT function
1. How to use the CHISQ.INV.RT function
CHISQ.TEST function
1. How to use the CHISQ.TEST function
CHITEST function
CHOOSE function
1. How to perform a two-dimensional lookup
2. How to use the CHOOSE function
3. Split data across multiple sheets – VBA
CHOOSECOLS function
1. Array Manipulation Functions
CHOOSEROWS function
1. Array Manipulation Functions
CLEAN function
1. How to use the CLEAN function
CODE function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. How to use the CODE function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Column
Column chart
1. 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. Array Manipulation Functions
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Count identical values if they are on the same row
8. Count unique distinct values
9. Create a quartely date range
11. Excel calendar
12. Extract a list of duplicates from a column
13. Extract a unique distinct list and sum amounts based on a condition
14. Extract duplicates from a multi-column cell range
15. Extract records between two dates
16. Extract unique distinct values from a multi-column cell range
17. Filter unique distinct records
18. Filter unique distinct records case sensitive
19. Filter values in common between two cell ranges
20. Filter values occurring in range 1 but not in range 2
21. Fuzzy VLOOKUP
22. Get date ranges from a schedule
23. Group rows based on a condition
24. How to extract email addresses from an Excel sheet
25. How to generate a round-robin tournament
26. How to list unique distinct values sorted by frequency
27. How to perform a two-dimensional lookup
28. How to quickly find the maximum or minimum value [Formula]
29. How to return a value if lookup value is in a range
30. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
32. How to use Pivot Tables – Excel’s most powerful feature and also least known
33. How to use the COLUMN function
35. INDEX MATCH – multiple results
36. List all unique distinct rows in a given month
37. Lookup with any number of criteria
38. Match two criteria and return multiple records
39. Merge tables based on a condition
40. Partial match for multiple strings – AND logic
41. Rearrange values in a cell range to a single column
42. Remove common records between two data sets
43. Sort a column alphabetically
44. Sort based on frequency row-wise
45. Sort values by corresponding text arranged in a column
46. Split data across multiple sheets – VBA
47. Unique distinct records sorted based on count or frequency
48. VLOOKUP – Return multiple unique distinct values
49. Wildcard lookups and include or exclude criteria
50. Working with COMBO BOXES [Form Controls]
51. Working with Relational Tables in Excel
52. Working with unique values
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
5. Extract all rows from a range that meet criteria in one column
6. Filter unique distinct records
7. Filter unique distinct records case sensitive
8. How to color chart bars based on their values
9. How to compare two data sets
10. How to copy non contiguous cell ranges
11. How to create date ranges in Excel
12. How to extract rows containing digits [Formula]
13. How to return a value if lookup value is in a range
14. How to use the COLUMNS function
15. How to use the MAKEARRAY function
16. Identify rows of overlapping records
17. If cell contains text from list
18. Match two criteria and return multiple records
19. Partial match with two conditions and return multiple results
20. Populate drop down list with unique distinct values sorted from A to Z
21. Rearrange values in a cell range to a single column
22. Rearrange values using formulas
23. Search for a text string in a data set and return multiple records
24. Sort a column alphabetically
26. Split data across multiple sheets – VBA
27. Use a drop down list to search and return multiple values
28. VLOOKUP/XLOOKUP of three columns to pull a single record
29. Working with Relational Tables in Excel
COMBIN function
1. How to generate a round-robin tournament
2. How to use the COMBIN function
COMBINA function
1. How to use the COMBINA function
Combination chart
Combinations
1. Identify numbers in sum using Excel solver
Combine Merge
1. Group rows based on a condition
2. Merge cell ranges into one list
3. Merge tables based on a condition
4. Merge two columns with possible blank cells
Combobox
1. Working with COMBO BOXES [Form Controls]
Compare
1. Compare tables: Filter records occurring only in one table
2. Compare two columns and extract differences
3. Compare two columns in different worksheets
4. Extract shared values between two columns
5. Filter values in common between two cell ranges
6. Filter values occurring in range 1 but not in range 2
7. Filter values that exists in all three columns
8. How to highlight differences and common values in lists
9. What values are missing in List 1 that exists i List 2?
COMPLEX function
1. Engineering functions – A to C
2. Engineering functions – IMD to Z
Complex numbers
CONCAT function
1. How to extract numbers from a cell value
2. How to use the CONCAT function
Concatenate
2. Concatenate unique distinct values
3. Lookup and return multiple values concatenated into one cell
CONCATENATE function
2. How to use the CONCATENATE function
Conditional formatting
1. Advanced Date Highlighting Techniques in Excel
2. Advanced Techniques for Conditional Formatting
4. Highlight date ranges overlapping selected record [VBA]
5. Highlight duplicates in a filtered Excel Table
6. Highlight unique values in a filtered Excel table
7. How to highlight differences and common values in lists
8. How to highlight duplicate values
9. Working with Conditional Formatting formulas
CONFIDENCE
CONFIDENCE.NORM
1. How to use the CONFIDENCE.NORM function
CONFIDENCE.T function
1. How to use the CONFIDENCE.T function
CONVERT function
1. Engineering functions – A to C
CORREL function
1. How to use the CORREL function
COS function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
3. How to use the COS function
COT function
1. How to use the COT function
Count
1. Count a specific text string in a cell
2. Count cells containing text from list
COUNT function
1. Count unique distinct values
2. Create a dynamic named range
3. Create dependent drop down lists containing unique distinct values
4. Extract specific word based on position in cell value
6. How to create date ranges in Excel
7. How to use the COUNT function
8. If cell contains text from list
9. Search for a text string in a data set and return multiple records
Count text values
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
3. Count cells between specified values
4. Count cells containing text from list
5. Count identical values if they are on the same row
6. Count unique distinct values
7. Count unique distinct values based on a condition
8. Count unique distinct values that meet multiple criteria
9. How to count the number of values separated by a delimiter
10. Most frequent value between two dates
COUNTA function
1. Add values to a regular drop-down list programmatically
2. Automate net asset value (NAV) calculation on your stock portfolio
3. Compare the performance of your stock portfolio to S&P 500 using Excel
4. Count unique distinct values
5. Create a dynamic named range
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. Lookup with any number of criteria
14. Match two criteria and return multiple records
15. Use drop down lists and named ranges to filter chart values
16. Wildcard lookups and include or exclude criteria
COUNTBLANK function
1. How to use the COUNTBLANK function
COUNTIF
COUNTIF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare the performance of your stock portfolio to S&P 500 using Excel
8. Compare two columns and extract differences
9. Compare two columns in different worksheets
11. Convert array formula to a regular formula
12. Count unique distinct values
13. Count unique distinct values based on a condition
14. Count unique distinct values that meet multiple criteria
16. Create dependent drop down lists containing unique distinct values
18. Date and Time Functions – N to Z
20. Extract a list of alphabetically sorted duplicates based on a condition
21. Extract a list of duplicates from a column
22. Extract a list of duplicates from three columns combined
23. Extract a unique distinct list and sum amounts based on a condition
24. Extract a unique distinct list from multiple non adjacent cell ranges
25. Extract a unique distinct list sorted from A to Z
26. Extract all rows from a range that meet criteria in one column
27. Extract duplicate values with exceptions
28. Extract duplicates from a multi-column cell range
29. Extract shared values between two columns
30. Extract unique distinct values from a multi-column cell range
31. Extract unique distinct values if the value contains the given string
32. Extract unique distinct values in a filtered list
33. Extract unique distinct values sorted based on sum of adjacent values
34. Filter duplicate values based on criteria
35. Filter unique distinct records
36. Filter unique distinct values based on a date range
37. Filter values in common between two cell ranges
38. Filter values occurring in range 1 but not in range 2
39. Filter values that exists in all three columns
40. Find all sequences of consecutive dates
43. Find the most recent date that meets a particular condition
44. Get date ranges from a schedule
45. Group rows based on a condition
46. Highlight duplicates in a filtered Excel Table
47. Highlight unique values in a filtered Excel table
48. How to build a Team Generator – different number of people per team
49. How to generate a round-robin tournament
50. How to highlight duplicate values
51. How to list unique distinct values sorted by frequency
52. How to perform a two-dimensional lookup
53. How to rank text uniquely without duplicates
54. How to return a value if lookup value is in a range
55. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
56. How to use the COUNTIF function
57. How to use VLOOKUP/XLOOKUP with multiple conditions
58. If cell contains text from list
59. INDEX MATCH – multiple results
60. Lookup with any number of criteria
61. Match two criteria and return multiple records
62. Most frequent value between two dates
63. Partial match and return multiple adjacent values
64. Partial match for multiple strings – AND logic
65. Plot date ranges in a calendar
66. Populate drop down list with unique distinct values sorted from A to Z
67. Repeat values across cells
68. Rotating unique groups with no repeat
69. Sort a column alphabetically
70. Sort a range from A to Z [Array formula]
71. Sort based on frequency row-wise
72. Sort rows based on frequency and criteria
73. Sort text cells alphabetically from two columns
74. Sort values by corresponding text arranged in a column
76. SUMPRODUCT – multiple criteria
77. Team Generator
79. Use a drop down list to search and return multiple values
80. VLOOKUP – Return multiple unique distinct values
81. What values are missing in List 1 that exists i List 2?
82. Working with COMBO BOXES [Form Controls]
83. Working with unique values
COUNTIFS function
1. Assign records unique random text strings
2. Calculate machine utilization
3. Compare tables: Filter records occurring only in one table
4. Convert date ranges into dates
5. Count cells containing text from list
6. Count unique distinct values based on a condition
7. Extract a list of alphabetically sorted duplicates based on a condition
8. Extract a list of duplicates from a column
9. Extract dates from overlapping date ranges
10. Extract unique distinct values in a filtered list
11. Filter unique distinct records
13. How to compare two data sets
14. How to highlight differences and common values in lists
15. How to return a value if lookup value is in a range
17. How to use Pivot Tables – Excel’s most powerful feature and also least known
18. How to use the COUNTIFS function
19. Identify rows of overlapping records
20. Lookup multiple values across columns and return a single value
21. Match two columns and return another value on the same row
22. Match two criteria and return multiple records
23. Merge tables based on a condition
24. Prevent duplicate records in a worksheet
25. Remove common records between two data sets
26. Search for a sequence of cells based on wildcard search
27. Search for a sequence of values
28. Sort rows based on frequency and criteria
29. Split data across multiple sheets – VBA
30. Unique distinct records sorted based on count or frequency
31. VLOOKUP/XLOOKUP of three columns to pull a single record
32. Watch schedule that populates vacation time
33. Working with Conditional Formatting formulas
34. Working with overlapping date ranges
35. Working with Relational Tables in Excel
COVAR function
COVARIANCE.P function
1. How to use the COVARIANCE.P function
COVARIANCE.S function
1. How to use the COVARIANCE.S function
CRITBINOM function
CSC function
1. How to use the CSC function
CUMIPMT function
CUMPRINC function
Custom charts
1. Advanced Excel Chart Techniques
Data labels
Data validation
2. Prevent duplicate records in a worksheet
Date and Time
DATE function
1. Count unique distinct values
2. Count unique distinct values that meet multiple criteria
3. Create a quartely date range
4. Create date ranges that stay within month
5. Date and Time Functions – A to M
6. Date and Time Functions – N to Z
8. Get date ranges from a schedule
9. Highlight events in a yearly calendar
10. How to create date ranges in Excel
11. How to track sector performance in the stock market – Excel template
12. How to use the DATE function
13. List all unique distinct rows in a given month
15. Plot date ranges in a calendar
16. Populate drop down list with unique distinct values sorted from A to Z
17. Split data across multiple sheets – VBA
18. Watch schedule that populates vacation time
20. Yet another Excel Calendar
DATEDIF function
1. Date and Time Functions – A to M
2. How to use the DATEDIF function
Dates
1. Calculate machine utilization
2. Convert date ranges into dates
3. Create date ranges that stay within month
4. Extract dates from overlapping date ranges
5. Filter unique distinct values based on a date range
6. Find all sequences of consecutive dates
7. Find the most recent date that meets a particular condition
8. Formula for matching a date within a date range
9. Get date ranges from a schedule
10. Highlight date ranges overlapping selected record [VBA]
11. How to create date ranges in Excel
12. Identify rows of overlapping records
13. List all unique distinct rows in a given month
14. Most frequent value between two dates
16. 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 unique distinct values based on a date range
6. Find all sequences of consecutive dates
7. Find the most recent date that meets a particular condition
8. Formula for matching a date within a date range
9. Get date ranges from a schedule
10. How to create date ranges in Excel
11. List all unique distinct rows in a given month
12. 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
3. How to use the DATEVALUE function
DAVERAGE function
DAY function
1. Automate net asset value (NAV) calculation on your stock portfolio
3. Change chart axis range programmatically
4. Date and Time Functions – A to M
5. Date and Time Functions – N to Z
6. Get date ranges from a schedule
7. How to calculate and plot pivots on an Excel chart
8. How to track sector performance in the stock market – Excel template
9. How to use the DAY function
11. Populate drop down list with unique distinct values sorted from A to Z
DAYS function
1. Date and Time Functions – A to M
2. How to use the DAYS function
DB function
DCOUNT function
DDB function
DEC2BIN function
1. Engineering functions – A to C
2. Engineering functions – D to IMC
3. Working with classic ciphers in Excel
DEC2HEX function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
DEC2OCT function
1. Engineering functions – D to IMC
DECIMAL function
1. How to use the DECIMAL function
DEGREES function
1. Engineering functions – D to IMC
2. How to use the DEGREES function
DELTA function
1. Engineering functions – D to IMC
Dependent drop down lists
1. Create dependent drop down lists containing unique distinct values
DGET function
Dialog boxes
DMAX function
DMIN function
DO LOOP statement
Doughnut chart
DOUNTA function
DPRODUCT function
Drop down lists
1. Advanced Techniques for Conditional Formatting
2. Compare data in an Excel chart using drop down lists
4. Populate drop down list with filtered Excel Table values
5. Populate drop down list with unique distinct values sorted from A to Z
6. Run a Macro from a Drop Down list [VBA]
7. Use a drop down list to search and return multiple values
DROP function
1. Array Manipulation Functions
2. Calculate machine utilization
3. Convert date ranges into dates
4. Filter strings containing a given substring in a cell range
5. Filter unique distinct records case sensitive
6. Group rows based on a condition
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 values that exists in all three columns
DVARP function
EDATE function
1. Date and Time Functions – A to M
3. How to use the EDATE function
EFFECT function
ENCODEURL function
1. How to use the ENCODEURL function
EOMONTH function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
3. How to use the EOMONTH function
ERROR.TYPE function
1. How to use the ERROR.TYPE function
Evaluate method
EVEN function
1. How to use the EVEN function
EXACT function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Count unique distinct values
4. Extract shared values between two columns
5. How to extract a case sensitive unique list from a column
6. How to use the EXACT function
7. If cell contains text from list
8. INDEX MATCH – multiple results
9. Match two columns and return another value on the same row
Excel Basics
1. How to improve worksheet readability in Excel
2. How to replace part of formula in all cells
3. How to select and delete blank cells
4. 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
FALSE function
1. Advanced Excel Chart Techniques
2. Array Manipulation Functions
3. Automate net asset value (NAV) calculation on your stock portfolio
4. Extract a list of duplicates from a column
5. Get date ranges from a schedule
6. How to generate a round-robin tournament
7. How to use mouse hover on a worksheet [VBA]
8. How to use the asterisk character
9. How to use VLOOKUP/XLOOKUP with multiple conditions
10. If cell contains text from list
11. INDEX MATCH – multiple results
12. Match two criteria and return multiple records
13. Merge tables based on a condition
14. Plot date ranges in a calendar
15. Populate drop down list with unique distinct values sorted from A to Z
16. Rearrange values in a cell range to a single column
17. Repeat values across cells
18. Search for a text string in a data set and return multiple records
19. SUMPRODUCT and IF function
20. Unique distinct records sorted based on count or frequency
21. VLOOKUP – Return multiple unique distinct values
22. Working with classic ciphers in Excel
23. Working with Relational Tables in Excel
24. Working with unique values
FDIST function
Features
1. 5 easy ways to extract Unique Distinct Values
2. Advanced Techniques for Conditional Formatting
3. Compare data in an Excel chart using drop down lists
4. Create a dynamic named range
5. Create dependent drop down lists containing unique distinct values
7. Extract unique distinct values in a filtered list
8. Highlight duplicates in a filtered Excel Table
9. How to compare two data sets
10. How to create a dynamic pivot table and refresh automatically
11. How to solve simultaneous linear equations in Excel
12. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
15. How to use Pivot Tables – Excel’s most powerful feature and also least known
16. How to use the COMBIN function
18. How to use the Subtotal tool
19. Identify numbers in sum using Excel solver
20. Lookup with any number of criteria
22. Populate drop down list with filtered Excel Table values
23. Populate drop down list with unique distinct values sorted from A to Z
24. Prevent duplicate records in a worksheet
25. Run a Macro from a Drop Down list [VBA]
26. Use a drop down list to search and return multiple values
27. Working with Excel tables programmatically
Files and folders
1. Copy data from workbooks in folder and subfolders
2. Filter duplicate files in a folder and subfolders
3. Search all workbooks in a folder
4. Search for a file in folder and subfolders – UDF
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
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
8. Count unique distinct values based on a condition
9. Count unique distinct values that meet multiple criteria
10. Create dependent drop down lists containing unique distinct values
11. Date and Time Functions – A to M
12. Date and Time Functions – N to Z
13. Engineering functions – A to C
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 sum amounts based on a condition
18. Extract a unique distinct list sorted from A to Z
19. Extract all rows from a range that meet criteria in one column
20. Extract dates from overlapping date ranges
21. Extract duplicate values with exceptions
22. Extract duplicates from a multi-column cell range
23. Extract numbers from a column
24. Extract records between two dates
25. Extract shared values between two columns
26. Extract unique distinct values from a multi-column cell range
27. Extract unique distinct values in a filtered list
28. Extract unique distinct values sorted based on sum of adjacent values
29. Filter duplicate values based on criteria
30. Filter strings containing a given substring in a cell range
31. Filter unique distinct records
32. Filter unique distinct records case sensitive
33. Filter unique distinct values based on a date range
34. Filter values in common between two cell ranges
35. Filter values occurring in range 1 but not in range 2
36. Find all sequences of consecutive dates
38. Find the most recent date that meets a particular condition
39. Get date ranges from a schedule
40. Group rows based on a condition
41. How to compare two data sets
42. How to create date ranges in Excel
43. How to extract a case sensitive unique list from a column
44. How to extract email addresses from an Excel sheet
45. How to extract rows containing digits [Formula]
46. How to list unique distinct values sorted by frequency
47. How to return a value if lookup value is in a range
48. How to use the FILTER function
49. How to use VLOOKUP/XLOOKUP with multiple conditions
50. Identify rows of overlapping records
51. If cell contains text from list
52. INDEX MATCH – multiple results
53. List all unique distinct rows in a given month
54. Lookup and return multiple sorted values based on corresponding values in another column
55. Lookup and return multiple values concatenated into one cell
56. Lookup multiple values across columns and return a single value
57. Lookup multiple values in one cell
58. Match two criteria and return multiple records
59. Merge two columns with possible blank cells
61. Partial match and return multiple adjacent values
62. Partial match for multiple strings – AND logic
63. Partial match with two conditions and return multiple results
64. Reverse a list ignoring blanks
65. Search for a sequence of cells based on wildcard search
66. Search for a sequence of values
67. Search for a text string in a data set and return multiple records
69. VLOOKUP – Return multiple unique distinct values
70. VLOOKUP/XLOOKUP of three columns to pull a single record
71. What values are missing in List 1 that exists i List 2?
72. Wildcard lookups and include or exclude criteria
74. Working with overlapping date ranges
75. Working with Relational Tables in Excel
76. 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. How to use the FILTERXML function
3. How to use the LIKE OPERATOR
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. All you need to know about calculating NAV units for your stock portfolio
2. Automate net asset value (NAV) calculation on your stock portfolio
4. Compare the performance of your stock portfolio to S&P 500 using Excel
5. Follow stock market trends – Moving Average
6. How to calculate and plot pivots on an Excel chart
7. How to track sector performance in the stock market – Excel template
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 – multiple results
5. Search for a sequence of cells based on wildcard search
6. Search for a text string in a data set and return multiple records
7. Working with classic ciphers in Excel
Find numbers in sum
1. Find numbers closest to sum
2. How to do tiered calculations in one formula
3. Identify numbers in sum using Excel solver
Fix Function
FIXED function
1. How to use the FIXED function
FLOOR function
FLOOR.MATH function
1. How to use the FLOOR.MATH function
FLOOR.PRECISE function
1. How to use the FLOOR.PRECISE function
FOR NEXT statement
1. Create links to all sheets in a workbook programmatically
2. Finding the shortest path – A * pathfinding
3. Resize a range of values (UDF)
4. 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 copy non contiguous cell ranges
2. Working with COMBO BOXES [Form Controls]
Funnel chart
Fuzzy lookup
FV function
GAMMA.DIST function
1. How to use the GAMMA.DIST function
GAMMADIST function
Gantt
GCD function
1. How to use the GCD function
GDC function
1. How to use the GCD function
GEOMEAN function
1. How to use the GEOMEAN function
GoTo statement
GROWTH function
1. How to use the GROWTH function
HARMEAN function
1. How to use the HARMEAN function
HEX2BIN function
1. Engineering functions – D to IMC
HEX2DEC function
1. Engineering functions – D to IMC
2. How to decode URL-encoded strings
3. Working with classic ciphers in Excel
HEX2OCT function
1. Engineering functions – D to IMC
Highlight
1. Highlight a data series in a chart
Highlight Cells Rules
1. Conditional Formatting Basics
Highlight duplicates
Histogram chart
HLOOKUP function
1. How to use the HLOOKUP function
HOUR function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
3. How to use the HOUR function
HSTACK function
1. Array Manipulation Functions
2. Calculate machine utilization
3. Date and Time Functions – N to Z
4. Extract a unique distinct list and sum amounts based on a condition
7. Get date ranges from a schedule
8. Group rows based on a condition
9. How to create date ranges in Excel
10. Sort rows based on frequency and criteria
11. 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. How to quickly find the maximum or minimum value [Formula]
4. How to use mouse hover on a worksheet [VBA]
5. How to use the HYPERLINK function
6. INDEX MATCH – multiple results
7. 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. Navigate to first empty cell using a hyperlink formula
HYPGEOM.DIST function
1. How to use the HYPGEOM.DIST function
IF
IF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. A Comprehensive Guide to Splitting Text in Excel
4. Array Manipulation Functions
5. Automate net asset value (NAV) calculation on your stock portfolio
8. Calculate machine utilization
9. Change chart axis range programmatically
10. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
11. Compare tables: Filter records occurring only in one table
12. Compare the performance of your stock portfolio to S&P 500 using Excel
13. Compare two columns and extract differences
14. Compare two columns in different worksheets
15. Concatenate unique distinct values
16. Convert array formula to a regular formula
17. Convert date ranges into dates
18. Count a specific text string in a cell
19. Count cells between specified values
20. Count cells containing text from list
21. Count unique distinct records
22. Count unique distinct values
23. Count unique distinct values based on a condition
24. Count unique distinct values that meet multiple criteria
25. Create a hyperlink linked to the result of a two-dimensional lookup
26. Create a quartely date range
28. Create date ranges that stay within month
29. Create dependent drop down lists containing unique distinct values
31. Date and Time Functions – A to M
32. Date and Time Functions – N to Z
34. Excel calendar
35. Extract a list of alphabetically sorted duplicates based on a condition
36. Extract a list of duplicates from a column
37. Extract a unique distinct list from multiple non adjacent cell ranges
38. Extract a unique distinct list sorted from A to Z
39. Extract all rows from a range that meet criteria in one column
40. Extract dates from overlapping date ranges
41. Extract duplicates from a multi-column cell range
42. Extract numbers from a column
43. Extract records between two dates
44. Extract shared values between two columns
45. Extract specific word based on position in cell value
46. Extract unique distinct values from a multi-column cell range
47. Extract unique distinct values in a filtered list
48. Extract unique distinct values sorted based on sum of adjacent values
49. Filter duplicate values based on criteria
50. Filter strings containing a given substring in a cell range
51. Filter unique distinct records
52. Filter unique distinct values based on a date range
53. Filter values in common between two cell ranges
54. Filter values occurring in range 1 but not in range 2
55. Find all sequences of consecutive dates
56. Find and return the highest number and corresponding date based on a condition
58. Find empty hours in a weekly schedule
60. Find numbers closest to sum
61. Find the most recent date that meets a particular condition
62. Follow stock market trends – Moving Average
63. Formula for matching a date within a date range
64. Fuzzy VLOOKUP
65. Get date ranges from a schedule
66. Group rows based on a condition
67. Highlight duplicates in a filtered Excel Table
68. Highlight unique values in a filtered Excel table
69. How to calculate and plot pivots on an Excel chart
70. How to color chart bars based on their values
71. How to compare two data sets
72. How to create date ranges in Excel
73. How to create random numbers, text strings, dates and time values
74. How to decode URL-encoded strings
75. How to extract a case sensitive unique list from a column
76. How to extract email addresses from an Excel sheet
77. How to extract numbers from a cell value
78. How to extract rows containing digits [Formula]
79. How to generate a round-robin tournament
80. How to highlight duplicate values
81. How to list unique distinct values sorted by frequency
82. How to perform a two-dimensional lookup
83. How to replace part of formula in all cells
84. How to return a value if lookup value is in a range
85. How to select and delete blank cells
86. How to track sector performance in the stock market – Excel template
88. How to use the IF function
89. How to use VLOOKUP/XLOOKUP with multiple conditions
90. Identify rows of overlapping records
91. If cell contains text from list
93. INDEX MATCH – multiple results
94. List all unique distinct rows in a given month
95. Lookup and return multiple sorted values based on corresponding values in another column
96. Lookup and return multiple values concatenated into one cell
97. Lookup multiple values across columns and return a single value
99. Lookup with any number of criteria
100. Match two criteria and return multiple records
101. Merge cell ranges into one list
102. Merge tables based on a condition
103. Merge two columns with possible blank cells
104. Monthly calendar template
105. Most frequent value between two dates
106. Partial match and return multiple adjacent values
107. Partial match for multiple strings – AND logic
108. Partial match with two conditions and return multiple results
109. Pivot Table calendar
110. Plot date ranges in a calendar
111. Populate drop down list with filtered Excel Table values
112. Populate drop down list with unique distinct values sorted from A to Z
113. Practice basic arithmetic calculations in Excel
114. Rearrange data
115. Remove common records between two data sets
116. Remove duplicates within same month or year
117. Repeat values across cells
118. Reverse a list ignoring blanks
119. Rotating unique groups with no repeat
120. Search for a sequence of cells based on wildcard search
121. Search for a sequence of values
122. Search for a text string in a data set and return multiple records
123. Sort a column alphabetically
124. Sort a range from A to Z [Array formula]
125. Sort based on frequency row-wise
126. Sort rows based on frequency and criteria
127. Sort values by corresponding text arranged in a column
128. Split data across multiple sheets – VBA
129. Split expenses calculator
130. Split search value using a delimiter and search for each substring
131. SUMPRODUCT and IF function
132. Time sheet for work
133. Unique distinct records sorted based on count or frequency
134. Use a drop down list to search and return multiple values
135. Use drop down lists and named ranges to filter chart values
136. VLOOKUP – Return multiple unique distinct values
137. VLOOKUP/XLOOKUP of three columns to pull a single record
138. Watch schedule that populates vacation time
139. What values are missing in List 1 that exists i List 2?
140. Wildcard lookups and include or exclude criteria
141. Working with classic ciphers in Excel
142. Working with COMBO BOXES [Form Controls]
144. Working with overlapping date ranges
145. Working with Relational Tables in Excel
146. Working with running totals
147. Working with unique values
IF THEN ELSE statement
2. Run a Macro from a Drop Down list [VBA]
3. Show / hide a picture using a button
4. 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
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare the performance of your stock portfolio to S&P 500 using Excel
7. Compare two columns and extract differences
8. Count a specific text string in a cell
9. Count cells between specified values
10. Count unique distinct records
11. Date and Time Functions – N to Z
13. Excel calendar
14. Extract a list of duplicates from a column
15. Extract a list of duplicates from three columns combined
16. Extract a unique distinct list from multiple non adjacent cell ranges
17. Extract a unique distinct list sorted from A to Z
18. Extract duplicate values with exceptions
19. Extract records between two dates
20. Extract specific word based on position in cell value
21. Extract unique distinct values from a multi-column cell range
22. Filter duplicate values based on criteria
23. Filter unique distinct records
24. Filter unique distinct values based on a date range
25. Filter values that exists in all three columns
26. Find all sequences of consecutive dates
28. Follow stock market trends – Moving Average
29. Fuzzy VLOOKUP
30. Get date ranges from a schedule
31. Group rows based on a condition
32. How to build a Team Generator – different number of people per team
33. How to calculate and plot pivots on an Excel chart
34. How to extract rows containing digits [Formula]
35. How to generate a round-robin tournament
36. How to perform a two-dimensional lookup
38. How to use the IFERROR function
40. Identify rows of overlapping records
41. If cell contains text from list
42. List all unique distinct rows in a given month
43. Lookup and return multiple values concatenated into one cell
45. Lookup with any number of criteria
46. Merge cell ranges into one list
47. Merge two columns with possible blank cells
48. Plot date ranges in a calendar
49. Populate drop down list with filtered Excel Table values
50. Remove common records between two data sets
51. Search for a text string in a data set and return multiple records
52. Sort rows based on frequency and criteria
53. Sort text cells alphabetically from two columns
54. Split data across multiple sheets – VBA
56. Split search value using a delimiter and search for each substring
57. Team Generator
59. Use a drop down list to search and return multiple values
60. Watch schedule that populates vacation time
61. Wildcard lookups and include or exclude criteria
62. Working with classic ciphers in Excel
63. Working with COMBO BOXES [Form Controls]
64. Working with overlapping date ranges
65. Working with Relational Tables in Excel
66. 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
6. Working with Relational Tables in Excel
IFS function
1. How to use the IFS function
IMABS function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMAGE function
1. How to use the IMAGE function
IMAGINARY function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMARGUMENT function
1. Engineering functions – D to IMC
IMCONJUGATE function
1. Engineering functions – D to IMC
IMCOS function
1. Engineering functions – D to IMC
IMCOSH function
1. Engineering functions – D to IMC
IMCOT function
1. Engineering functions – D to IMC
IMCSC function
1. Engineering functions – D to IMC
IMCSCH function
1. Engineering functions – D to IMC
IMDIV function
1. Engineering functions – IMD to Z
IMEXP function
1. Engineering functions – IMD to Z
IMLN
IMLOG10 function
1. Engineering functions – IMD to Z
IMLOG2 function
1. Engineering functions – IMD to Z
IMPOWER function
1. Engineering functions – IMD to Z
2. How to use the IMPOWER function
IMPRODUCT function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMREAL function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
IMSEC function
1. Engineering functions – IMD to Z
IMSECH function
1. Engineering functions – IMD to Z
IMSIN function
1. Engineering functions – IMD to Z
IMSINH function
1. Engineering functions – IMD to Z
IMSQRT function
1. Engineering functions – IMD to Z
IMSUB function
1. Engineering functions – IMD to Z
IMSUM function
1. Engineering functions – IMD to Z
IMTAN function
1. Engineering functions – IMD to Z
INDEX + MATCH
1. INDEX MATCH – multiple results
2. Lookup multiple values across columns and return a single value
INDEX 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. Assign records unique random text strings
5. Automate net asset value (NAV) calculation on your stock portfolio
7. Calculate machine utilization
8. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
9. Compare tables: Filter records occurring only in one table
10. Compare the performance of your stock portfolio to S&P 500 using Excel
11. Compare two columns and extract differences
12. Compare two columns in different worksheets
14. Convert array formula to a regular formula
15. Count a specific text string in a cell
16. Count cells containing text from list
17. Create a hyperlink linked to the result of a two-dimensional lookup
19. Create dependent drop down lists containing unique distinct values
20. Date and Time Functions – A to M
23. Excel calendar
24. Extract a list of alphabetically sorted duplicates based on a condition
25. Extract a list of duplicates from a column
26. Extract a unique distinct list and sum amounts based on a condition
27. Extract a unique distinct list from multiple non adjacent cell ranges
28. Extract a unique distinct list sorted from A to Z
29. Extract all rows from a range that meet criteria in one column
30. Extract duplicates from a multi-column cell range
31. Extract numbers from a column
32. Extract records between two dates
33. Extract shared values between two columns
34. Extract specific word based on position in cell value
35. Extract unique distinct values from a multi-column cell range
36. Extract unique distinct values in a filtered list
37. Extract unique distinct values sorted based on sum of adjacent values
38. Filter duplicate values based on criteria
39. Filter unique distinct records
40. Filter unique distinct records case sensitive
41. Filter unique distinct values based on a date range
42. Filter values in common between two cell ranges
43. Filter values occurring in range 1 but not in range 2
44. Filter values that exists in all three columns
47. Find numbers closest to sum
48. Find the most recent date that meets a particular condition
49. Follow stock market trends – Moving Average
50. Formula for matching a date within a date range
51. Fuzzy lookups
52. Fuzzy VLOOKUP
53. Get date ranges from a schedule
54. Group rows based on a condition
55. Highlight a data series in a chart
56. How to animate an Excel chart
57. How to build a Team Generator – different number of people per team
58. How to compare two data sets
59. How to copy non contiguous cell ranges
60. How to create date ranges in Excel
61. How to extract a case sensitive unique list from a column
62. How to extract email addresses from an Excel sheet
63. How to extract rows containing digits [Formula]
64. How to generate a round-robin tournament
65. How to generate random numbers and text
66. How to highlight differences and common values in lists
67. How to list unique distinct values sorted by frequency
68. How to perform a two-dimensional lookup
69. How to quickly find the maximum or minimum value [Formula]
70. How to replace part of formula in all cells
71. How to return a value if lookup value is in a range
72. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
75. How to use Pivot Tables – Excel’s most powerful feature and also least known
76. How to use the INDEX function
77. How to use the MAKEARRAY function
79. How to use VLOOKUP/XLOOKUP with multiple conditions
80. If cell contains text from list
81. INDEX MATCH – multiple results
82. List all unique distinct rows in a given month
83. Lookup and return multiple sorted values based on corresponding values in another column
84. Lookup multiple values across columns and return a single value
86. Lookup with any number of criteria
87. Match two columns and return another value on the same row
88. Match two criteria and return multiple records
89. Merge cell ranges into one list
90. Merge tables based on a condition
91. Merge two columns with possible blank cells
92. Most frequent value between two dates
93. Partial match and return multiple adjacent values
94. Partial match for multiple strings – AND logic
95. Partial match with two conditions and return multiple results
97. Plot date ranges in a calendar
98. Populate drop down list with filtered Excel Table values
99. Populate drop down list with unique distinct values sorted from A to Z
100. Rearrange values in a cell range to a single column
101. Rearrange values using formulas
102. Remove common records between two data sets
103. Remove duplicates within same month or year
104. Repeat values across cells
105. Reverse a list ignoring blanks
106. Rotating unique groups with no repeat
107. Search for a text string in a data set and return multiple records
108. Show / hide a picture using a button
109. Sort a column alphabetically
110. Sort a range from A to Z [Array formula]
111. Sort based on frequency row-wise
113. Sort rows based on frequency and criteria
114. Sort text cells alphabetically from two columns
115. Sort values by corresponding text arranged in a column
116. Split data across multiple sheets – VBA
117. Split expenses calculator
118. Team Generator
119. Time sheet for work
120. Unique distinct records sorted based on count or frequency
121. Use a drop down list to search and return multiple values
122. Use drop down lists and named ranges to filter chart values
124. VLOOKUP – Return multiple unique distinct values
125. VLOOKUP/XLOOKUP of three columns to pull a single record
126. Watch schedule that populates vacation time
127. What values are missing in List 1 that exists i List 2?
128. Wildcard lookups and include or exclude criteria
129. Working with classic ciphers in Excel
130. Working with COMBO BOXES [Form Controls]
131. Working with overlapping date ranges
132. Working with Relational Tables in Excel
133. Working with unique values
INDIRECT function
1. Add values to a regular drop-down list programmatically
2. Advanced Techniques for Conditional Formatting
3. Compare data in an Excel chart using drop down lists
4. Date and Time Functions – N to Z
5. Find empty hours in a weekly schedule
6. Highlight a data series in a chart
7. Highlight duplicates in a filtered Excel Table
8. Highlight unique values in a filtered Excel table
10. How to generate a round-robin tournament
13. How to use the INDIRECT function
14. Plot date ranges in a calendar
15. Prevent duplicate records in a worksheet
16. Watch schedule that populates vacation time
17. Working with overlapping date ranges
18. Working with Relational Tables in Excel
INFO function
1. How to use the INFO function
INT function
1. Calculate machine utilization
2. Calculate the number of weeks between given dates
3. Date and Time Functions – A to M
5. Find numbers closest to sum
7. How to generate a round-robin tournament
9. How to use the INT function
INT function
1. Calculate machine utilization
2. Calculate the number of weeks between given dates
3. Date and Time Functions – A to M
5. Find numbers closest to sum
7. How to generate a round-robin tournament
9. How to use the INT function
Interactive
1. How to create an interactive Excel chart
2. How to use mouse hover on a worksheet [VBA]
3. Use drop down lists and named ranges to filter chart values
INTERCEPT function
1. How to use the INTERCEPT function
Invoice
IPMT function
ISBLANK function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. Extract a unique distinct list sorted from A to Z
3. Extract unique distinct values from a multi-column cell range
4. How to use the ISBLANK function
5. 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
2. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Extract a list of duplicates from a column
5. Extract a unique distinct list from multiple non adjacent cell ranges
8. How to extract email addresses from an Excel sheet
9. How to generate a round-robin tournament
10. How to highlight differences and common values in lists
11. How to perform a two-dimensional lookup
12. How to use the ISERROR function
13. Match two criteria and return multiple records
14. Merge cell ranges into one list
15. Merge tables based on a condition
17. What values are missing in List 1 that exists i List 2?
18. Working with Relational Tables in Excel
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
4. Extract a unique distinct list sorted from A to Z
5. Extract duplicates from a multi-column cell range
6. Extract numbers from a column
7. Extract unique distinct values from a multi-column cell range
8. Extract unique distinct values if the value contains the given string
9. Filter strings containing a given substring in a cell range
10. How to extract email addresses from an Excel sheet
11. How to extract numbers from a cell value
12. How to use the ISNUMBER function
13. If cell contains text from list
14. INDEX MATCH – multiple results
15. Match two columns and return another value on the same row
16. Match two criteria and return multiple records
17. Partial match and return multiple adjacent values
18. Partial match for multiple strings – AND logic
19. Partial match with two conditions and return multiple results
20. Search for a sequence of cells based on wildcard search
21. Search for a text string in a data set and return multiple records
22. VLOOKUP – Return multiple unique distinct values
23. Wildcard lookups and include or exclude criteria
24. Working with classic ciphers in Excel
ISODD function
1. How to use the ISODD function
ISPMT function
ISREF function
1. How to use the ISREF function
ISTEXT function
1. Count cells containing text from list
2. Extract a unique distinct list sorted from A to Z
3. Extract unique distinct values from a multi-column cell 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. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Convert date ranges into dates
4. Filter strings containing a given substring in a cell range
5. Filter unique distinct records case sensitive
8. Group rows based on a condition
9. How to replace part of formula in all cells
10. How to use the LAMBDA function
11. How to use the MAKEARRAY function
12. Rearrange data
13. Search for a text string in a data set and return multiple records
14. 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 unique distinct values from a multi-column cell range
6. Find the most recent date that meets a particular condition
7. Follow stock market trends – Moving Average
8. How to build a Team Generator – different number of people per team
9. How to generate a round-robin tournament
10. How to use the LARGE function
11. Repeat values across cells
12. Reverse a list ignoring blanks
13. Rotating unique groups with no repeat
14. Sort a column alphabetically
15. Sort based on frequency row-wise
17. Sort rows based on frequency and criteria
18. Team Generator
19. Unique distinct records sorted based on count or frequency
Lbound Ubound function
LCM function
1. How to use the LCM function
LEFT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Date and Time Functions – A to M
3. Engineering functions – A to C
4. Extract duplicates from a multi-column cell range
5. Extract specific word based on position in cell value
6. Extract unique distinct values from a multi-column cell range
7. Formula for matching a date within a date range
9. How to calculate and plot pivots on an Excel chart
10. How to extract email addresses from an Excel sheet
11. How to use the LEFT function
12. Lookup and return multiple values concatenated into one cell
13. VLOOKUP – Return multiple unique distinct values
14. 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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Count a specific text string in a cell
5. Count cells containing text from list
6. Engineering functions – A to C
7. Extract a unique distinct list sorted from A to Z
8. Extract duplicates from a multi-column cell range
9. Extract unique distinct values from a multi-column cell range
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. INDEX MATCH – multiple results
19. List all permutations with a condition
20. Lookup and return multiple values concatenated into one cell
21. Partial match and return multiple adjacent values
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. 5 easy ways to VLOOKUP and return multiple values
3. A Comprehensive Guide to Splitting Text in Excel
4. Array Manipulation Functions
5. Calculate machine utilization
6. Calculate the number of weeks between given dates
7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
8. Compare two columns and extract differences
10. Date and Time Functions – N to Z
12. Extract a list of alphabetically sorted duplicates based on a condition
13. Extract a list of duplicates from a column
14. Extract a list of duplicates from three columns combined
15. Extract a unique distinct list and sum amounts based on a condition
16. Extract dates from overlapping date ranges
17. Extract duplicate values with exceptions
18. Extract duplicates from a multi-column cell range
19. Extract unique distinct values from a multi-column cell range
20. Extract unique distinct values in a filtered list
21. Extract unique distinct values sorted based on sum of adjacent values
22. Filter duplicate values based on criteria
23. Filter unique distinct records case sensitive
24. Find all sequences of consecutive dates
25. Find empty hours in a weekly schedule
27. Find numbers closest to sum
28. Fuzzy lookups
29. Get date ranges from a schedule
30. How to create date ranges in Excel
31. How to decode URL-encoded strings
32. How to do tiered calculations in one formula
33. How to extract a case sensitive unique list from a column
34. How to extract email addresses from an Excel sheet
35. How to extract numbers from a cell value
36. How to list unique distinct values sorted by frequency
37. How to return a value if lookup value is in a range
38. How to track sector performance in the stock market – Excel template
39. How to use the LET function
40. How to use VLOOKUP/XLOOKUP with multiple conditions
41. If cell contains text from list
42. Lookup and return multiple sorted values based on corresponding values in another column
43. Match two criteria and return multiple records
44. Merge two columns with possible blank cells
45. Repeat values across cells
46. Reverse a list ignoring blanks
47. Search for a text string in a data set and return multiple records
48. Sort a column alphabetically
49. Sort rows based on frequency and criteria
50. Sort values by corresponding text arranged in a column
52. Team Generator
53. Unique distinct records sorted based on count or frequency
54. VLOOKUP – Return multiple unique distinct values
55. Wildcard lookups and include or exclude criteria
56. Working with classic ciphers in Excel
57. Working with overlapping date ranges
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. If cell contains text from list
LOGNORM.DIST function
1. How to use the LOGNORM.DIST function
LOGNORMDIST function
LOOKUP function
1. 5 easy ways to extract Unique Distinct Values
2. Extract a list of duplicates from a column
3. Extract a list of duplicates from three columns combined
4. Extract a unique distinct list from multiple non adjacent cell ranges
5. Extract a unique distinct list sorted from A to Z
6. Extract duplicate values with exceptions
7. Extract unique distinct values if the value contains the given string
8. Formula for matching a date within a date range
9. How to return a value if lookup value is in a range
10. How to use the LOOKUP function
11. How to use VLOOKUP/XLOOKUP with multiple conditions
12. INDEX MATCH – multiple results
13. Partial match and return multiple adjacent values
14. Partial match for multiple strings – AND logic
15. Split search value using a delimiter and search for each substring
16. VLOOKUP – Return multiple unique distinct values
18. Working with unique values
Lookup numerical ranges
Lookups
2. How to perform a two-dimensional lookup
3. Lookup with any number of criteria
LOWER function
1. How to use the LOWER function
Macro
1. Add values to a regular drop-down list programmatically
2. Auto resize columns as you type
3. Copy data from workbooks in folder and subfolders
4. Copy worksheets in active workbook to new workbooks
5. Count text string in all formulas in a worksheet [VBA]
6. Create a Print button – macro
7. Create new worksheets programmatically based on values in a cell range [VBA]
8. Customize the ribbon and how to add your macros
10. Excel template: Getting Things Done [VBA]
12. Hide specific worksheets programmatically
13. Highlight date ranges overlapping selected record [VBA]
14. How to copy non contiguous cell ranges
15. How to create an interactive Excel chart
16. How to highlight row of the selected cell programmatically
17. How to save specific multiple worksheets to a pdf file programmatically
20. Run a Macro from a Drop Down list [VBA]
22. Show / hide a picture using a button
23. Sort values in a cell based on a delimiting character
24. Split data across multiple sheets – VBA
25. User opens or closes a workbook creates an event
26. Working with COMBO BOXES [Form Controls]
27. Working with comments – VBA
28. Working with Excel tables programmatically
30. 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
Maps
MATCH function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Assign records unique random text strings
4. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare the performance of your stock portfolio to S&P 500 using Excel
8. Compare two columns and extract differences
9. Compare two columns in different worksheets
11. Concatenate unique distinct values
12. Convert array formula to a regular formula
13. Count cells between specified values
14. Count rows containing data
15. Count unique distinct values
16. Create a hyperlink linked to the result of a two-dimensional lookup
18. Create dependent drop down lists containing unique distinct values
20. Date and Time Functions – A to M
23. Easily select data using hyperlinks
24. Excel calendar
25. Extract a list of alphabetically sorted duplicates based on a condition
26. Extract a list of duplicates from a column
27. Extract a list of duplicates from three columns combined
28. Extract a unique distinct list and sum amounts based on a condition
29. Extract a unique distinct list from multiple non adjacent cell ranges
30. Extract a unique distinct list sorted from A to Z
31. Extract all rows from a range that meet criteria in one column
32. Extract duplicate values with exceptions
33. Extract duplicates from a multi-column cell range
34. Extract records between two dates
35. Extract shared values between two columns
36. Extract unique distinct values from a multi-column cell range
37. Extract unique distinct values in a filtered list
38. Extract unique distinct values sorted based on sum of adjacent values
39. Filter duplicate values based on criteria
40. Filter unique distinct records
41. Filter unique distinct values based on a date range
42. Filter values in common between two cell ranges
43. Filter values occurring in range 1 but not in range 2
44. Filter values that exists in all three columns
47. Find numbers closest to sum
48. Find the most recent date that meets a particular condition
49. Follow stock market trends – Moving Average
50. Formula for matching a date within a date range
51. Get date ranges from a schedule
52. Group rows based on a condition
54. Highlight duplicates in a filtered Excel Table
55. Highlight unique values in a filtered Excel table
56. How to animate an Excel chart
57. How to build a Team Generator – different number of people per team
58. How to color chart bars based on their values
59. How to compare two data sets
60. How to extract a case sensitive unique list from a column
61. How to extract email addresses from an Excel sheet
62. How to extract rows containing digits [Formula]
63. How to generate a round-robin tournament
64. How to highlight differences and common values in lists
65. How to list unique distinct values sorted by frequency
66. How to perform a two-dimensional lookup
67. How to quickly find the maximum or minimum value [Formula]
68. How to return a value if lookup value is in a range
69. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
70. How to use Pivot Tables – Excel’s most powerful feature and also least known
71. How to use the MATCH function
72. How to use VLOOKUP/XLOOKUP with multiple conditions
73. If cell contains text from list
74. INDEX MATCH – multiple results
75. List all unique distinct rows in a given month
76. Lookup and return multiple sorted values based on corresponding values in another column
77. Lookup and return multiple values concatenated into one cell
78. Lookup multiple values across columns and return a single value
80. Lookup with any number of criteria
81. Match two columns and return another value on the same row
82. Match two criteria and return multiple records
83. Merge tables based on a condition
85. Most frequent value between two dates
86. Partial match and return multiple adjacent values
87. Partial match for multiple strings – AND logic
88. Partial match with two conditions and return multiple results
89. Plot date ranges in a calendar
90. Populate drop down list with filtered Excel Table values
91. Populate drop down list with unique distinct values sorted from A to Z
92. Remove common records between two data sets
93. Remove duplicates within same month or year
94. Repeat values across cells
95. Reverse a list ignoring blanks
96. Rotating unique groups with no repeat
97. Search for a sequence of cells based on wildcard search
98. Search for a sequence of values
99. Search for a text string in a data set and return multiple records
100. Show / hide a picture using a button
101. Sort a column alphabetically
102. Sort a range from A to Z [Array formula]
103. Sort based on frequency row-wise
105. Sort rows based on frequency and criteria
106. Sort text cells alphabetically from two columns
107. Sort values by corresponding text arranged in a column
108. Split data across multiple sheets – VBA
109. Split expenses calculator
110. Team Generator
111. Time sheet for work
112. Unique distinct records sorted based on count or frequency
113. Use a drop down list to search and return multiple values
114. Use drop down lists and named ranges to filter chart values
116. VLOOKUP – Return multiple unique distinct values
117. VLOOKUP/XLOOKUP of three columns to pull a single record
118. Watch schedule that populates vacation time
119. What values are missing in List 1 that exists i List 2?
120. Wildcard lookups and include or exclude criteria
121. Working with classic ciphers in Excel
122. Working with COMBO BOXES [Form Controls]
123. Working with overlapping date ranges
124. Working with Relational Tables in Excel
125. Working with unique values
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. Extract a unique distinct list sorted from A to Z
5. Extract dates from overlapping date ranges
6. Extract specific word based on position in cell value
7. Extract unique distinct values sorted based on sum of adjacent values
8. Find and return the highest number and corresponding date based on a condition
9. Find the most recent date that meets a particular condition
10. Follow stock market trends – Moving Average
11. Fuzzy VLOOKUP
12. How to calculate and plot pivots on an Excel chart
13. How to list unique distinct values sorted by frequency
14. How to quickly find the maximum or minimum value [Formula]
16. How to use the MAX function
17. Identify rows of overlapping records
19. Repeat values across cells
21. Working with overlapping date ranges
22. Working with unique values
MAXIFS function
Maze
1. Build a maze programmatically in Excel
3. Solve a maze programmatically in Excel
MEDIAN function
1. Calculate machine utilization
2. How to use the MEDIAN function
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
7. How to decode URL-encoded strings
8. How to extract email addresses from an Excel sheet
9. How to extract numbers from a cell value
10. How to remove numbers from a cell value
11. How to return a value if lookup value is in a range
12. How to use the MID function
13. INDEX MATCH – multiple results
14. List all permutations with a condition
15. Search for a text string in a data set and return multiple records
16. Working with classic ciphers in Excel
MIN function
1. A beginners guide to Excel array formulas
2. Change chart axis range programmatically
3. Compare the performance of your stock portfolio to S&P 500 using Excel
4. Compare two columns in different worksheets
5. Convert date ranges into dates
6. Extract a list of duplicates from a column
7. Extract dates from overlapping date ranges
8. Extract duplicates from a multi-column cell range
9. Extract unique distinct values from a multi-column cell range
10. Filter values in common between two cell ranges
11. Filter values occurring in range 1 but not in range 2
12. Find and return the highest number and corresponding date based on a condition
14. Find numbers closest to sum
15. Find the most recent date that meets a particular condition
16. Follow stock market trends – Moving Average
17. How to extract email addresses from an Excel sheet
18. How to highlight duplicate values
19. How to list unique distinct values sorted by frequency
20. How to perform a two-dimensional lookup
21. How to quickly find the maximum or minimum value [Formula]
22. How to use the MIN function
23. How to use VLOOKUP/XLOOKUP with multiple conditions
24. Identify rows of overlapping records
25. Lookup with any number of criteria
26. Partial match and return multiple adjacent values
27. Repeat values across cells
28. Sort a range from A to Z [Array formula]
31. VLOOKUP – Return multiple unique distinct values
32. Working with overlapping date ranges
33. Working with unique values
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 most recent date that meets a particular condition
4. How to use the MINIFS function
MINUTE function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
3. 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
2. How to decode URL-encoded strings
Missing values
2. 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
5. Count unique distinct values
7. Extract shared values between two columns
8. Filter unique distinct records case sensitive
9. Find numbers closest to sum
10. Get date ranges from a schedule
11. How to extract a case sensitive unique list from a column
12. How to extract numbers from a cell value
13. How to extract rows containing digits [Formula]
14. How to solve simultaneous linear equations in Excel
15. How to use the MMULT function
16. Identify rows of overlapping records
17. INDEX MATCH – multiple results
18. Lookup multiple values in one cell
19. Match two criteria and return multiple records
20. Partial match and return multiple adjacent values
21. Search for a text string in a data set and return multiple records
22. Sort based on frequency row-wise
23. VLOOKUP – Return multiple unique distinct values
24. Wildcard lookups and include or exclude criteria
25. 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
3. Change chart axis range programmatically
5. Count unique distinct values
6. Count unique distinct values that meet multiple criteria
7. Create a quartely date range
8. Create date ranges that stay within month
9. Date and Time Functions – A to M
10. Date and Time Functions – N to Z
11. Excel calendar
12. Get date ranges from a schedule
13. Highlight events in a yearly calendar
14. How to calculate and plot pivots on an Excel chart
15. How to track sector performance in the stock market – Excel template
16. How to use the MONTH function
17. List all unique distinct rows in a given month
20. Plot date ranges in a calendar
21. Populate drop down list with unique distinct values sorted from A to Z
22. 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
3. Lookup with any number of criteria
Named range
1. Create a dynamic named range
2. Populate drop down list with filtered Excel Table values
NETWORKDAYS function
1. Date and Time Functions – N to Z
2. How to use the NETWORKDAYS function
NETWORKDAYS.INTL function
1. Date and Time Functions – N to Z
2. How to use the NETWORKDAYS.INTL function
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
NOT function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. Count cells containing text from list
3. Extract a unique distinct list sorted from A to Z
4. Extract duplicate values with exceptions
5. Extract unique distinct values sorted based on sum of adjacent values
6. Filter unique distinct records
7. Filter values in common between two cell ranges
8. Filter values that exists in all three columns
9. How to generate a round-robin tournament
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. Wildcard lookups and include or exclude criteria
16. Working with Relational Tables in Excel
NOW function
1. Date and Time Functions – N to Z
2. How to use the NOW function
NPER function
OFFSET function
1. Add values to a regular drop-down list programmatically
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. Extract dates from overlapping date ranges
7. Extract unique distinct values in a filtered list
9. Follow stock market trends – Moving Average
10. Highlight duplicates in a filtered Excel Table
11. Highlight unique values in a filtered Excel table
12. How to generate a round-robin tournament
14. How to use the OFFSET function
15. How to use VLOOKUP/XLOOKUP with multiple conditions
16. Populate drop down list with filtered Excel Table values
17. Use drop down lists and named ranges to filter chart values
OR function
1. 5 easy ways to VLOOKUP and return multiple values
2. Automate net asset value (NAV) calculation on your stock portfolio
4. How to track sector performance in the stock market – Excel template
7. If cell contains text from list
9. Search for a text string in a data set and return multiple records
Overlapping
1. Highlight date ranges overlapping selected record [VBA]
2. Identify rows of overlapping records
3. 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
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
PERMUTATIONA function
Permutations
1. Find numbers closest to sum
3. List all permutations with a condition
4. Rotating unique groups with no repeat
PHI function
1. How to use the PHI function
PI function
1. Engineering functions – D to IMC
Pie chart
Pivot table
1. How to create a dynamic pivot table and refresh automatically
2. How to use Pivot Tables – Excel’s most powerful feature and also least known
PMT function
POWER function
1. How to use the POWER function
2. Sort based on frequency row-wise
PPMT function
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. Engineering functions – IMD to Z
2. How to use the RADIANS function
RAND function
1. How to create random numbers, text strings, dates and time values
2. How to generate random numbers and text
3. How to use the RAND function
RANDARRAY function
1. Array Manipulation Functions
2. How to use the RANDARRAY function
4. Working with classic ciphers in Excel
RANDBETWEEN function
1. Assign records unique random text strings
3. How to build a Team Generator – different number of people per team
4. How to create random numbers, text strings, dates and time values
5. How to generate a round-robin tournament
6. How to generate random numbers and text
7. How to use the RANDBETWEEN function
8. Rotating unique groups with no repeat
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
Range
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
Rearrange values
1. Rearrange values in a cell range to a single column
2. Rearrange values using formulas
3. 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. Convert date ranges into dates
2. Filter strings containing a given substring in a cell range
3. Group rows based on a condition
4. How to use the REDUCE function
6. Working with classic ciphers in Excel
Regular expressions
1. How to use the LIKE OPERATOR
Relational tables
REPLACE function
1. How to use the REPLACE function
REPT function
1. A Comprehensive Guide to Splitting Text in Excel
2. Engineering functions – A to C
3. Extract specific word based on position in cell value
4. How to extract email addresses from an Excel sheet
5. How to use the REPT function
6. Working with classic ciphers in Excel
RIGHT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Date and Time Functions – A to M
3. Extract specific word based on position in cell value
4. Formula for matching a date within a date range
6. How to use the RIGHT function
7. Split data across multiple sheets – VBA
8. VLOOKUP – Return multiple unique distinct values
9. Working with classic ciphers in Excel
ROUND function
2. Engineering functions – IMD to Z
3. How to use the ROUND function
4. Sort a column alphabetically
5. Sort values by corresponding text arranged in a column
ROUNDDOWN function
1. Calculate the number of weeks between given dates
2. Change chart axis range programmatically
3. How to use the ROUNDDOWN function
4. Rearrange values using formulas
ROUNDUP function
1. Array Manipulation Functions
2. Change chart axis range programmatically
3. How to create random numbers, text strings, dates and time values
4. How to use the ROUNDUP function
6. 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 quartely date range
11. Create dependent drop down lists containing unique distinct values
13. Date and Time Functions – A to M
14. Date and Time Functions – N to Z
16. Engineering functions – D to IMC
17. Extract a list of alphabetically sorted duplicates based on a condition
18. Extract a list of duplicates from a column
19. Extract a list of duplicates from three columns combined
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 numbers from a column
24. Extract shared values between two columns
25. Extract unique distinct values in a filtered list
26. Filter duplicate values based on criteria
27. Filter unique distinct records case sensitive
28. Find all sequences of consecutive dates
29. Find empty hours in a weekly schedule
31. Find numbers closest to sum
32. Find the most recent date that meets a particular condition
33. Follow stock market trends – Moving Average
34. Get date ranges from a schedule
35. How to compare two data sets
36. How to copy non contiguous cell ranges
37. How to create date ranges in Excel
38. How to decode URL-encoded strings
39. How to extract a case sensitive unique list from a column
40. How to extract rows containing digits [Formula]
41. How to generate a round-robin tournament
42. How to replace part of formula in all cells
43. How to return a value if lookup value is in a range
44. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
46. How to use the MAKEARRAY function
47. How to use the ROWS function
48. How to use VLOOKUP/XLOOKUP with multiple conditions
49. INDEX MATCH – multiple results
50. Lookup and return multiple sorted values based on corresponding values in another column
51. Match two criteria and return multiple records
52. Merge cell ranges into one list
53. Partial match and return multiple adjacent values
54. Partial match for multiple strings – AND logic
55. Partial match with two conditions and return multiple results
56. Populate drop down list with filtered Excel Table values
57. Populate drop down list with unique distinct values sorted from A to Z
58. Rearrange values in a cell range to a single column
59. Rearrange values using formulas
60. Remove duplicates within same month or year
61. Repeat values across cells
62. Reverse a list ignoring blanks
63. Search for a sequence of values
64. Search for a text string in a data set and return multiple records
65. Sort a column alphabetically
66. Sort a range from A to Z [Array formula]
67. Sort based on frequency row-wise
69. Sort rows based on frequency and criteria
70. Sort text cells alphabetically from two columns
71. Sort values by corresponding text arranged in a column
72. Split data across multiple sheets – VBA
73. Team Generator
74. What values are missing in List 1 that exists i List 2?
76. Working with overlapping date ranges
77. Working with Relational Tables in Excel
78. Working with unique values
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. How to add horizontal line to chart
4. How to improve your Excel Chart
Schedule
1. Find empty hours in a weekly schedule
2. Get date ranges from a schedule
3. Watch schedule that populates vacation time
Scroll bar
Search and return multiple values
2. Partial match and return multiple adjacent values
3. Partial match for multiple strings – AND logic
4. Partial match with two conditions and return multiple results
5. 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 from a multi-column cell range
7. Extract unique distinct values if the value contains the given string
8. Filter strings containing a given substring in a cell range
9. Filter unique distinct records
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 text from list
16. INDEX MATCH – multiple results
17. Lookup and return multiple values concatenated into one cell
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 for multiple strings – AND logic
22. Partial match with two conditions and return multiple results
23. Search for a text string in a data set and return multiple records
24. Split search value using a delimiter and search for each substring
25. VLOOKUP – Return multiple unique distinct values
26. Wildcard lookups and include or exclude criteria
27. Working with classic ciphers in Excel
SEC function
1. How to use the SEC function
SECOND function
1. Date and Time Functions – N to Z
2. How to use the SECOND function
SELECT CASE statement
Sequence
3. Search for a sequence of cells based on wildcard search
4. 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. Create a dynamic named range
8. Date and Time Functions – A to M
9. Date and Time Functions – N to Z
10. Extract dates from overlapping date ranges
11. Extract unique distinct values in a filtered list
13. Find numbers closest to sum
14. Fuzzy VLOOKUP
15. Get date ranges from a schedule
16. How to copy non contiguous cell ranges
17. How to decode URL-encoded strings
18. How to extract numbers from a cell value
19. How to extract rows containing digits [Formula]
20. How to remove numbers from a cell value
21. How to use the SEQUENCE function
22. How to use VLOOKUP/XLOOKUP with multiple conditions
23. List all permutations with a condition
24. Rearrange values using formulas
25. Repeat values across cells
26. Reverse a list ignoring blanks
27. Sort a column alphabetically
28. Sort values by corresponding text arranged in a column
30. Team Generator
31. Working with classic ciphers in Excel
32. Working with overlapping date ranges
SET statement
SGN function
SHEET function
1. How to use the SHEET function
SHEETS function
1. How to use the SHEETS function
SIGN function
1. Count a specific text string in a cell
2. How to use the SIGN function
SIN function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
3. How to use the SIN function
SKEW function
1. How to use the SKEW function
SLOPE function
1. How to use the SLOPE function
Small
SMALL function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
4. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Compare tables: Filter records occurring only in one table
6. Compare two columns and extract differences
7. Compare two columns in different worksheets
8. Convert array formula to a regular formula
9. Convert date ranges into dates
10. Count a specific text string in a cell
11. Count cells between specified values
12. Create dependent drop down lists containing unique distinct values
13. Date and Time Functions – N to Z
14. Excel calendar
15. Extract a list of alphabetically sorted duplicates based on a condition
16. Extract a list of duplicates from a column
17. Extract a unique distinct list sorted from A to Z
18. Extract all rows from a range that meet criteria in one column
19. Extract dates from overlapping date ranges
20. Extract numbers from a column
21. Extract records between two dates
22. Extract shared values between two columns
23. Extract unique distinct values from a multi-column cell range
24. Filter duplicate values based on criteria
25. Find all sequences of consecutive dates
27. Find empty hours in a weekly schedule
29. Find the most recent date that meets a particular condition
30. Follow stock market trends – Moving Average
31. Formula for matching a date within a date range
32. Fuzzy VLOOKUP
33. Get date ranges from a schedule
34. Group rows based on a condition
35. How to compare two data sets
36. How to create date ranges in Excel
37. How to extract a case sensitive unique list from a column
38. How to extract rows containing digits [Formula]
39. How to generate a round-robin tournament
40. How to perform a two-dimensional lookup
41. How to replace part of formula in all cells
42. How to return a value if lookup value is in a range
43. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
45. How to use the SMALL function
46. How to use VLOOKUP/XLOOKUP with multiple conditions
47. Identify rows of overlapping records
48. If cell contains text from list
49. INDEX MATCH – multiple results
50. List all unique distinct rows in a given month
51. Lookup and return multiple sorted values based on corresponding values in another column
52. Lookup multiple values across columns and return a single value
54. Lookup with any number of criteria
55. Match two criteria and return multiple records
56. Merge two columns with possible blank cells
57. Partial match and return multiple adjacent values
58. Partial match for multiple strings – AND logic
59. Partial match with two conditions and return multiple results
60. Plot date ranges in a calendar
61. Populate drop down list with filtered Excel Table values
62. Populate drop down list with unique distinct values sorted from A to Z
63. Remove common records between two data sets
64. Remove duplicates within same month or year
65. Repeat values across cells
66. Search for a sequence of cells based on wildcard search
67. Search for a sequence of values
68. Search for a text string in a data set and return multiple records
69. Sort a column alphabetically
70. Sort a range from A to Z [Array formula]
71. Sort values by corresponding text arranged in a column
72. Split data across multiple sheets – VBA
74. Use a drop down list to search and return multiple values
75. Watch schedule that populates vacation time
76. What values are missing in List 1 that exists i List 2?
77. Wildcard lookups and include or exclude criteria
78. Working with COMBO BOXES [Form Controls]
80. Working with overlapping date ranges
81. Working with Relational Tables in Excel
82. Working with unique values
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. 5 easy ways to VLOOKUP and return multiple values
2. Compare two columns in different worksheets
3. Convert date ranges into dates
4. Engineering functions – A to C
5. Extract a list of alphabetically sorted duplicates based on a condition
6. Extract a list of duplicates from a column
7. Extract a unique distinct list and sum amounts based on a condition
8. Extract a unique distinct list sorted from A to Z
9. Extract unique distinct values from a multi-column cell range
10. Find all sequences of consecutive dates
11. Fuzzy lookups
12. Fuzzy VLOOKUP
13. How to extract numbers from a cell value
14. How to use the SORT function
15. Sort a column alphabetically
16. Sort rows based on frequency and criteria
17. Sort values by corresponding text arranged in a column
18. Sort values in a cell based on a delimiting character
19. Working with classic ciphers in Excel
21. Working with unique values
Sort values
1. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
2. Lookup and return multiple sorted values based on corresponding values in another column
3. Reverse a list ignoring blanks
4. Sort a column alphabetically
5. Sort a range from A to Z [Array formula]
6. Sort text cells alphabetically from two columns
7. Sort values by corresponding text arranged in a column
8. Sort values in a cell based on a delimiting character
SORTBY function
1. Array Manipulation Functions
3. Extract a unique distinct list sorted from A to Z
4. Extract unique distinct values sorted based on sum of adjacent values
6. How to list unique distinct values sorted by frequency
7. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
8. How to use the SORTBY function
9. 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. Team Generator
14. Unique distinct records sorted based on count or frequency
15. Working with classic ciphers in Excel
Sparkline
SPLIT function
Split values
1. A Comprehensive Guide to Splitting Text in Excel
2. Split data across multiple sheets – VBA
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. Follow stock market trends – Moving Average
2. How to calculate and plot pivots on an Excel chart
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. Count a specific text string in a cell
3. Count cells containing text from list
4. Date and Time Functions – A to M
5. Extract specific word based on position in cell value
7. How to count the number of values separated by a delimiter
8. How to extract email addresses from an Excel sheet
9. How to replace part of formula in all cells
10. How to use the SUBSTITUTE function
11. Partial match and return multiple adjacent values
12. Split search value using a delimiter and search for each substring
13. Working with classic ciphers in Excel
Substitute Replace
SUBTOTAL function
1. Count cells based on background color
3. Extract unique distinct values in a filtered list
4. Filter duplicate values based on criteria
5. Highlight duplicates in a filtered Excel Table
6. Highlight unique values in a filtered Excel table
7. How to use the SUBTOTAL function
8. How to use the Subtotal tool
9. How to use VLOOKUP/XLOOKUP with multiple conditions
10. Most frequent value between two dates
11. Populate drop down list with filtered Excel Table values
Sum
2. How to do tiered calculations in one formula
3. Working with running totals
SUM function
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Calculate machine utilization
4. Count a specific text string in a cell
5. Count cells containing text from list
6. Count identical values if they are on the same row
7. Count unique distinct records
8. Count unique distinct values
9. Count unique distinct values based on a condition
10. Count unique distinct values that meet multiple criteria
11. Excel calendar
13. Extract a list of duplicates from a column
14. Extract a unique distinct list sorted from A to Z
15. Extract unique distinct values in a filtered list
16. Filter strings containing a given substring in a cell range
17. Filter unique distinct records case sensitive
18. Get date ranges from a schedule
19. Highlight duplicates in a filtered Excel Table
20. Highlight unique values in a filtered Excel table
21. How to build a Team Generator – different number of people per team
22. How to count the number of values separated by a delimiter
24. How to use the asterisk character
25. How to use the SUM function
26. Identify numbers in sum using Excel solver
27. If cell contains text from list
28. List all permutations with a condition
29. Lookup with any number of criteria
30. Repeat values across cells
31. Rotating unique groups with no repeat
32. Search for a text string in a data set and return multiple records
33. Sort a column alphabetically
35. Working with classic ciphers in Excel
36. Working with overlapping date ranges
37. Working with Relational Tables in Excel
38. Working with running totals
SUMIF function
1. Extract unique distinct values sorted based on sum of adjacent values
2. How to use the SUMIF function
4. Working with Relational Tables in Excel
5. Working with running totals
SUMIFS function
1. Extract a unique distinct list and sum amounts based on a condition
2. How to use Pivot Tables – Excel’s most powerful feature and also least known
3. How to use the SUMIFS function
4. Working with running totals
SUMPRODUCT
1. SUMPRODUCT – multiple criteria
SUMPRODUCT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Automate net asset value (NAV) calculation on your stock portfolio
3. Calculate machine utilization
4. Compare the performance of your stock portfolio to S&P 500 using Excel
5. Count a specific text string in a cell
6. Count cells containing text from list
7. Count identical values if they are on the same row
9. Count unique distinct records
10. Count unique distinct values
11. Create a quartely date range
13. Create dependent drop down lists containing unique distinct values
15. Date and Time Functions – N to Z
16. Excel calendar
17. Extract a unique distinct list and sum amounts based on a condition
18. Find empty hours in a weekly schedule
19. Find the most recent date that meets a particular condition
20. Formula for matching a date within a date range
21. How to create date ranges in Excel
22. How to do tiered calculations in one formula
23. How to generate a round-robin tournament
24. How to quickly find the maximum or minimum value [Formula]
25. How to rank text uniquely without duplicates
26. How to return a value if lookup value is in a range
27. How to use the SUMPRODUCT function
28. Identify numbers in sum using Excel solver
29. Identify rows of overlapping records
30. If cell contains text from list
31. List all permutations with a condition
32. Plot date ranges in a calendar
33. Prevent duplicate records in a worksheet
34. Repeat values across cells
35. Sort rows based on frequency and criteria
36. SUMPRODUCT – multiple criteria
37. SUMPRODUCT and IF function
39. Team Generator
40. Working with overlapping date ranges
41. Working with running totals
SUMSQ function
1. How to use the SUMSQ function
SUMX2MY2 function
1. How to use the SUMX2MY2 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
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
1. Excel template: Getting Things Done [VBA]
2. Highlight events in a yearly calendar
Text boxes
1. Working with TEXT BOXES [Form Controls]
TEXT function
1. Create a quartely date range
3. Date and Time Functions – A to M
4. Date and Time Functions – N to Z
5. Follow stock market trends – Moving Average
6. How to calculate and plot pivots on an Excel chart
7. How to create date ranges in Excel
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
15. Working with running totals
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. Array Manipulation Functions
3. Engineering functions – A to C
4. Extract specific word based on position in cell value
5. Filter strings containing a given substring in a cell range
6. How to decode URL-encoded strings
7. How to extract email addresses from an Excel sheet
8. How to use the TEXTSPLIT function
9. If cell contains text from list
10. Lookup multiple values in one cell
11. Rearrange data
12. Sort values in a cell based on a delimiting character
13. Split search value using a delimiter and search for each substring
14. Working with unique values
TextToColumns method
Time
TIME function
1. Date and Time Functions – N to Z
2. Find empty hours in a weekly schedule
3. How to use the TIME function
TIMEVALUE function
1. Date and Time Functions – N to Z
2. How to use the TIMEVALUE function
TOCOL function
1. 5 easy ways to VLOOKUP and return multiple values
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 multiple non adjacent cell ranges
7. Extract duplicates from a multi-column cell range
8. Extract unique distinct values from a multi-column cell range
9. Filter values in common between two cell ranges
10. Filter values occurring in range 1 but not in range 2
11. Find empty hours in a weekly schedule
12. Get date ranges from a schedule
13. How to extract email addresses from an Excel sheet
14. How to list unique distinct values sorted by frequency
15. Rearrange values in a cell range to a single column
16. VLOOKUP – Return multiple unique distinct values
17. Working with classic ciphers in Excel
18. Working with overlapping date ranges
19. Working with unique values
TODAY function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
4. Get date ranges from a schedule
5. How to track sector performance in the stock market – Excel template
6. 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
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. 5 easy ways to VLOOKUP and return multiple values
3. A Comprehensive Guide to Splitting Text in Excel
4. Array Manipulation Functions
5. Automate net asset value (NAV) calculation on your stock portfolio
6. Calculate the number of weeks between given dates
7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
9. Concatenate unique distinct values
10. Excel calendar
12. Extract a list of duplicates from a column
13. Extract duplicates from a multi-column cell range
14. Extract specific word based on position in cell value
15. Extract unique distinct values from a multi-column cell range
16. Filter values in common between two cell ranges
17. Filter values occurring in range 1 but not in range 2
18. Formula for matching a date within a date range
19. How to decode URL-encoded strings
20. How to extract email addresses from an Excel sheet
21. How to extract numbers from a cell value
22. How to list unique distinct values sorted by frequency
23. How to perform a two-dimensional lookup
24. How to remove numbers from a cell value
25. How to return a value if lookup value is in a range
26. How to use mouse hover on a worksheet [VBA]
27. How to use VLOOKUP/XLOOKUP with multiple conditions
28. Identify rows of overlapping records
29. If cell contains text from list
30. INDEX MATCH – multiple results
31. Lookup and return multiple values concatenated into one cell
32. Lookup multiple values across columns and return a single value
33. Lookup multiple values in one cell
34. Match two columns and return another value on the same row
35. Partial match for multiple strings – AND logic
36. Rearrange data
37. Rearrange values in a cell range to a single column
38. Search for a sequence of cells based on wildcard search
39. Search for a text string in a data set and return multiple records
40. Split search value using a delimiter and search for each substring
41. SUMPRODUCT and IF function
43. VLOOKUP – Return multiple unique distinct values
44. Working with classic ciphers in Excel
45. Working with unique values
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. Extract a unique distinct list and sum amounts based on a condition
4. Extract a unique distinct list from multiple non adjacent cell ranges
5. Extract a unique distinct list sorted from A to Z
6. Extract unique distinct values from a multi-column cell range
7. Extract unique distinct values if the value contains the given string
8. Extract unique distinct values in a filtered list
9. Extract unique distinct values sorted based on sum of adjacent values
10. Filter unique distinct values based on a date range
11. List all unique distinct rows in a given month
12. Remove duplicates within same month or year
13. VLOOKUP – Return multiple unique distinct values
UNIQUE function
1. 5 easy ways to extract Unique Distinct Values
2. Array Manipulation Functions
4. Convert date ranges into dates
5. Count unique distinct values
6. Count unique distinct values based on a condition
7. Count unique distinct values that meet multiple criteria
8. Create dependent drop down lists containing unique distinct values
9. Engineering functions – A to C
10. Extract a list of duplicates from a column
11. Extract a list of duplicates from three columns combined
12. Extract a unique distinct list and sum amounts based on a condition
13. Extract a unique distinct list from multiple non adjacent cell ranges
14. Extract a unique distinct list sorted from A to Z
15. Extract duplicate values with exceptions
16. Extract duplicates from a multi-column cell range
17. Extract unique distinct values from a multi-column cell range
18. Extract unique distinct values in a filtered list
19. Extract unique distinct values sorted based on sum of adjacent values
20. Filter strings containing a given substring in a cell range
21. Filter unique distinct records
22. Filter unique distinct values based on a date range
23. Filter values in common between two cell ranges
24. Filter values occurring in range 1 but not in range 2
25. Group rows based on a condition
26. How to extract numbers from a cell value
27. How to list unique distinct values sorted by frequency
28. How to return a value if lookup value is in a range
29. How to use the UNIQUE function
30. Lookup and return multiple values concatenated into one cell
31. Search for a text string in a data set and return multiple records
32. Sort rows based on frequency and criteria
34. Unique distinct records sorted based on count or frequency
35. Use a drop down list to search and return multiple values
36. VLOOKUP – Return multiple unique distinct values
37. Working with classic ciphers in Excel
38. Working with unique values
Unique values
1. 5 easy ways to extract Unique Distinct Values
2. How to extract a case sensitive unique list from a column
3. List all unique distinct rows in a given month
UPPER function
1. Count a specific text string in a cell
2. Count cells containing text from list
4. How to use the UPPER function
5. Working with classic ciphers in Excel
User Defined Function
1. Extract unique distinct values in a filtered list
2. How to count the number of values separated by a delimiter
3. Lookup multiple values in one cell
5. Search for a file in folder and subfolders – UDF
6. Split search value using a delimiter and search for each substring
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 values to a regular drop-down list programmatically
4. Auto resize columns as you type
5. Copy data from workbooks in folder and subfolders
6. Copy worksheets in active workbook to new workbooks
7. Count text string in all formulas in a worksheet [VBA]
8. Create a Print button – macro
9. Create links to all sheets in a workbook programmatically
10. Create new worksheets programmatically based on values in a cell range [VBA]
12. Customize the ribbon and how to add your macros
13. Excel calendar
14. Excel template: Getting Things Done [VBA]
16. Extract unique distinct values in a filtered list
17. Filter duplicate files in a folder and subfolders
19. Hide specific worksheets programmatically
20. Highlight date ranges overlapping selected record [VBA]
21. How to copy non contiguous cell ranges
22. How to count the number of values separated by a delimiter
23. How to create an interactive Excel chart
24. How to highlight row of the selected cell programmatically
25. How to save specific multiple worksheets to a pdf file programmatically
27. How to use the LIKE OPERATOR
29. List all hyperlinks in worksheet programmatically
30. Lookup multiple values in one cell
31. Print consecutive page numbers across multiple worksheets
32. Print screen the entire worksheet
33. Rearrange data
34. Remove print preview lines (Page Breaks)
35. Resize a range of values (UDF)
36. Run a Macro from a Drop Down list [VBA]
38. Search all workbooks in a folder
39. Search for a file in folder and subfolders – UDF
40. Show / hide a picture using a button
41. Sort values in a cell based on a delimiting character
42. Split data across multiple sheets – VBA
43. Split search value using a delimiter and search for each substring
44. Working with ARRAY VARIABLES (VBA)
45. Working with COMBO BOXES [Form Controls]
46. Working with comments – VBA
47. Working with Excel tables programmatically
49. Working with LIST BOXES (Form Controls)
50. 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
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 the asterisk character
4. How to use the VLOOKUP function
5. How to use VLOOKUP/XLOOKUP with multiple conditions
6. Merge tables based on a condition
8. VLOOKUP/XLOOKUP of three columns to pull a single record
VSTACK function
1. 5 easy ways to VLOOKUP and return multiple values
2. Array Manipulation Functions
3. Calculate machine utilization
4. Compare two columns and extract differences
5. Convert date ranges into dates
6. Extract a list of duplicates from a column
7. Filter strings containing a given substring in a cell range
8. Filter unique distinct records
9. Filter unique distinct records case sensitive
11. Find the most recent date that meets a particular condition
12. Group rows based on a condition
13. Merge cell ranges into one list
14. Merge two columns with possible blank cells
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
2. Create date ranges that stay within month
3. Date and Time Functions – N to Z
5. How to track sector performance in the stock market – Excel template
6. How to use the WEEKDAY function
WEEKNUM function
1. Count unique distinct values
2. Date and Time Functions – N to Z
3. Extract a list of duplicates from a column
4. How to use the WEEKNUM function
Wildcard Search
Win/loss
WITH ... END WITH Statement
2. How to highlight row of the selected cell programmatically
WORKDAY function
1. Date and Time Functions – N to Z
2. How to track sector performance in the stock market – Excel template
3. 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. Automate net asset value (NAV) calculation on your stock portfolio
2. Change chart axis range programmatically
4. Count unique distinct values
5. Create a quartely date range
6. Create date ranges that stay within month
8. Date and Time Functions – A to M
9. Date and Time Functions – N to Z
10. Extract a list of duplicates from a column
11. Follow stock market trends – Moving Average
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
18. Remove duplicates within same month or year
19. Yet another Excel Calendar
YEARFRAC function
1. Date and Time Functions – N to Z
2. 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