Excel formula examples
This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.
#, hashtag
2D, two-dimensional, two-way
3D, multiple worksheets, multiple sheets
365
Address
Advanced Filter
Alternative
And logic
Autofilter
Average
Blank, space
Calendar
Case
Character
Column
Combination, combin
Complex, imaginary
Concatenate, combine, merge, join, append
Conditional formatting, cf, highlight
Count
Countif
Countifs
Criteria, multiple conditions, conditions
Date
Day
Decimal
Delete, remove
Digit
Duplicates
Dynamic
Empty
Equal, condition, criterion
Error, problem
Extend, expand
Extract, list, filter, get
Finance, stock, expense
First, last
Group, category
Hour
Hyperlink, link
If
Ifs
Ignore, avoid, prevent, exclude, hide
Image, picture
Index
Index match, index and match
Intersection
Lambda
Large, larger, highest, greater
Letter
Lookup, find, identify
Match
Max
Min
Minute
Month
Multiply, multiplication, product
Negative, minus, subtract
New line
Not equal
Or logic
Overlapping
Partial, wildcard, contain
Permut
Random
Rearrange, distribute
Record, row
Recursive
Reference
Relation, related
Reverse
Right, left
Running total
Schedule
Second
Sequence, consecutive
Shared, common, exist, occur
Small, smaller, less
Solver
Sort, A to Z, z to a, ascending, descending
Split
String
Substitute, replace
Subtotal
Sum, total
Sumif
Sumifs
Sumproduct
Tab
Table, excel table
Team, tournament
Text
Time
Unique
Vlookup
Week
Year
Categories
100% stacked column chart
ABS function
1. Count cells containing text from list
2. Date and Time Functions – A to M
3. Find numbers closest to sum
4. Find the most recent date that meets a particular condition
5. How to create date ranges in Excel
6. How to use the ABS function
7. How to use the asterisk character
8. Identify numbers in sum using Excel solver
9. INDEX MATCH – multiple results
ACCRINT function
ACCRINTM function
ACOS function
1. How to use the ACOS function
ACOT function
1. How to use the ACOT function
Add-in
1. Split data across multiple sheets – VBA
ADDRESS function
1. How to quickly find the maximum or minimum value [Formula]
2. How to use the ADDRESS function
Advanced filter
AGGREGATE function
1. Count cells containing text from list
2. Extract unique distinct values from a multi-column cell range
3. How to use the AGGREGATE function
AMORLINC function
AND function
1. Count cells containing text from list
3. How to use the AND function
4. Search for a text string in a data set and return multiple records
5. Working with Relational Tables in Excel
Animate
1. How to animate an Excel chart
Area chart
AREAS function
1. How to use the AREAS function
ARRAY function
Arrays
1. A beginners guide to Excel array formulas
2. Working with ARRAY VARIABLES (VBA)
ARRAYTOTEXT Function
1. How to use the ARRAYTOTEXT function
ASIN function
1. How to use the ASIN function
ATAN function
1. Engineering functions – D to IMC
2. How to use the ATAN function
ATAN2 function
1. How to use the ATAN2 function
AVEDEV function
1. How to use the AVEDEV function
AVERAGE function
1. Follow stock market trends – Moving Average
2. How to use the AVERAGE function
AVERAGEA function
1. How to use the AVERAGEA function
AVERAGEIF function
1. How to use the AVERAGEIF function
AVERAGEIFS function
1. How to use the AVERAGEIFS function
Bar chart
BASE function
1. Engineering functions – D to IMC
2. How to use the BASE function
Basic formulas
1. Count cells containing text from list
3. Extract specific word based on position in cell value
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. How to create date ranges in Excel
7. How to do tiered calculations in one formula
8. How to extract numbers from a cell value
9. How to perform a two-dimensional lookup
10. If cell contains text from list
11. INDEX MATCH – multiple results
12. Lookup multiple values across columns and return a single value
13. Lookup with any number of criteria
14. Working with running totals
BETA.DIST function
1. How to use the BETA.DIST function
BETA.INV function
1. How to use the BETA.INV function
BETADIST function
BETAINV function
BIN2DEC function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
BIN2HEX function
1. Engineering functions – A to C
BIN2OCT function
1. Engineering functions – A to C
BINOM.DIST function
2. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. Engineering functions – A to C
2. How to use the BITAND function
BITLSHIFT function
1. Engineering functions – A to C
2. How to use the BITLSHIFT function
BITOR function
1. Engineering functions – A to C
BITRSHIFT function
1. Engineering functions – A to C
BITXOR function
1. Engineering functions – A to C
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Count cells containing text from list
4. Filter unique distinct records case sensitive
6. How to use the BYROW function
7. Rearrange values using formulas
8. Search for a text string in a data set and return multiple records
Calendar
3. 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
CF-duplicates
1. How to highlight duplicate values
CF-min-max
CF-misc
1. Advanced Techniques for Conditional Formatting
CF-search
CF-unique-distinct
1. Highlight unique values in a filtered Excel table
CHAR function
1. Engineering functions – A to C
3. How to use the CHAR function
4. Search for a text string in a data set and return multiple records
5. Working with classic ciphers in Excel
Chart basics
1. Excel charts tips and tricks
Chart elements
Charts
1. Advanced Excel Chart Techniques
4. Excel charts tips and tricks
5. Highlight a data series in a chart
7. How to add horizontal line to chart
8. How to animate an Excel chart
9. How to create an interactive Excel chart
10. How to create charts in Excel
11. How to improve your Excel Chart
Check-boxes
1. Add checkboxes and copy values – VBA
CHIDIST function
CHIINV function
CHISQ.DIST function
2. How to use the CHISQ.DIST function
CHISQ.DIST.RT function
1. How to use the CHISQ.DIST.RT function
CHISQ.INV function
1. How to use the CHISQ.INV function
CHISQ.INV.RT function
1. How to use the CHISQ.INV.RT function
CHISQ.TEST function
1. How to use the CHISQ.TEST function
CHITEST function
CHOOSE function
1. How to perform a two-dimensional lookup
2. How to use the CHOOSE function
3. Split data across multiple sheets – VBA
CHOOSECOLS function
1. Array Manipulation Functions
CHOOSEROWS function
1. Array Manipulation Functions
CLEAN function
1. How to use the CLEAN function
CODE function
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
2. How to use the CODE function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Column
Column chart
1. How to add horizontal line to chart
2. How to animate an Excel chart
3. How to create charts in Excel
COLUMN function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Array Manipulation Functions
4. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Compare tables: Filter records occurring only in one table
6. Compare two columns in different worksheets
7. Count cells containing text from list
8. Count unique distinct values
10. Excel calendar
11. Extract a list of duplicates from a column
12. Extract duplicates from a multi-column cell range
13. Extract records between two dates
14. Extract unique distinct values from a multi-column cell range
15. Filter unique distinct records
16. Filter unique distinct records case sensitive
17. Fuzzy VLOOKUP
18. Get date ranges from a schedule
19. How to compare two data sets
20. How to create date ranges in Excel
21. How to generate a round-robin tournament
22. How to list unique distinct values sorted by frequency
23. How to perform a two-dimensional lookup
24. How to quickly find the maximum or minimum value [Formula]
25. How to return a value if lookup value is in a range
26. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
28. How to use Pivot Tables – Excel’s most powerful feature and also least known
29. How to use the COLUMN function
31. INDEX MATCH – multiple results
32. Lookup with any number of criteria
33. Match two criteria and return multiple records
34. Merge cell ranges into one list
35. Merge tables based on a condition
36. Partial match for multiple strings – AND logic
37. Search for a text string in a data set and return multiple records
38. Sort a column alphabetically
39. Split data across multiple sheets – VBA
41. Unique distinct records sorted based on count or frequency
42. VLOOKUP – Return multiple unique distinct values
43. Wildcard lookups and include or exclude criteria
44. Working with COMBO BOXES [Form Controls]
45. Working with Relational Tables in Excel
46. Working with unique values
COLUMNS function
1. 5 easy ways to VLOOKUP and return multiple values
2. Array Manipulation Functions
3. Count cells containing text from list
5. Extract all rows from a range that meet criteria in one column
6. Filter unique distinct records
7. Filter unique distinct records case sensitive
8. How to compare two data sets
9. How to copy non contiguous cell ranges
10. How to create date ranges in Excel
11. How to return a value if lookup value is in a range
12. How to use the COLUMNS function
13. How to use the MAKEARRAY function
14. How to use VLOOKUP/XLOOKUP with multiple conditions
15. Identify rows of overlapping records
16. If cell contains text from list
17. Match two criteria and return multiple records
18. Populate drop down list with unique distinct values sorted from A to Z
19. Rearrange values using formulas
20. Search for a text string in a data set and return multiple records
21. Sort a column alphabetically
22. Split data across multiple sheets – VBA
23. Use a drop down list to search and return multiple values
24. Working with Relational Tables in Excel
COMBIN function
1. How to generate a round-robin tournament
2. How to use the COMBIN function
COMBINA function
1. How to use the COMBINA function
Combination chart
Combinations
1. Identify numbers in sum using Excel solver
Combine Merge
1. Merge cell ranges into one list
2. Merge tables based on a condition
Combobox
1. Working with COMBO BOXES [Form Controls]
Compare
1. Compare tables: Filter records occurring only in one table
2. Compare two columns and extract differences
3. Compare two columns in different worksheets
4. How to highlight differences and common values in lists
COMPLEX function
1. Engineering functions – A to C
2. Engineering functions – IMD to Z
Complex numbers
CONCAT function
1. How to extract numbers from a cell value
2. How to use the CONCAT function
Concatenate
1. Lookup and return multiple values concatenated into one cell
CONCATENATE function
1. How to use the CONCATENATE function
Conditional formatting
1. Advanced Date Highlighting Techniques in Excel
2. Advanced Techniques for Conditional Formatting
4. Highlight unique values in a filtered Excel table
5. How to highlight differences and common values in lists
6. How to highlight duplicate values
7. Working with Conditional Formatting formulas
CONFIDENCE
CONFIDENCE.NORM
1. How to use the CONFIDENCE.NORM function
CONFIDENCE.T function
1. How to use the CONFIDENCE.T function
CONVERT function
1. Engineering functions – A to C
CORREL function
1. How to use the CORREL function
COS function
1. Engineering functions – D to IMC
2. Engineering functions – IMD to Z
3. How to use the COS function
COT function
1. How to use the COT function
Count
1. Count cells containing text from list
COUNT function
1. Count unique distinct values
2. Create a dynamic named range
3. Create dependent drop down lists containing unique distinct values
4. Extract specific word based on position in cell value
6. How to create date ranges in Excel
7. How to use the COUNT function
8. If cell contains text from list
9. Search for a text string in a data set and return multiple records
Count text values
Count unique distinct records
1. Count unique distinct records
Count unique distinct values
1. Count unique distinct values
Count values
2. Count cells containing text from list
3. Count unique distinct values
COUNTA function
1. Add values to a regular drop-down list programmatically
2. Automate net asset value (NAV) calculation on your stock portfolio
3. Compare the performance of your stock portfolio to S&P 500 using Excel
4. Count unique distinct values
5. Create a dynamic named range
6. Create dependent drop down lists containing unique distinct values
8. How to compare two data sets
9. How to generate a round-robin tournament
10. How to use Pivot Tables – Excel’s most powerful feature and also least known
11. How to use the COUNTA function
12. Lookup with any number of criteria
13. Match two criteria and return multiple records
14. Team Generator
15. Wildcard lookups and include or exclude criteria
COUNTBLANK function
1. How to use the COUNTBLANK function
COUNTIF
COUNTIF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. A beginners guide to Excel array formulas
4. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare the performance of your stock portfolio to S&P 500 using Excel
8. Compare two columns and extract differences
9. Compare two columns in different worksheets
11. Count unique distinct records
12. Count unique distinct values
13. Create dependent drop down lists containing unique distinct values
15. Date and Time Functions – N to Z
17. Extract a list of duplicates from a column
18. Extract a unique distinct list from multiple non adjacent cell ranges
19. Extract a unique distinct list sorted from A to Z
20. Extract all rows from a range that meet criteria in one column
21. Extract duplicates from a multi-column cell range
22. Extract unique distinct values from a multi-column cell range
23. Extract unique distinct values in an Excel Table filtered list
24. Filter duplicate values based on criteria
25. Filter unique distinct records
26. Find all sequences of consecutive dates
28. Find the most recent date that meets a particular condition
29. Get date ranges from a schedule
30. Highlight unique values in a filtered Excel table
31. How to compare two data sets
32. How to generate a round-robin tournament
33. How to highlight duplicate values
34. How to list unique distinct values sorted by frequency
35. How to perform a two-dimensional lookup
36. How to return a value if lookup value is in a range
37. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
38. How to use the COUNTIF function
39. How to use VLOOKUP/XLOOKUP with multiple conditions
40. If cell contains text from list
41. INDEX MATCH – multiple results
42. Lookup with any number of criteria
43. Match two criteria and return multiple records
44. Merge cell ranges into one list
45. Partial match and return multiple adjacent values
46. Partial match for multiple strings – AND logic
47. Plot date ranges in a calendar
48. Populate drop down list with unique distinct values sorted from A to Z
49. Repeat values across cells
50. Rotating unique groups with no repeat
51. Sort a column alphabetically
52. Sort rows based on frequency and criteria
54. Team Generator
56. Use a drop down list to search and return multiple values
57. VLOOKUP – Return multiple unique distinct values
58. Working with COMBO BOXES [Form Controls]
59. Working with unique values
COUNTIFS function
1. Calculate machine utilization
2. Compare tables: Filter records occurring only in one table
3. Count cells containing text from list
4. Count unique distinct records
5. Count unique distinct values
6. Extract a list of duplicates from a column
7. Extract dates from overlapping date ranges
8. Extract unique distinct values in an Excel Table filtered list
9. Filter unique distinct records
10. Get date ranges from a schedule
11. How to compare two data sets
12. How to create date ranges in Excel
13. How to highlight differences and common values in lists
14. How to return a value if lookup value is in a range
16. How to use Pivot Tables – Excel’s most powerful feature and also least known
17. How to use the COUNTIFS function
18. How to use VLOOKUP/XLOOKUP with multiple conditions
19. Identify rows of overlapping records
20. INDEX MATCH – multiple results
21. Lookup multiple values across columns and return a single value
22. Match two criteria and return multiple records
23. Merge tables based on a condition
24. Prevent duplicate records in a worksheet
25. Search for a sequence of values
26. Sort rows based on frequency and criteria
27. Split data across multiple sheets – VBA
28. Unique distinct records sorted based on count or frequency
29. Working with Conditional Formatting formulas
30. Working with overlapping date ranges
31. 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. Date and Time Functions – A to M
3. Date and Time Functions – N to Z
5. Filter unique distinct records
6. Get date ranges from a schedule
7. How to create date ranges in Excel
8. How to track sector performance in the stock market – Excel template
9. How to use the DATE function
11. Plot date ranges in a calendar
12. Populate drop down list with unique distinct values sorted from A to Z
13. Split data across multiple sheets – VBA
15. Yet another Excel Calendar
DATEDIF function
1. Date and Time Functions – A to M
2. How to use the DATEDIF function
Dates
1. Calculate machine utilization
2. Extract dates from overlapping date ranges
3. Find all sequences of consecutive dates
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. Get date ranges from a schedule
7. How to create date ranges in Excel
8. Identify rows of overlapping records
10. Working with overlapping date ranges
Dates
1. Calculate machine utilization
2. Extract dates from overlapping date ranges
3. Find all sequences of consecutive dates
4. Find the most recent date that meets a particular condition
5. Formula for matching a date within a date range
6. Get date ranges from a schedule
7. How to create date ranges in Excel
DATEVALUE function
1. Date and Time Functions – A to M
2. Formula for matching a date within a date range
3. How to use the DATEVALUE function
DAVERAGE function
DAY function
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Date and Time Functions – A to M
3. Date and Time Functions – N to Z
4. Follow stock market trends – Moving Average
5. Get date ranges from a schedule
6. How to track sector performance in the stock market – Excel template
7. How to use the DAY function
9. Populate drop down list with unique distinct values sorted from A to Z
DAYS function
1. Date and Time Functions – A to M
2. How to use the DAYS function
DB function
DCOUNT function
DDB function
DEC2BIN function
1. Engineering functions – A to C
2. Engineering functions – D to IMC
3. Working with classic ciphers in Excel
DEC2HEX function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
DEC2OCT function
1. Engineering functions – D to IMC
DECIMAL function
1. How to use the DECIMAL function
DEGREES function
1. Engineering functions – D to IMC
2. How to use the DEGREES function
DELTA function
1. Engineering functions – D to IMC
Dependent drop down lists
1. Create dependent drop down lists containing unique distinct values
DGET function
Dialog boxes
DMAX function
DMIN function
DO LOOP statement
Doughnut chart
DOUNTA function
DPRODUCT function
Drop down lists
1. Advanced Techniques for Conditional Formatting
3. Populate drop down list with unique distinct values sorted from A to Z
4. Run a Macro from a Drop Down list [VBA]
5. Use a drop down list to search and return multiple values
DROP function
1. Array Manipulation Functions
2. Calculate machine utilization
3. Filter strings containing a given substring in a cell range
4. Filter unique distinct records case sensitive
5. How to create date ranges in Excel
6. Merge cell ranges into one list
7. Search for a text string in a data set and return multiple records
8. Working with classic ciphers in Excel
DSTDEV function
DSTDEVP function
DSUM function
Duplicate records
Duplicate values
1. Extract a list of duplicates from a column
2. Extract duplicates from a multi-column cell range
3. Filter duplicate values based on criteria
DVARP function
EDATE function
1. 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. How to compare two data sets
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
Excel Basics
Excel table
EXP function
1. How to use the EXP function
EXPAND function
1. Array Manipulation Functions
2. Filter unique distinct records case sensitive
EXPON.DIST function
1. How to use the EXPON.DIST function
EXPONDIST function
Extract
1. Extract specific word based on position in cell value
2. How to extract numbers from a cell value
F.DIST function
1. How to use the F.DIST function
F.DIST.RT
1. How to use the F.DIST.RT function
F.TEST function
1. How to use the F.TEST function
FACT function
2. How to use the FACT function
FALSE function
1. Advanced Excel Chart Techniques
2. Array Manipulation Functions
3. Automate net asset value (NAV) calculation on your stock portfolio
4. Extract a list of duplicates from a column
5. Get date ranges from a schedule
6. How to generate a round-robin tournament
7. How to use the asterisk character
8. How to use VLOOKUP/XLOOKUP with multiple conditions
9. If cell contains text from list
10. INDEX MATCH – multiple results
11. Match two criteria and return multiple records
12. Merge tables based on a condition
13. Plot date ranges in a calendar
14. Populate drop down list with unique distinct values sorted from A to Z
15. Rearrange values using formulas
16. Repeat values across cells
17. Search for a text string in a data set and return multiple records
18. Unique distinct records sorted based on count or frequency
19. VLOOKUP – Return multiple unique distinct values
20. Working with classic ciphers in Excel
21. Working with Relational Tables in Excel
22. Working with unique values
FDIST function
Features
1. 5 easy ways to extract Unique Distinct Values
2. Advanced Techniques for Conditional Formatting
3. Create a dynamic named range
4. Create dependent drop down lists containing unique distinct values
6. Extract unique distinct values in an Excel Table filtered list
7. How to compare two data sets
8. How to solve simultaneous linear equations in Excel
9. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
12. How to use Pivot Tables – Excel’s most powerful feature and also least known
13. How to use the COMBIN function
15. How to use the Subtotal tool
16. Identify numbers in sum using Excel solver
17. Lookup with any number of criteria
18. Populate drop down list with unique distinct values sorted from A to Z
19. Prevent duplicate records in a worksheet
20. Run a Macro from a Drop Down list [VBA]
21. Use a drop down list to search and return multiple values
22. Working with Excel tables programmatically
Files and folders
1. Copy data from workbooks in folder and subfolders
2. Search all workbooks in a folder
3. Search for a file in folder and subfolders – UDF
Filter emails
1. Filter strings containing a given substring in a cell range
FILTER function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Array Manipulation Functions
4. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Compare tables: Filter records occurring only in one table
6. Compare two columns and extract differences
7. Compare two columns in different worksheets
9. Count unique distinct records
10. Count unique distinct values
11. Create dependent drop down lists containing unique distinct values
12. Date and Time Functions – A to M
13. Date and Time Functions – N to Z
14. Engineering functions – A to C
15. Extract a list of duplicates from a column
16. Extract a unique distinct list sorted from A to Z
17. Extract all rows from a range that meet criteria in one column
18. Extract dates from overlapping date ranges
19. Extract duplicates from a multi-column cell range
20. Extract records between two dates
21. Extract unique distinct values from a multi-column cell range
22. Extract unique distinct values in an Excel Table filtered list
23. Filter duplicate values based on criteria
24. Filter strings containing a given substring in a cell range
25. Filter unique distinct records
26. Filter unique distinct records case sensitive
27. Find all sequences of consecutive dates
29. Find the most recent date that meets a particular condition
30. Get date ranges from a schedule
31. How to compare two data sets
32. How to create date ranges in Excel
33. How to extract a case sensitive unique list from a column
34. How to extract numbers from a cell value
35. How to list unique distinct values sorted by frequency
36. How to return a value if lookup value is in a range
37. How to use the FILTER function
38. How to use VLOOKUP/XLOOKUP with multiple conditions
39. Identify rows of overlapping records
40. If cell contains text from list
41. INDEX MATCH – multiple results
42. Lookup and return multiple values concatenated into one cell
43. Lookup multiple values across columns and return a single value
44. Lookup with any number of criteria
45. Match two criteria and return multiple records
46. Merge cell ranges into one list
48. Partial match and return multiple adjacent values
49. Partial match for multiple strings – AND logic
50. Search for a sequence of values
51. Search for a text string in a data set and return multiple records
52. Sort a column alphabetically
54. VLOOKUP – Return multiple unique distinct values
55. Wildcard lookups and include or exclude criteria
57. Working with overlapping date ranges
58. Working with Relational Tables in Excel
59. Working with unique values
Filter records
1. Extract all rows from a range that meet criteria in one column
2. Extract records between two dates
3. Match two criteria and return multiple records
4. Search for a text string in a data set and return multiple records
FILTERXML function
1. A Comprehensive Guide to Splitting Text in Excel
2. How to use the FILTERXML function
3. How to use the LIKE OPERATOR
4. Rearrange values using formulas
Finance
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Compare the performance of your stock portfolio to S&P 500 using Excel
3. Follow stock market trends – Moving Average
4. How to track sector performance in the stock market – Excel template
FIND function
1. Count cells containing text from list
2. Formula for matching a date within a date range
3. How to use the FIND function
4. INDEX MATCH – multiple results
5. Search for a sequence of values
6. Search for a text string in a data set and return multiple records
7. Working with classic ciphers in Excel
Find numbers in sum
1. Find numbers closest to sum
2. How to do tiered calculations in one formula
3. Identify numbers in sum using Excel solver
Fix Function
FIXED function
1. How to use the FIXED function
FLOOR function
FLOOR.MATH function
1. How to use the FLOOR.MATH function
FLOOR.PRECISE function
1. How to use the FLOOR.PRECISE function
FOR NEXT statement
1. Create links to all sheets in a workbook programmatically
2. Finding the shortest path – A * pathfinding
3. Working with comments – VBA
FORECAST function
FORECAST.LINEAR function
1. How to use the FORECAST.LINEAR function
Form Controls
1. Create a Print button – macro
3. Working with COMBO BOXES [Form Controls]
4. Working with LIST BOXES (Form Controls)
5. Working with TEXT BOXES [Form Controls]
Formula characters
1. How to use the asterisk character
FORMULATEXT function
1. How to use the FORMULATEXT function
FREQUENCY function
Frequency table
1. How to list unique distinct values sorted by frequency
2. Sort rows based on frequency and criteria
FTEST function
Functions
1. How to copy non contiguous cell ranges
2. Working with COMBO BOXES [Form Controls]
Funnel chart
Fuzzy lookup
FV function
GAMMA.DIST function
1. How to use the GAMMA.DIST function
GAMMADIST function
Gantt
GCD function
1. How to use the GCD function
GDC function
1. How to use the GCD function
GEOMEAN function
1. How to use the GEOMEAN function
GoTo statement
GROUPBY function
1. How to use the GROUPBY function
GROWTH function
1. How to use the GROWTH function
HARMEAN function
1. How to use the HARMEAN function
HEX2BIN function
1. Engineering functions – D to IMC
HEX2DEC function
1. Engineering functions – D to IMC
2. Working with classic ciphers in Excel
HEX2OCT function
1. Engineering functions – D to IMC
Highlight
1. Highlight a data series in a chart
Highlight Cells Rules
1. Conditional Formatting Basics
Highlight duplicates
Histogram chart
HLOOKUP function
1. How to use the HLOOKUP function
HOUR function
1. Date and Time Functions – A to M
2. Date and Time Functions – N to Z
3. How to use the HOUR function
HSTACK function
1. Array Manipulation Functions
2. Calculate machine utilization
3. Date and Time Functions – N to Z
4. Filter unique distinct records
6. Get date ranges from a schedule
7. How to create date ranges in Excel
8. Merge cell ranges into one list
9. Sort rows based on frequency and criteria
11. Working with classic ciphers in Excel
HYPERLINK function
1. How to perform a two-dimensional lookup
2. How to quickly find the maximum or minimum value [Formula]
3. How to use the HYPERLINK function
4. INDEX MATCH – multiple results
Hyperlinks
1. Create links to all sheets in a workbook programmatically
2. List all hyperlinks in worksheet programmatically
HYPGEOM.DIST function
1. How to use the HYPGEOM.DIST function
IF
IF function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. A beginners guide to Excel array formulas
4. A Comprehensive Guide to Splitting Text in Excel
5. Array Manipulation Functions
6. 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
13. Count cells containing text from list
14. Count unique distinct records
15. Count unique distinct values
16. Create dependent drop down lists containing unique distinct values
18. Date and Time Functions – A to M
19. Date and Time Functions – N to Z
21. Excel calendar
22. Extract a list of duplicates from a column
23. Extract a unique distinct list from multiple non adjacent cell ranges
24. Extract a unique distinct list sorted from A to Z
25. Extract all rows from a range that meet criteria in one column
26. Extract dates from overlapping date ranges
27. Extract duplicates from a multi-column cell range
28. Extract records between two dates
29. Extract specific word based on position in cell value
30. Extract unique distinct values from a multi-column cell range
31. Extract unique distinct values in an Excel Table filtered list
32. Filter duplicate values based on criteria
33. Filter strings containing a given substring in a cell range
34. Filter unique distinct records
35. Find all sequences of consecutive dates
36. Find and return the highest number and corresponding date based on a condition
38. Find numbers closest to sum
39. Find the most recent date that meets a particular condition
40. Follow stock market trends – Moving Average
41. Formula for matching a date within a date range
42. Fuzzy VLOOKUP
43. Get date ranges from a schedule
44. Highlight unique values in a filtered Excel table
45. How to compare two data sets
46. How to create date ranges in Excel
47. How to extract a case sensitive unique list from a column
48. How to extract numbers from a cell value
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 return a value if lookup value is in a range
54. How to solve simultaneous linear equations in Excel
55. How to track sector performance in the stock market – Excel template
57. How to use the IF function
58. How to use VLOOKUP/XLOOKUP with multiple conditions
59. Identify rows of overlapping records
60. If cell contains text from list
61. INDEX MATCH – multiple results
62. Lookup and return multiple values concatenated into one cell
63. Lookup multiple values across columns and return a single value
64. Lookup with any number of criteria
65. Match two criteria and return multiple records
66. Merge cell ranges into one list
67. Merge tables based on a condition
69. Partial match and return multiple adjacent values
70. Partial match for multiple strings – AND logic
71. Plot date ranges in a calendar
72. Populate drop down list with unique distinct values sorted from A to Z
73. Rearrange values using formulas
74. Repeat values across cells
75. Rotating unique groups with no repeat
76. Search for a sequence of values
77. Search for a text string in a data set and return multiple records
78. Sort a column alphabetically
79. Sort rows based on frequency and criteria
80. Split data across multiple sheets – VBA
83. Unique distinct records sorted based on count or frequency
84. Use a drop down list to search and return multiple values
85. VLOOKUP – Return multiple unique distinct values
86. Wildcard lookups and include or exclude criteria
87. Working with classic ciphers in Excel
88. Working with COMBO BOXES [Form Controls]
90. Working with overlapping date ranges
91. Working with Relational Tables in Excel
92. Working with running totals
93. 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
4. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
5. Compare tables: Filter records occurring only in one table
6. Compare the performance of your stock portfolio to S&P 500 using Excel
7. Compare two columns and extract differences
8. Count cells containing text from list
9. Count unique distinct records
10. Count unique distinct values
11. Date and Time Functions – N to Z
13. Excel calendar
14. Extract a list of duplicates from a column
15. Extract a unique distinct list from multiple non adjacent cell ranges
16. Extract a unique distinct list sorted from A to Z
17. Extract records between two dates
18. Extract specific word based on position in cell value
19. Extract unique distinct values from a multi-column cell range
20. Extract unique distinct values in an Excel Table filtered list
21. Filter duplicate values based on criteria
22. Filter unique distinct records
23. Find all sequences of consecutive dates
24. Find and return the highest number and corresponding date based on a condition
26. Follow stock market trends – Moving Average
27. Fuzzy VLOOKUP
28. Get date ranges from a schedule
29. How to compare two data sets
30. How to generate a round-robin tournament
31. How to perform a two-dimensional lookup
33. How to use the IFERROR function
35. Identify rows of overlapping records
36. If cell contains text from list
37. Lookup and return multiple values concatenated into one cell
38. Lookup with any number of criteria
39. Merge cell ranges into one list
40. Plot date ranges in a calendar
41. Search for a text string in a data set and return multiple records
42. Sort rows based on frequency and criteria
43. Split data across multiple sheets – VBA
45. Team Generator
47. Use a drop down list to search and return multiple values
48. VLOOKUP – Return multiple unique distinct values
49. Wildcard lookups and include or exclude criteria
50. Working with classic ciphers in Excel
51. Working with COMBO BOXES [Form Controls]
52. Working with overlapping date ranges
53. Working with Relational Tables in Excel
54. Working with unique values
IFNA function
1. Array Manipulation Functions
2. Filter unique distinct records
3. Get date ranges from a schedule
4. How to use the IFNA function
5. 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. A beginners guide to Excel array formulas
4. Array Manipulation Functions
5. Automate net asset value (NAV) calculation on your stock portfolio
6. Calculate machine utilization
7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
8. Compare tables: Filter records occurring only in one table
9. Compare the performance of your stock portfolio to S&P 500 using Excel
10. Compare two columns and extract differences
11. Compare two columns in different worksheets
13. Count cells containing text from list
14. Create dependent drop down lists containing unique distinct values
15. Date and Time Functions – A to M
18. Excel calendar
19. Extract a list of duplicates from a column
20. Extract a unique distinct list from multiple non adjacent cell ranges
21. Extract a unique distinct list sorted from A to Z
22. Extract all rows from a range that meet criteria in one column
23. Extract duplicates from a multi-column cell range
24. Extract records between two dates
25. Extract specific word based on position in cell value
26. Extract unique distinct values from a multi-column cell range
27. Extract unique distinct values in an Excel Table filtered list
28. Filter duplicate values based on criteria
29. Filter unique distinct records
30. Filter unique distinct records case sensitive
31. Find and return the highest number and corresponding date based on a condition
33. Find numbers closest to sum
34. Find the most recent date that meets a particular condition
35. Follow stock market trends – Moving Average
36. Formula for matching a date within a date range
37. Fuzzy VLOOKUP
38. Get date ranges from a schedule
39. Highlight a data series in a chart
40. How to animate an Excel chart
41. How to compare two data sets
42. How to copy non contiguous cell ranges
43. How to create date ranges in Excel
44. How to extract a case sensitive unique list from a column
45. How to extract numbers from a cell value
46. How to generate a round-robin tournament
47. How to highlight differences and common values in lists
48. How to list unique distinct values sorted by frequency
49. How to perform a two-dimensional lookup
50. How to quickly find the maximum or minimum value [Formula]
51. How to return a value if lookup value is in a range
52. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
55. How to use Pivot Tables – Excel’s most powerful feature and also least known
56. How to use the INDEX function
57. How to use the MAKEARRAY function
59. How to use VLOOKUP/XLOOKUP with multiple conditions
60. If cell contains text from list
61. INDEX MATCH – multiple results
62. Lookup multiple values across columns and return a single value
63. Lookup with any number of criteria
64. Match two criteria and return multiple records
65. Merge cell ranges into one list
66. Merge tables based on a condition
67. Partial match and return multiple adjacent values
68. Partial match for multiple strings – AND logic
69. Plot date ranges in a calendar
70. Populate drop down list with unique distinct values sorted from A to Z
71. Rearrange values using formulas
72. Repeat values across cells
73. Rotating unique groups with no repeat
74. Search for a text string in a data set and return multiple records
75. Show / hide a picture using a button
76. Sort a column alphabetically
77. Sort rows based on frequency and criteria
78. Split data across multiple sheets – VBA
80. Team Generator
82. Unique distinct records sorted based on count or frequency
83. Use a drop down list to search and return multiple values
85. VLOOKUP – Return multiple unique distinct values
86. Wildcard lookups and include or exclude criteria
87. Working with classic ciphers in Excel
88. Working with COMBO BOXES [Form Controls]
89. Working with overlapping date ranges
90. Working with Relational Tables in Excel
91. Working with unique values
INDIRECT function
1. Add values to a regular drop-down list programmatically
2. Advanced Techniques for Conditional Formatting
3. Date and Time Functions – N to Z
5. Get date ranges from a schedule
6. Highlight a data series in a chart
7. Highlight unique values in a filtered Excel table
9. How to generate a round-robin tournament
12. How to use the INDIRECT function
13. Plot date ranges in a calendar
14. Prevent duplicate records in a worksheet
15. Working with overlapping date ranges
16. Working with Relational Tables in Excel
INFO function
1. How to use the INFO function
INT function
1. Calculate machine utilization
2. Date and Time Functions – A to M
4. Find numbers closest to sum
6. How to generate a round-robin tournament
8. How to use the INT function
INT function
1. Calculate machine utilization
2. Date and Time Functions – A to M
4. Find numbers closest to sum
6. How to generate a round-robin tournament
8. How to use the INT function
Interactive
1. How to create an interactive Excel chart
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 cell ranges into one list
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
3. Compare two columns in different worksheets
4. Extract a list of duplicates from a column
5. Extract a unique distinct list from multiple non adjacent cell ranges
8. How to generate a round-robin tournament
9. How to highlight differences and common values in lists
10. How to perform a two-dimensional lookup
11. How to use the ISERROR function
12. Match two criteria and return multiple records
13. Merge cell ranges into one list
14. Merge tables based on a condition
15. Search for a text string in a data set and return multiple records
16. 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 cells containing text from list
3. Extract a unique distinct list sorted from A to Z
4. Extract duplicates from a multi-column cell range
5. Extract unique distinct values from a multi-column cell range
6. Filter strings containing a given substring in a cell range
7. How to extract numbers from a cell value
8. How to use the ISNUMBER function
9. If cell contains text from list
10. INDEX MATCH – multiple results
11. Match two criteria and return multiple records
12. Partial match and return multiple adjacent values
13. Partial match for multiple strings – AND logic
14. Search for a sequence of values
15. Search for a text string in a data set and return multiple records
16. VLOOKUP – Return multiple unique distinct values
17. Wildcard lookups and include or exclude criteria
18. 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 with any number of criteria
6. 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. Count cells containing text from list
4. Extract specific word based on position in cell value
5. Filter strings containing a given substring in a cell range
6. Filter unique distinct records case sensitive
8. How to create date ranges in Excel
9. How to use the LAMBDA function
10. How to use the MAKEARRAY function
11. Merge cell ranges into one list
12. Rearrange values using formulas
13. Search for a text string in a data set and return multiple records
14. Working with classic ciphers in Excel
LARGE function
1. Date and Time Functions – A to M
3. Extract unique distinct values from a multi-column cell range
4. Find the most recent date that meets a particular condition
5. Follow stock market trends – Moving Average
6. How to generate a round-robin tournament
7. How to use the LARGE function
9. Rotating unique groups with no repeat
10. Sort a column alphabetically
11. Sort rows based on frequency and criteria
12. Team Generator
13. 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. Follow stock market trends – Moving Average
8. Formula for matching a date within a date range
10. How to use the LEFT function
11. Lookup and return multiple values concatenated into one cell
12. Search for a text string in a data set and return multiple records
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 cells containing text from list
5. Engineering functions – A to C
6. Extract a unique distinct list sorted from A to Z
7. Extract duplicates from a multi-column cell range
8. Extract unique distinct values from a multi-column cell range
9. Formula for matching a date within a date range
10. Fuzzy VLOOKUP
11. How to extract numbers from a cell value
12. How to use the LEN function
13. INDEX MATCH – multiple results
14. Lookup and return multiple values concatenated into one cell
15. Partial match and return multiple adjacent values
16. Search for a text string in a data set and return multiple records
17. Sort a column alphabetically
18. VLOOKUP – Return multiple unique distinct values
19. 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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
7. Compare two columns and extract differences
9. Date and Time Functions – N to Z
11. Excel calendar
12. Extract a list of duplicates from a column
13. Extract dates from overlapping date ranges
14. Extract duplicates from a multi-column cell range
15. Extract unique distinct values from a multi-column cell range
16. Extract unique distinct values in an Excel Table filtered list
17. Filter duplicate values based on criteria
18. Filter unique distinct records case sensitive
19. Find all sequences of consecutive dates
21. Find numbers closest to sum
22. Fuzzy VLOOKUP
23. Get date ranges from a schedule
24. How to create date ranges in Excel
25. How to do tiered calculations in one formula
26. How to extract a case sensitive unique list from a column
27. How to extract numbers from a cell value
28. How to list unique distinct values sorted by frequency
29. How to return a value if lookup value is in a range
30. How to track sector performance in the stock market – Excel template
31. How to use the LET function
32. How to use VLOOKUP/XLOOKUP with multiple conditions
33. If cell contains text from list
34. Match two criteria and return multiple records
35. Merge cell ranges into one list
36. Repeat values across cells
37. Search for a text string in a data set and return multiple records
38. Sort a column alphabetically
39. Sort rows based on frequency and criteria
41. Team Generator
42. Unique distinct records sorted based on count or frequency
43. VLOOKUP – Return multiple unique distinct values
44. Wildcard lookups and include or exclude criteria
45. Working with classic ciphers in Excel
46. 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 unique distinct list from multiple non adjacent cell ranges
4. Extract a unique distinct list sorted from A to Z
5. Formula for matching a date within a date range
6. How to return a value if lookup value is in a range
7. How to use the LOOKUP function
8. How to use VLOOKUP/XLOOKUP with multiple conditions
9. INDEX MATCH – multiple results
10. Partial match and return multiple adjacent values
11. Partial match for multiple strings – AND logic
12. VLOOKUP – Return multiple unique distinct values
14. Working with unique values
Lookup numerical ranges
Lookups
1. How to perform a two-dimensional lookup
2. 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. Create a Print button – macro
5. Create new worksheets programmatically based on values in a cell range [VBA]
6. Customize the ribbon and how to add your macros
8. Excel template: Getting Things Done [VBA]
10. How to copy non contiguous cell ranges
11. How to create an interactive Excel chart
12. How to save specific multiple worksheets to a pdf file programmatically
15. Run a Macro from a Drop Down list [VBA]
17. Show / hide a picture using a button
18. Split data across multiple sheets – VBA
19. User opens or closes a workbook creates an event
20. Working with COMBO BOXES [Form Controls]
21. Working with comments – VBA
22. Working with Excel tables programmatically
24. 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. A beginners guide to Excel array formulas
4. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare tables: Filter records occurring only in one table
7. Compare the performance of your stock portfolio to S&P 500 using Excel
8. Compare two columns and extract differences
9. Compare two columns in different worksheets
11. Count cells containing text from list
12. Count unique distinct values
13. Create dependent drop down lists containing unique distinct values
15. Date and Time Functions – A to M
18. Excel calendar
19. Extract a list of duplicates from a column
20. Extract a unique distinct list from multiple non adjacent cell ranges
21. Extract a unique distinct list sorted from A to Z
22. Extract all rows from a range that meet criteria in one column
23. Extract duplicates from a multi-column cell range
24. Extract records between two dates
25. Extract unique distinct values from a multi-column cell range
26. Extract unique distinct values in an Excel Table filtered list
27. Filter duplicate values based on criteria
28. Filter unique distinct records
29. Find and return the highest number and corresponding date based on a condition
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. Formula for matching a date within a date range
35. Get date ranges from a schedule
36. Highlight unique values in a filtered Excel table
37. How to animate an Excel chart
38. How to compare two data sets
39. How to extract a case sensitive unique list from a column
40. How to generate a round-robin tournament
41. How to highlight differences and common values in lists
42. How to list unique distinct values sorted by frequency
43. How to perform a two-dimensional lookup
44. How to quickly find the maximum or minimum value [Formula]
45. How to return a value if lookup value is in a range
46. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
47. How to use Pivot Tables – Excel’s most powerful feature and also least known
48. How to use the MATCH function
49. How to use VLOOKUP/XLOOKUP with multiple conditions
50. If cell contains text from list
51. INDEX MATCH – multiple results
52. Lookup and return multiple values concatenated into one cell
53. 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 cell ranges into one list
57. Merge tables based on a condition
59. Partial match and return multiple adjacent values
60. Partial match for multiple strings – AND logic
61. Plot date ranges in a calendar
62. Populate drop down list with unique distinct values sorted from A to Z
63. Repeat values across cells
64. Rotating unique groups with no repeat
65. Search for a sequence of values
66. Search for a text string in a data set and return multiple records
67. Show / hide a picture using a button
68. Sort a column alphabetically
69. Sort rows based on frequency and criteria
70. Split data across multiple sheets – VBA
72. Team Generator
74. Unique distinct records sorted based on count or frequency
75. Use a drop down list to search and return multiple values
77. VLOOKUP – Return multiple unique distinct values
78. Wildcard lookups and include or exclude criteria
79. Working with classic ciphers in Excel
80. Working with COMBO BOXES [Form Controls]
81. Working with overlapping date ranges
82. Working with Relational Tables in Excel
83. Working with unique values
Mathematics
1. How to solve simultaneous linear equations in Excel
MAX function
2. Extract a unique distinct list sorted from A to Z
3. Extract dates from overlapping date ranges
4. Extract specific word based on position in cell value
5. Find and return the highest number and corresponding date based on a condition
6. Find the most recent date that meets a particular condition
7. Follow stock market trends – Moving Average
9. How to create date ranges in Excel
10. How to list unique distinct values sorted by frequency
11. How to quickly find the maximum or minimum value [Formula]
13. How to use the MAX function
14. Identify rows of overlapping records
15. Repeat values across cells
17. Working with overlapping date ranges
18. Working with unique values
MAXIFS function
Maze
1. Build 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 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 extract numbers from a cell value
8. How to return a value if lookup value is in a range
9. How to use the MID function
10. INDEX MATCH – multiple results
11. Search for a text string in a data set and return multiple records
12. Working with classic ciphers in Excel
MIN function
1. A beginners guide to Excel array formulas
2. Compare the performance of your stock portfolio to S&P 500 using Excel
3. Compare two columns in different worksheets
4. Extract a list of duplicates from a column
5. Extract dates from overlapping date ranges
6. Extract duplicates from a multi-column cell range
7. Extract unique distinct values from a multi-column cell range
8. Find and return the highest number and corresponding date based on a condition
9. Find numbers closest to sum
10. Find the most recent date that meets a particular condition
11. Follow stock market trends – Moving Average
12. How to compare two data sets
13. How to create date ranges in Excel
14. How to highlight duplicate values
15. How to list unique distinct values sorted by frequency
16. How to perform a two-dimensional lookup
17. How to quickly find the maximum or minimum value [Formula]
18. How to use the MIN function
19. How to use VLOOKUP/XLOOKUP with multiple conditions
20. Identify rows of overlapping records
21. INDEX MATCH – multiple results
22. Lookup with any number of criteria
23. Partial match and return multiple adjacent values
24. Repeat values across cells
25. Search for a text string in a data set and return multiple records
26. Sort a column alphabetically
28. VLOOKUP – Return multiple unique distinct values
29. Working with overlapping date ranges
30. 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
Missing values
MMULT function
1. 5 easy ways to extract Unique Distinct Values
2. Count cells containing text from list
3. Count unique distinct values
5. Filter unique distinct records case sensitive
6. Find numbers closest to sum
7. Get date ranges from a schedule
8. How to compare two data sets
9. How to extract a case sensitive unique list from a column
10. How to extract numbers from a cell value
11. How to solve simultaneous linear equations in Excel
12. How to use the MMULT function
13. Identify rows of overlapping records
14. INDEX MATCH – multiple results
15. Lookup with any number of criteria
16. Match two criteria and return multiple records
17. Partial match and return multiple adjacent values
18. Search for a text string in a data set and return multiple records
19. VLOOKUP – Return multiple unique distinct values
20. Wildcard lookups and include or exclude criteria
21. 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
MONTH function
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Count cells containing text from list
3. Count unique distinct values
4. Date and Time Functions – A to M
5. Date and Time Functions – N to Z
7. Filter unique distinct records
8. Follow stock market trends – Moving Average
9. Get date ranges from a schedule
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 MONTH function
14. Plot date ranges in a calendar
15. Populate drop down list with unique distinct values sorted from A to Z
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
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. Filter unique distinct records
5. How to compare two data sets
6. How to generate a round-robin tournament
7. How to use the NOT function
8. If cell contains text from list
9. Wildcard lookups and include or exclude criteria
10. 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. Create dependent drop down lists containing unique distinct values
5. Extract dates from overlapping date ranges
6. Extract unique distinct values in an Excel Table filtered list
8. Follow stock market trends – Moving Average
9. Highlight unique values in a filtered Excel table
10. How to generate a round-robin tournament
12. How to use the OFFSET function
13. How to use VLOOKUP/XLOOKUP with multiple conditions
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
8. Search for a text string in a data set and return multiple records
Overlapping
1. Identify rows of overlapping records
2. Working with overlapping date ranges
Pareto chart
Pathfinding
1. 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
PERMUTATIONA function
Permutations
1. Find numbers closest to sum
3. 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 use Pivot Tables – Excel’s most powerful feature and also least known
PMT function
POWER function
1. How to use the POWER function
PPMT function
PRICEMAT function
1. Create a Print button – macro
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 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. How to generate a round-robin tournament
2. How to use the RANDBETWEEN function
3. Rotating unique groups with no repeat
5. Working with classic ciphers in Excel
Random
1. How to generate a round-robin tournament
Range
Range.Find method
RANGE.OFFSET property
Rank
RANK function
2. Find the most recent date that meets a particular condition
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 using formulas
Records
1. Compare tables: Filter records occurring only in one table
2. Unique distinct records sorted based on count or frequency
Recursive
REDUCE function
1. Filter strings containing a given substring in a cell range
2. How to create date ranges in Excel
3. How to use the REDUCE function
4. Merge cell ranges into one list
5. Rearrange values using formulas
6. Search for a text string in a data set and return multiple records
7. 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 use the REPT function
5. Search for a text string in a data set and return multiple records
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
ROUNDDOWN function
1. How to use the ROUNDDOWN function
2. Rearrange values using formulas
ROUNDUP function
1. Array Manipulation Functions
2. How to use the ROUNDUP function
4. 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. Count unique distinct records
8. Count unique distinct values
9. 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
14. Engineering functions – D to IMC
15. Excel calendar
16. Extract a list of duplicates from a column
17. Extract all rows from a range that meet criteria in one column
18. Extract dates from overlapping date ranges
19. Extract specific word based on position in cell value
20. Extract unique distinct values in an Excel Table filtered list
21. Filter duplicate values based on criteria
22. Filter unique distinct records case sensitive
23. Find all sequences of consecutive dates
25. Find numbers closest to sum
26. Find the most recent date that meets a particular condition
27. Follow stock market trends – Moving Average
28. Get date ranges from a schedule
29. How to compare two data sets
30. How to copy non contiguous cell ranges
31. How to create date ranges in Excel
32. How to extract a case sensitive unique list from a column
33. How to extract numbers from a cell value
34. How to generate a round-robin tournament
35. How to return a value if lookup value is in a range
36. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
38. How to use the MAKEARRAY function
39. How to use the ROWS function
40. How to use VLOOKUP/XLOOKUP with multiple conditions
41. INDEX MATCH – multiple results
42. Match two criteria and return multiple records
43. Merge cell ranges into one list
44. Partial match and return multiple adjacent values
45. Partial match for multiple strings – AND logic
46. Populate drop down list with unique distinct values sorted from A to Z
47. Rearrange values using formulas
48. Repeat values across cells
49. Search for a sequence of values
50. Search for a text string in a data set and return multiple records
51. Sort a column alphabetically
52. Sort rows based on frequency and criteria
53. Split data across multiple sheets – VBA
54. Team Generator
55. VLOOKUP – Return multiple unique distinct values
57. Working with overlapping date ranges
58. Working with Relational Tables in Excel
59. 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. Advanced Excel Chart Techniques
2. How to add horizontal line to chart
3. How to improve your Excel Chart
Schedule
1. Get date ranges from a schedule
Scroll bar
Search and return multiple values
1. Partial match and return multiple adjacent values
2. Partial match for multiple strings – AND logic
3. 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. Filter strings containing a given substring in a cell range
8. Filter unique distinct records
10. How to extract numbers from a cell value
11. How to use the SEARCH function
12. If cell contains text from list
13. INDEX MATCH – multiple results
14. Lookup and return multiple values concatenated into one cell
15. Match two criteria and return multiple records
16. Partial match and return multiple adjacent values
17. Partial match for multiple strings – AND logic
18. Search for a text string in a data set and return multiple records
19. VLOOKUP – Return multiple unique distinct values
20. Wildcard lookups and include or exclude criteria
21. 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 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. Create a dynamic named range
7. Date and Time Functions – A to M
8. Date and Time Functions – N to Z
9. Extract dates from overlapping date ranges
10. Extract unique distinct values in an Excel Table filtered list
12. Find numbers closest to sum
13. Fuzzy VLOOKUP
14. Get date ranges from a schedule
15. How to copy non contiguous cell ranges
16. How to create date ranges in Excel
17. How to extract numbers from a cell value
18. How to use the SEQUENCE function
19. How to use VLOOKUP/XLOOKUP with multiple conditions
20. Rearrange values using formulas
21. Repeat values across cells
22. Search for a text string in a data set and return multiple records
23. Sort a column alphabetically
25. Team Generator
26. Working with classic ciphers in Excel
27. 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 cells containing text from list
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 beginners guide to Excel array formulas
3. 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. Count cells containing text from list
9. Create dependent drop down lists containing unique distinct values
10. Date and Time Functions – N to Z
11. Excel calendar
12. Extract a list of duplicates from a column
13. Extract a unique distinct list sorted from A to Z
14. Extract all rows from a range that meet criteria in one column
15. Extract dates from overlapping date ranges
16. Extract records between two dates
17. Extract specific word based on position in cell value
18. Extract unique distinct values from a multi-column cell range
19. Extract unique distinct values in an Excel Table filtered list
20. Filter duplicate values based on criteria
21. Filter unique distinct records
22. Find all sequences of consecutive dates
23. Find and return the highest number and corresponding date based on a condition
25. Find the most recent date that meets a particular condition
26. Follow stock market trends – Moving Average
27. Formula for matching a date within a date range
28. Fuzzy VLOOKUP
29. Get date ranges from a schedule
30. How to compare two data sets
31. How to create date ranges in Excel
32. How to extract a case sensitive unique list from a column
33. How to extract numbers from a cell value
34. How to generate a round-robin tournament
35. How to perform a two-dimensional lookup
36. How to return a value if lookup value is in a range
37. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
39. How to use the SMALL function
40. How to use VLOOKUP/XLOOKUP with multiple conditions
41. Identify rows of overlapping records
42. If cell contains text from list
43. INDEX MATCH – multiple results
44. Lookup multiple values across columns and return a single value
45. Lookup with any number of criteria
46. Match two criteria and return multiple records
47. Merge cell ranges into one list
48. Partial match and return multiple adjacent values
49. Partial match for multiple strings – AND logic
50. Plot date ranges in a calendar
51. Populate drop down list with unique distinct values sorted from A to Z
52. Repeat values across cells
53. Search for a sequence of values
54. Search for a text string in a data set and return multiple records
55. Sort a column alphabetically
56. Split data across multiple sheets – VBA
58. Use a drop down list to search and return multiple values
59. VLOOKUP – Return multiple unique distinct values
60. Wildcard lookups and include or exclude criteria
61. Working with COMBO BOXES [Form Controls]
63. Working with overlapping date ranges
64. Working with Relational Tables in Excel
65. 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. Engineering functions – A to C
4. Extract a list of duplicates from a column
5. Extract a unique distinct list sorted from A to Z
6. Extract unique distinct values from a multi-column cell range
7. Filter unique distinct records
8. Find all sequences of consecutive dates
10. How to create date ranges in Excel
11. How to extract numbers from a cell value
12. How to use the SORT function
13. Sort a column alphabetically
14. Sort rows based on frequency and criteria
15. Working with classic ciphers in Excel
17. 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. Sort a column alphabetically
SORTBY function
1. Array Manipulation Functions
3. Extract a unique distinct list sorted from A to Z
4. How to list unique distinct values sorted by frequency
5. How to sort a data set using three different approaches, built-in tools, array formulas, and VBA
6. How to use the SORTBY function
7. INDEX MATCH – multiple results
8. Sort a column alphabetically
10. Unique distinct records sorted based on count or frequency
11. 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
Stock market trend
1. Follow stock market trends – Moving Average
Stock portfolio
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Compare the performance of your stock portfolio to S&P 500 using Excel
STOCKHISTORY function
2. How to use the STOCKHISTORY function
SUBSTITUTE function
1. A Comprehensive Guide to Splitting Text in Excel
2. Count cells containing text from list
3. Date and Time Functions – A to M
4. Extract specific word based on position in cell value
6. How to use the SUBSTITUTE function
7. Partial match and return multiple adjacent values
8. Search for a text string in a data set and return multiple records
9. Working with classic ciphers in Excel
Substitute Replace
SUBTOTAL function
2. Extract unique distinct values in an Excel Table filtered list
3. Filter duplicate values based on criteria
4. Highlight unique values in a filtered Excel table
5. How to use the SUBTOTAL function
6. How to use the Subtotal tool
7. How to use VLOOKUP/XLOOKUP with multiple conditions
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 cells containing text from list
5. Count unique distinct records
6. Count unique distinct values
9. Extract a list of duplicates from a column
10. Extract a unique distinct list sorted from A to Z
11. Extract unique distinct values in an Excel Table filtered list
12. Filter strings containing a given substring in a cell range
13. Filter unique distinct records case sensitive
14. Get date ranges from a schedule
15. Highlight unique values in a filtered Excel table
17. How to use the asterisk character
18. How to use the SUM function
19. Identify numbers in sum using Excel solver
20. If cell contains text from list
21. Lookup with any number of criteria
22. Repeat values across cells
23. Rotating unique groups with no repeat
24. Search for a text string in a data set and return multiple records
25. Sort a column alphabetically
27. Team Generator
28. Working with classic ciphers in Excel
29. Working with overlapping date ranges
30. Working with Relational Tables in Excel
31. Working with running totals
SUMIF function
1. How to use the SUMIF function
3. Working with Relational Tables in Excel
4. Working with running totals
SUMIFS function
1. Filter unique distinct records
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
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 cells containing text from list
6. Count unique distinct records
7. Count unique distinct values
8. Create dependent drop down lists containing unique distinct values
10. Date and Time Functions – N to Z
11. Excel calendar
12. Filter unique distinct records
13. Find the most recent date that meets a particular condition
14. Formula for matching a date within a date range
15. How to create date ranges in Excel
16. How to do tiered calculations in one formula
17. How to generate a round-robin tournament
18. How to quickly find the maximum or minimum value [Formula]
19. How to return a value if lookup value is in a range
20. How to use the SUMPRODUCT function
21. Identify numbers in sum using Excel solver
22. Identify rows of overlapping records
23. If cell contains text from list
24. Plot date ranges in a calendar
25. Prevent duplicate records in a worksheet
26. Repeat values across cells
27. Sort rows based on frequency and criteria
28. Team Generator
29. Working with overlapping date ranges
30. 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
2. 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
Templates
1. Excel template: Getting Things Done [VBA]
Text boxes
1. Working with TEXT BOXES [Form Controls]
TEXT function
2. Date and Time Functions – A to M
3. Date and Time Functions – N to Z
4. Follow stock market trends – Moving Average
5. How to create date ranges in Excel
6. How to extract numbers from a cell value
7. How to use the TEXT function
8. Lookup and return multiple values concatenated into one cell
11. VLOOKUP – Return multiple unique distinct values
12. Working with classic ciphers in Excel
14. Working with running totals
Text string manipulation
Text string manipultion
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 use the TEXTSPLIT function
7. If cell contains text from list
8. Lookup with any number of criteria
9. Rearrange values using formulas
10. Search for a text string in a data set and return multiple records
11. Working with unique values
TextToColumns method
Time
TIME function
1. Date and Time Functions – N to Z
2. 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. Compare two columns in different worksheets
4. Count unique distinct values
6. Extract a list of duplicates from a column
7. Extract a unique distinct list from multiple non adjacent cell ranges
8. Extract duplicates from a multi-column cell range
9. Extract unique distinct values from a multi-column cell range
10. Get date ranges from a schedule
11. How to compare two data sets
12. How to create date ranges in Excel
13. How to list unique distinct values sorted by frequency
14. Rearrange values using formulas
15. Search for a text string in a data set and return multiple records
17. VLOOKUP – Return multiple unique distinct values
18. Working with classic ciphers in Excel
19. Working with overlapping date ranges
20. 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 using formulas
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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
7. Compare two columns in different worksheets
11. Extract a list of duplicates from a column
12. Extract duplicates from a multi-column cell range
13. Extract specific word based on position in cell value
14. Extract unique distinct values from a multi-column cell range
15. Formula for matching a date within a date range
16. How to compare two data sets
17. How to extract numbers from a cell value
18. How to list unique distinct values sorted by frequency
19. How to perform a two-dimensional lookup
20. How to return a value if lookup value is in a range
21. How to use VLOOKUP/XLOOKUP with multiple conditions
22. Identify rows of overlapping records
23. If cell contains text from list
24. INDEX MATCH – multiple results
25. Lookup and return multiple values concatenated into one cell
26. Lookup multiple values across columns and return a single value
27. Lookup with any number of criteria
28. Partial match for multiple strings – AND logic
29. Rearrange values using formulas
30. Search for a sequence of values
31. Search for a text string in a data set and return multiple records
33. VLOOKUP – Return multiple unique distinct values
34. Working with classic ciphers in Excel
35. 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. Extract a unique distinct list from multiple non adjacent cell ranges
3. Extract a unique distinct list sorted from A to Z
4. Extract unique distinct values from a multi-column cell range
5. Extract unique distinct values in an Excel Table filtered list
6. VLOOKUP – Return multiple unique distinct values
UNIQUE function
1. 5 easy ways to extract Unique Distinct Values
2. Array Manipulation Functions
3. Compare two columns in different worksheets
5. Count unique distinct records
6. Count unique distinct values
7. Create dependent drop down lists containing unique distinct values
8. Engineering functions – A to C
9. Extract a list of duplicates from a column
10. Extract a unique distinct list from multiple non adjacent cell ranges
11. Extract a unique distinct list sorted from A to Z
12. Extract duplicates from a multi-column cell range
13. Extract unique distinct values from a multi-column cell range
14. Extract unique distinct values in an Excel Table filtered list
15. Filter strings containing a given substring in a cell range
16. Filter unique distinct records
17. How to compare two data sets
18. How to create date ranges in Excel
19. How to extract numbers from a cell value
20. How to list unique distinct values sorted by frequency
21. How to return a value if lookup value is in a range
22. How to use the UNIQUE function
23. Lookup and return multiple values concatenated into one cell
24. Merge cell ranges into one list
25. Search for a text string in a data set and return multiple records
26. Sort rows based on frequency and criteria
29. Unique distinct records sorted based on count or frequency
30. Use a drop down list to search and return multiple values
31. VLOOKUP – Return multiple unique distinct values
32. Working with classic ciphers in Excel
33. 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
UPPER function
1. Count cells containing text from list
3. How to use the UPPER function
4. Working with classic ciphers in Excel
User Defined Function
1. Extract unique distinct values in an Excel Table filtered list
2. Search for a file in folder and subfolders – UDF
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. Create a Print button – macro
7. Create links to all sheets in a workbook programmatically
8. Create new worksheets programmatically based on values in a cell range [VBA]
9. Customize the ribbon and how to add your macros
10. Excel calendar
11. Excel template: Getting Things Done [VBA]
13. Extract unique distinct values in an Excel Table filtered list
15. How to copy non contiguous cell ranges
16. How to create an interactive Excel chart
17. How to save specific multiple worksheets to a pdf file programmatically
19. How to use the LIKE OPERATOR
21. List all hyperlinks in worksheet programmatically
22. Run a Macro from a Drop Down list [VBA]
24. Search all workbooks in a folder
25. Search for a file in folder and subfolders – UDF
26. Show / hide a picture using a button
27. Split data across multiple sheets – VBA
28. Working with ARRAY VARIABLES (VBA)
29. Working with COMBO BOXES [Form Controls]
30. Working with comments – VBA
31. Working with Excel tables programmatically
33. Working with LIST BOXES (Form Controls)
34. 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
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
VSTACK function
1. 5 easy ways to VLOOKUP and return multiple values
2. Array Manipulation Functions
3. Calculate machine utilization
4. Compare tables: Filter records occurring only in one table
5. Compare two columns and extract differences
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. How to create date ranges in Excel
13. Merge cell ranges into one list
14. Search for a text string in a data set and return multiple records
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. Date and Time Functions – N to Z
4. How to track sector performance in the stock market – Excel template
5. 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
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. 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
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. Count cells containing text from list
3. Count unique distinct values
5. Date and Time Functions – A to M
6. Date and Time Functions – N to Z
8. Extract a list of duplicates from a column
9. Filter unique distinct records
10. Follow stock market trends – Moving Average
11. How to create date ranges in Excel
12. How to track sector performance in the stock market – Excel template
13. How to use the YEAR function
15. VLOOKUP – Return multiple unique distinct values
17. 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