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. Find numbers closest to sum
3. Find the most recent date that meets a particular condition
4. How to create date ranges in Excel
5. How to use the ABS function
6. How to use the asterisk character
7. Identify numbers in sum using Excel solver
8. 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 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. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
3. 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. How to create date ranges in Excel
6. How to do tiered calculations in one formula
7. How to extract numbers from a cell value
8. How to perform a two-dimensional lookup
9. If cell contains text from list
10. INDEX MATCH – multiple results
11. Lookup a date in date ranges and get the corresponding value
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. How to use the BIN2DEC function
2. Working with classic ciphers in Excel
BIN2HEX function
1. How to use the BIN2HEX function
BIN2OCT function
1. How to use the BIN2OCT function
BINOM.DIST function
2. How to use the BINOM.DIST function
BINOM.INV function
1. How to use the BINOM.INV function
BINOMDIST function
BITAND function
1. How to use the BITAND function
BITLSHIFT function
1. How to use the BITLSHIFT function
BITOR function
1. How to use the BITOR function
BITRSHIFT function
1. How to use the BITRSHIFT function
BITXOR function
1. How to use the BITXOR function
2. Working with classic ciphers in Excel
Blank cells
1. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
Box and whisker chart
Bubble chart
BYCOL function
1. How to use the BYCOL function
BYROW function
1. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Count cells containing text from list
5. Filter unique distinct records case sensitive
7. How to do tiered calculations in one formula
8. How to use the BYROW function
9. Rearrange values using formulas
10. 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
2. How to use the CHAR function
3. Search for a text string in a data set and return multiple records
4. Working with classic ciphers in Excel
Chart basics
1. Excel charts tips and tricks
Chart elements
Charts
1. Advanced Excel Chart Techniques
3. Excel charts tips and tricks
4. Highlight a data series in a chart
6. How to add horizontal line to chart
7. How to animate an Excel chart
8. How to create an interactive Excel chart
9. How to create charts in Excel
10. 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. How to use the CHOOSECOLS function
CHOOSEROWS function
1. How to use the CHOOSEROWS function
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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare tables: Filter records occurring only in one table
5. Compare two columns in different worksheets
6. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
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 return a value if lookup value is in a range
26. How to use Pivot Tables – Excel’s most powerful feature and also least known
27. How to use the COLUMN function
29. INDEX MATCH – multiple results
30. Lookup with any number of criteria
31. Match two criteria and return multiple records
32. Merge cell ranges into one list
33. Merge tables based on a condition
34. Partial match for multiple strings – AND logic
35. Search for a text string in a data set and return multiple records
36. Sort a column alphabetically
37. Split data across multiple sheets – VBA
39. Unique distinct records sorted based on count or frequency
40. VLOOKUP – Return multiple unique distinct values
41. Wildcard lookups and include or exclude criteria
42. Working with COMBO BOXES [Form Controls]
43. Working with Relational Tables in Excel
44. Working with unique values
COLUMNS function
1. 5 easy ways to VLOOKUP and return multiple values
2. Count cells containing text from list
4. Extract all rows from a range that meet criteria in one column
5. Filter unique distinct records
6. Filter unique distinct records case sensitive
7. How to compare two data sets
8. How to copy non contiguous cell ranges
9. How to create date ranges in Excel
10. How to return a value if lookup value is in a range
11. How to use the COLUMNS function
12. How to use the MAKEARRAY function
13. How to use VLOOKUP/XLOOKUP with multiple conditions
14. Identify rows of overlapping records
15. If cell contains text from list
16. Match two criteria and return multiple records
17. Populate drop down list with unique distinct values sorted from A to Z
18. Rearrange values using formulas
19. Search for a text string in a data set and return multiple records
20. Sort a column alphabetically
21. Split data across multiple sheets – VBA
22. Use a drop down list to search and return multiple values
23. 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. Complex Calculations: A Guide to Excel’s IM Functions
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. How to use the CONVERT function
CORREL function
1. How to use the CORREL function
COS function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
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
5. Extract specific word based on position in cell value
7. How to create date ranges in Excel
8. How to use the COUNT function
9. If cell contains text from list
10. 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
10. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
12. Count unique distinct records
13. Count unique distinct values
14. Create dependent drop down lists containing unique distinct values
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 from 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 use the COUNTIF function
38. How to use VLOOKUP/XLOOKUP with multiple conditions
39. If cell contains text from list
40. INDEX MATCH – multiple results
41. Lookup with any number of criteria
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. Plot date ranges in a calendar
47. Populate drop down list with unique distinct values sorted from A to Z
48. Repeat values across cells
49. Rotating unique groups with no repeat
50. Sort a column alphabetically
52. Team Generator
54. Use a drop down list to search and return multiple values
55. VLOOKUP – Return multiple unique distinct values
56. Working with COMBO BOXES [Form Controls]
57. 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 from 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. Split data across multiple sheets – VBA
27. Unique distinct records sorted based on count or frequency
28. Working with Conditional Formatting formulas
29. Working with overlapping date ranges
30. 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
3. Filter unique distinct records
4. Get date ranges from a schedule
5. How to create date ranges in Excel
6. How to track sector performance in the stock market – Excel template
7. How to use the DATE function
9. Plot date ranges in a calendar
10. Populate drop down list with unique distinct values sorted from A to Z
11. Split data across multiple sheets – VBA
13. Yet another Excel Calendar
DATEDIF function
1. 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. Get date ranges from a schedule
6. How to create date ranges in Excel
7. Identify rows of overlapping records
8. Lookup a date in date ranges and get the corresponding value
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. Get date ranges from a schedule
6. How to create date ranges in Excel
7. Lookup a date in date ranges and get the corresponding value
DATEVALUE function
1. How to use the DATEVALUE function
2. Lookup a date in date ranges and get the corresponding value
DAVERAGE function
1. How to use the DAVERAGE function
DAY function
1. Automate net asset value (NAV) calculation on your stock portfolio
2. Follow stock market trends – Moving Average
3. Get date ranges from a schedule
4. How to track sector performance in the stock market – Excel template
5. How to use the DAY function
7. Populate drop down list with unique distinct values sorted from A to Z
DAYS function
1. How to use the DAYS function
DB function
DCOUNT function
1. How to use the DCOUNT function
DDB function
DEC2BIN function
1. Engineering functions – D to IMC
2. How to use the DEC2BIN function
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
2. How to use the DEC2OCT function
DECIMAL function
1. How to use the DECIMAL function
DEGREES function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
3. 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
1. How to use the DGET function
Dialog boxes
DMAX function
1. How to use the DMAX function
DMIN function
1. How to use the DMIN function
DO LOOP statement
Doughnut chart
DOUNTA function
1. How to use the DCOUNTA function
DPRODUCT function
1. How to use the 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. Calculate machine utilization
2. Filter unique distinct records case sensitive
3. How to create date ranges in Excel
4. How to use the DROP function
5. Merge cell ranges into one list
6. Search for a text string in a data set and return multiple records
7. Working with classic ciphers in Excel
DSTDEV function
1. How to use the DSTDEV function
DSTDEVP function
1. How to use the 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
1. How to use the DVARP function
EDATE function
2. How to use the EDATE function
EFFECT function
ENCODEURL function
1. How to use the ENCODEURL function
EOMONTH function
1. How to use the EOMONTH function
ERROR.TYPE function
1. How to use the ERROR.TYPE function
Evaluate method
EVEN function
1. How to use the EVEN function
EXACT function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Count unique distinct values
4. How to compare two data sets
5. How to use the EXACT function
6. If cell contains text from list
7. INDEX MATCH – multiple results
Excel Basics
Excel table
EXP function
1. How to use the EXP function
EXPAND function
1. Filter unique distinct records case sensitive
2. How to use the EXPAND function
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. Automate net asset value (NAV) calculation on your stock portfolio
3. Extract a list of duplicates from a column
4. Get date ranges from a schedule
5. How to generate a round-robin tournament
6. How to use the asterisk character
7. How to use VLOOKUP/XLOOKUP with multiple conditions
8. If cell contains text from list
9. INDEX MATCH – multiple results
10. Match two criteria and return multiple records
11. Merge tables based on a condition
12. Plot date ranges in a calendar
13. Populate drop down list with unique distinct values sorted from A to Z
14. Rearrange values using formulas
15. Repeat values across cells
16. Search for a text string in a data set and return multiple records
17. Unique distinct records sorted based on count or frequency
18. VLOOKUP – Return multiple unique distinct values
19. Working with classic ciphers in Excel
20. Working with Relational Tables in Excel
21. Working with unique values
FDIST function
Features
1. 5 easy ways to extract Unique Distinct Values
2. Advanced Techniques for Conditional Formatting
3. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
4. Create a dynamic named range
5. Create dependent drop down lists containing unique distinct values
7. Extract unique distinct values from an Excel Table filtered list
8. How to compare two data sets
9. How to solve simultaneous linear equations in Excel
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
FILTER function
1. 5 easy ways to extract Unique Distinct Values
2. 5 easy ways to VLOOKUP and return multiple values
3. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare tables: Filter records occurring only in one table
5. Compare two columns and extract differences
6. Compare two columns in different worksheets
8. Count unique distinct records
9. Count unique distinct values
10. Create dependent drop down lists containing unique distinct values
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 duplicates from a multi-column cell range
17. Extract records between two dates
18. Extract unique distinct values from a multi-column cell range
19. Extract unique distinct values from an Excel Table filtered list
20. Filter duplicate values based on criteria
21. Filter unique distinct records
22. Filter unique distinct records case sensitive
23. Find all sequences of consecutive dates
24. Find and return the highest number and corresponding date based on a condition
26. Find the most recent date that meets a particular condition
27. Get date ranges from a schedule
28. How to compare two data sets
29. How to create date ranges in Excel
30. How to extract numbers from a cell value
31. How to list unique distinct values sorted by frequency
32. How to return a value if lookup value is in a range
33. How to use the FILTER function
34. How to use VLOOKUP/XLOOKUP with multiple conditions
35. Identify rows of overlapping records
36. If cell contains text from list
37. INDEX MATCH – multiple results
38. Lookup a date in date ranges and get the corresponding value
39. Lookup and return multiple values concatenated into one cell
40. Lookup multiple values across columns and return a single value
41. Lookup with any number of criteria
42. Match two criteria and return multiple records
43. Merge cell ranges into one list
45. Partial match and return multiple adjacent values
46. Partial match for multiple strings – AND logic
47. Search for a sequence of values
48. Search for a text string in a data set and return multiple records
49. Sort a column alphabetically
51. VLOOKUP – Return multiple unique distinct values
52. Wildcard lookups and include or exclude criteria
54. Working with overlapping date ranges
55. Working with Relational Tables in Excel
56. 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. How to use the FIND function
3. INDEX MATCH – multiple results
4. Lookup a date in date ranges and get the corresponding value
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. Finding the shortest path – A * pathfinding
2. 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
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 do tiered calculations in one formula
2. 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
2. How to use the HEX2BIN function
HEX2DEC function
1. Engineering functions – D to IMC
2. How to use the HEX2DEC function
3. Working with classic ciphers in Excel
HEX2OCT function
1. Engineering functions – D to IMC
Highlight
1. Highlight a data series in a chart
Highlight Cells Rules
1. Conditional Formatting Basics
Highlight duplicates
Histogram chart
HLOOKUP function
1. How to use the HLOOKUP function
HOUR function
1. How to use the HOUR function
HSTACK function
1. Calculate machine utilization
3. Filter unique distinct records
5. Get date ranges from a schedule
6. How to create date ranges in Excel
7. How to use the HSTACK function
8. Merge cell ranges into one list
10. Working with classic ciphers in Excel
HYPERLINK function
1. How to perform a two-dimensional lookup
2. How to use the HYPERLINK function
3. INDEX MATCH – multiple results
Hyperlinks
1. 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. Automate net asset value (NAV) calculation on your stock portfolio
6. Calculate machine utilization
7. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
8. Compare tables: Filter records occurring only in one table
9. Compare the performance of your stock portfolio to S&P 500 using Excel
10. Compare two columns and extract differences
11. Compare two columns in different worksheets
12. Count cells containing text from list
13. Count unique distinct records
14. Count unique distinct values
15. Create dependent drop down lists containing unique distinct values
18. Excel calendar
20. Extract a list of duplicates from a column
21. Extract a unique distinct list from multiple non adjacent cell ranges
22. Extract a unique distinct list sorted from A to Z
23. Extract all rows from a range that meet criteria in one column
24. Extract dates from overlapping date ranges
25. Extract duplicates from a multi-column cell range
26. Extract records between two dates
27. Extract specific word based on position in cell value
28. Extract unique distinct values from a multi-column cell range
29. Extract unique distinct values from an Excel Table filtered list
30. Filter duplicate values based on criteria
31. Filter unique distinct records
32. Find all sequences of consecutive dates
33. Find and return the highest number and corresponding date based on a condition
35. Find numbers closest to sum
36. Find the most recent date that meets a particular condition
37. Follow stock market trends – Moving Average
38. Fuzzy VLOOKUP
39. Get date ranges from a schedule
40. Highlight unique values in a filtered Excel table
41. How to compare two data sets
42. How to create date ranges in Excel
43. How to extract numbers from a cell value
44. How to generate a round-robin tournament
45. How to highlight duplicate values
46. How to list unique distinct values sorted by frequency
47. How to perform a two-dimensional lookup
48. How to return a value if lookup value is in a range
49. How to solve simultaneous linear equations in Excel
50. How to track sector performance in the stock market – Excel template
52. How to use the IF function
53. How to use VLOOKUP/XLOOKUP with multiple conditions
54. Identify rows of overlapping records
55. If cell contains text from list
56. INDEX MATCH – multiple results
57. Lookup a date in date ranges and get the corresponding value
58. Lookup and return multiple values concatenated into one cell
59. Lookup multiple values across columns and return a single value
60. Lookup with any number of criteria
61. Match two criteria and return multiple records
62. Merge cell ranges into one list
63. Merge tables based on a condition
65. Partial match and return multiple adjacent values
66. Partial match for multiple strings – AND logic
67. Plot date ranges in a calendar
68. Populate drop down list with unique distinct values sorted from A to Z
69. Rearrange values using formulas
70. Repeat values across cells
71. Rotating unique groups with no repeat
72. Search for a sequence of values
73. Search for a text string in a data set and return multiple records
74. Sort a column alphabetically
75. Split data across multiple sheets – VBA
78. Unique distinct records sorted based on count or frequency
79. Use a drop down list to search and return multiple values
80. VLOOKUP – Return multiple unique distinct values
81. Wildcard lookups and include or exclude criteria
82. Working with classic ciphers in Excel
83. Working with COMBO BOXES [Form Controls]
85. Working with overlapping date ranges
86. Working with Relational Tables in Excel
87. Working with running totals
88. 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
12. Excel calendar
13. Extract a list of duplicates from a column
14. Extract a unique distinct list from multiple non adjacent cell ranges
15. Extract a unique distinct list sorted from A to Z
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 from 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. Follow stock market trends – Moving Average
26. Fuzzy VLOOKUP
27. Get date ranges from a schedule
28. How to compare two data sets
29. How to generate a round-robin tournament
30. How to perform a two-dimensional lookup
32. How to use the IFERROR function
34. Identify rows of overlapping records
35. If cell contains text from list
36. Lookup and return multiple values concatenated into one cell
37. Lookup with any number of criteria
38. Merge cell ranges into one list
39. Plot date ranges in a calendar
40. Search for a text string in a data set and return multiple records
41. Split data across multiple sheets – VBA
43. Team Generator
45. Use a drop down list to search and return multiple values
46. VLOOKUP – Return multiple unique distinct values
47. Wildcard lookups and include or exclude criteria
48. Working with classic ciphers in Excel
49. Working with COMBO BOXES [Form Controls]
50. Working with overlapping date ranges
51. Working with Relational Tables in Excel
52. Working with unique values
IFNA function
1. Filter unique distinct records
2. Get date ranges from a schedule
3. How to use the IFNA function
4. Working with Relational Tables in Excel
IFS function
1. How to use the IFS function
IMABS function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMAGE function
1. How to use the IMAGE function
IMAGINARY function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMARGUMENT function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCONJUGATE function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCOS function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCOSH function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCOT function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCSC function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMCSCH function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMDIV function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMEXP function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMLN
IMLOG10 function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMLOG2 function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMPOWER function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMPRODUCT function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMREAL function
1. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
IMSEC function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSECH function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSIN function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSINH function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSQRT function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSUB function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMSUM function
1. Complex Calculations: A Guide to Excel’s IM Functions
IMTAN function
1. Complex Calculations: A Guide to Excel’s IM Functions
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. Automate net asset value (NAV) calculation on your stock portfolio
5. Calculate machine utilization
6. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
7. Compare tables: Filter records occurring only in one table
8. Compare the performance of your stock portfolio to S&P 500 using Excel
9. Compare two columns and extract differences
10. Compare two columns in different worksheets
11. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
13. Count cells containing text from list
14. Create dependent drop down lists containing unique distinct values
16. Excel calendar
18. Extract a list of duplicates from a column
19. Extract a unique distinct list from multiple non adjacent cell ranges
20. Extract a unique distinct list sorted from A to Z
21. Extract all rows from a range that meet criteria in one column
22. Extract duplicates from a multi-column cell range
23. Extract records between two dates
24. Extract specific word based on position in cell value
25. Extract unique distinct values from a multi-column cell range
26. Extract unique distinct values from an Excel Table filtered list
27. Filter duplicate values based on criteria
28. Filter unique distinct records
29. Filter unique distinct records case sensitive
30. Find and return the highest number and corresponding date based on a condition
32. Find numbers closest to sum
33. Find the most recent date that meets a particular condition
34. Follow stock market trends – Moving Average
35. Fuzzy VLOOKUP
36. Get date ranges from a schedule
37. Highlight a data series in a chart
38. How to animate an Excel chart
39. How to compare two data sets
40. How to copy non contiguous cell ranges
41. How to create date ranges in Excel
42. How to extract numbers from a cell value
43. How to generate a round-robin tournament
44. How to highlight differences and common values in lists
45. How to list unique distinct values sorted by frequency
46. How to perform a two-dimensional lookup
47. How to return a value if lookup value is in a range
50. How to use Pivot Tables – Excel’s most powerful feature and also least known
51. How to use the INDEX function
52. How to use the MAKEARRAY function
54. How to use VLOOKUP/XLOOKUP with multiple conditions
55. If cell contains text from list
56. INDEX MATCH – multiple results
57. Lookup a date in date ranges and get the corresponding value
58. Lookup multiple values across columns and return a single value
59. Lookup with any number of criteria
60. Match two criteria and return multiple records
61. Merge cell ranges into one list
62. Merge tables based on a condition
63. Partial match and return multiple adjacent values
64. Partial match for multiple strings – AND logic
65. Plot date ranges in a calendar
66. Populate drop down list with unique distinct values sorted from A to Z
67. Rearrange values using formulas
68. Repeat values across cells
69. Rotating unique groups with no repeat
70. Search for a text string in a data set and return multiple records
71. Show / hide a picture using a button
72. Sort a column alphabetically
73. Split data across multiple sheets – VBA
75. Team Generator
77. Unique distinct records sorted based on count or frequency
78. Use a drop down list to search and return multiple values
80. VLOOKUP – Return multiple unique distinct values
81. Wildcard lookups and include or exclude criteria
82. Working with classic ciphers in Excel
83. Working with COMBO BOXES [Form Controls]
84. Working with overlapping date ranges
85. Working with Relational Tables in Excel
86. Working with unique values
INDIRECT function
1. Add values to a regular drop-down list programmatically
2. Advanced Techniques for Conditional Formatting
4. Get date ranges from a schedule
5. Highlight a data series in a chart
6. Highlight unique values in a filtered Excel table
8. How to generate a round-robin tournament
11. How to use the INDIRECT function
12. Plot date ranges in a calendar
13. Prevent duplicate records in a worksheet
14. Working with overlapping date ranges
15. Working with Relational Tables in Excel
INFO function
1. How to use the INFO function
INT function
1. Calculate machine utilization
3. Find numbers closest to sum
5. How to generate a round-robin tournament
7. How to use the INT function
INT function
1. Calculate machine utilization
3. Find numbers closest to sum
5. How to generate a round-robin tournament
7. 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. How to extract numbers from a cell value
7. How to use the ISNUMBER function
8. If cell contains text from list
9. INDEX MATCH – multiple results
10. Match two criteria and return multiple records
11. Partial match and return multiple adjacent values
12. Partial match for multiple strings – AND logic
13. Search for a sequence of values
14. Search for a text string in a data set and return multiple records
15. VLOOKUP – Return multiple unique distinct values
16. Wildcard lookups and include or exclude criteria
17. 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
5. Extract specific word based on position in cell value
6. Filter unique distinct records case sensitive
8. How to create date ranges in Excel
9. How to do tiered calculations in one formula
10. How to use the LAMBDA function
11. How to use the MAKEARRAY function
12. Merge cell ranges into one list
13. Rearrange values using formulas
14. Search for a text string in a data set and return multiple records
15. Working with classic ciphers in Excel
LARGE function
2. Extract unique distinct values from a multi-column cell range
3. Find the most recent date that meets a particular condition
4. Follow stock market trends – Moving Average
5. How to generate a round-robin tournament
6. How to use the LARGE function
8. Rotating unique groups with no repeat
9. Sort a column alphabetically
10. Team Generator
11. 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. Extract duplicates from a multi-column cell range
3. Extract specific word based on position in cell value
4. Extract unique distinct values from a multi-column cell range
5. Follow stock market trends – Moving Average
7. How to use the LEFT function
8. Lookup a date in date ranges and get the corresponding value
9. Lookup and return multiple values concatenated into one cell
10. Search for a text string in a data set and return multiple records
11. VLOOKUP – Return multiple unique distinct values
12. Working with classic ciphers in Excel
LEN function
1. 5 easy ways to VLOOKUP and return multiple values
2. A Comprehensive Guide to Splitting Text in Excel
3. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Count cells containing text from list
5. Extract a unique distinct list sorted from A to Z
6. Extract duplicates from a multi-column cell range
7. Extract unique distinct values from a multi-column cell range
9. How to extract numbers from a cell value
10. How to use the LEN function
11. INDEX MATCH – multiple results
12. Lookup a date in date ranges and get the corresponding value
13. Lookup and return multiple values concatenated into one cell
14. Partial match and return multiple adjacent values
15. Search for a text string in a data set and return multiple records
16. Sort a column alphabetically
17. VLOOKUP – Return multiple unique distinct values
18. 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. Calculate machine utilization
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare two columns and extract differences
10. Extract a list of duplicates from a column
11. Extract dates from overlapping date ranges
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 from an Excel Table filtered list
15. Filter duplicate values based on criteria
16. Filter unique distinct records case sensitive
17. Find all sequences of consecutive dates
19. Find numbers closest to sum
20. Fuzzy VLOOKUP
21. Get date ranges from a schedule
22. How to create date ranges in Excel
23. How to do tiered calculations in one formula
24. How to extract numbers from a cell value
25. How to list unique distinct values sorted by frequency
26. How to return a value if lookup value is in a range
27. How to track sector performance in the stock market – Excel template
28. How to use the LET function
29. How to use VLOOKUP/XLOOKUP with multiple conditions
30. If cell contains text from list
31. Match two criteria and return multiple records
32. Merge cell ranges into one list
33. Repeat values across cells
34. Search for a text string in a data set and return multiple records
35. Sort a column alphabetically
37. Team Generator
38. Unique distinct records sorted based on count or frequency
39. VLOOKUP – Return multiple unique distinct values
40. Wildcard lookups and include or exclude criteria
41. Working with classic ciphers in Excel
42. Working with overlapping date ranges
43. Working with unique values
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. Comparing Excel Sorting Techniques: Formulas, Tools, 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. How to return a value if lookup value is in a range
6. How to use the LOOKUP function
7. How to use VLOOKUP/XLOOKUP with multiple conditions
8. INDEX MATCH – multiple results
9. Lookup a date in date ranges and get the corresponding value
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 every time a workbook opens or closes
16. Run a Macro from a Drop Down list [VBA]
18. Show / hide a picture using a button
19. Split data across multiple sheets – VBA
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
10. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
12. Count cells containing text from list
13. Count unique distinct values
14. Create dependent drop down lists containing unique distinct values
17. 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 from 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. Get date ranges from a schedule
35. Highlight unique values in a filtered Excel table
36. How to animate an Excel chart
37. How to compare two data sets
38. How to generate a round-robin tournament
39. How to highlight differences and common values in lists
40. How to list unique distinct values sorted by frequency
41. How to perform a two-dimensional lookup
42. How to return a value if lookup value is in a range
43. How to use Pivot Tables – Excel’s most powerful feature and also least known
44. How to use the MATCH function
45. How to use VLOOKUP/XLOOKUP with multiple conditions
46. If cell contains text from list
47. INDEX MATCH – multiple results
48. Lookup a date in date ranges and get the corresponding value
49. Lookup and return multiple values concatenated into one cell
50. Lookup multiple values across columns and return a single value
51. Lookup with any number of criteria
52. Match two criteria and return multiple records
53. Merge cell ranges into one list
54. Merge tables based on a condition
56. Partial match and return multiple adjacent values
57. Partial match for multiple strings – AND logic
58. Plot date ranges in a calendar
59. Populate drop down list with unique distinct values sorted from A to Z
60. Repeat values across cells
61. Rotating unique groups with no repeat
62. Search for a sequence of values
63. Search for a text string in a data set and return multiple records
64. Show / hide a picture using a button
65. Sort a column alphabetically
66. Split data across multiple sheets – VBA
68. Team Generator
70. Unique distinct records sorted based on count or frequency
71. Use a drop down list to search and return multiple values
73. VLOOKUP – Return multiple unique distinct values
74. Wildcard lookups and include or exclude criteria
75. Working with classic ciphers in Excel
76. Working with COMBO BOXES [Form Controls]
77. Working with overlapping date ranges
78. Working with Relational Tables in Excel
79. 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
12. How to use the MAX function
13. Identify rows of overlapping records
14. Repeat values across cells
16. Working with overlapping date ranges
17. 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. Extract specific word based on position in cell value
6. How to extract numbers from a cell value
7. How to return a value if lookup value is in a range
8. How to use the MID function
9. INDEX MATCH – multiple results
10. Search for a text string in a data set and return multiple records
11. 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 use the MIN function
18. How to use VLOOKUP/XLOOKUP with multiple conditions
19. Identify rows of overlapping records
20. INDEX MATCH – multiple results
21. Lookup with any number of criteria
22. Partial match and return multiple adjacent values
23. Repeat values across cells
24. Search for a text string in a data set and return multiple records
25. Sort a column alphabetically
27. VLOOKUP – Return multiple unique distinct values
28. Working with overlapping date ranges
29. 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. 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 numbers from a cell value
10. How to solve simultaneous linear equations in Excel
11. How to use the MMULT function
12. Identify rows of overlapping records
13. INDEX MATCH – multiple results
14. Lookup with any number of criteria
15. Match two criteria and return multiple records
16. Partial match and return multiple adjacent values
17. Search for a text string in a data set and return multiple records
18. VLOOKUP – Return multiple unique distinct values
19. Wildcard lookups and include or exclude criteria
20. Working with overlapping date ranges
21. Working with unique values
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
5. Filter unique distinct records
6. Follow stock market trends – Moving Average
7. Get date ranges from a schedule
8. How to create date ranges in Excel
9. How to track sector performance in the stock market – Excel template
10. How to use the MONTH function
12. Plot date ranges in a calendar
13. 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
2. Lookup with any number of criteria
Named range
1. Create a dynamic named range
NETWORKDAYS function
1. How to use the NETWORKDAYS function
NETWORKDAYS.INTL function
1. 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. How to use the NOW function
NPER function
OFFSET function
1. Add values to a regular drop-down list programmatically
2. Calculate machine utilization
3. Create dependent drop down lists containing unique distinct values
4. Extract dates from overlapping date ranges
5. Extract unique distinct values from an Excel Table filtered list
7. Follow stock market trends – Moving Average
8. Highlight unique values in a filtered Excel table
9. How to generate a round-robin tournament
11. How to use the OFFSET function
12. 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. Complex Calculations: A Guide to Excel’s IM Functions
2. 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. Complex Calculations: A Guide to Excel’s IM Functions
2. How to use the RADIANS function
RAND function
1. How to use the RAND function
RANDARRAY function
1. How to use the RANDARRAY function
3. 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. How to create date ranges in Excel
2. How to use the REDUCE function
3. Merge cell ranges into one list
4. Rearrange values using formulas
5. Search for a text string in a data set and return multiple records
6. Working with classic ciphers in Excel
Regular expressions
1. How to use the LIKE OPERATOR
Relational tables
REPLACE function
1. How to use the REPLACE function
REPT function
1. A Comprehensive Guide to Splitting Text in Excel
2. Extract specific word based on position in cell value
3. How to use the REPT function
4. Search for a text string in a data set and return multiple records
5. Working with classic ciphers in Excel
RIGHT function
1. 5 easy ways to VLOOKUP and return multiple values
2. Extract specific word based on position in cell value
4. How to use the RIGHT function
5. Lookup a date in date ranges and get the corresponding value
6. Split data across multiple sheets – VBA
7. VLOOKUP – Return multiple unique distinct values
8. Working with classic ciphers in Excel
ROUND function
2. Complex Calculations: A Guide to Excel’s IM Functions
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. How to use the ROUNDUP function
3. 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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare two columns and extract differences
5. Compare two columns in different worksheets
6. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
7. Complex Calculations: A Guide to Excel’s IM Functions
8. Count unique distinct records
9. Count unique distinct values
10. Create dependent drop down lists containing unique distinct values
13. Engineering functions – D to IMC
14. Excel calendar
15. Extract a list of duplicates from a column
16. Extract all rows from a range that meet criteria in one column
17. Extract dates from overlapping date ranges
18. Extract specific word based on position in cell value
19. Extract unique distinct values from an Excel Table filtered list
20. Filter duplicate values based on criteria
21. Filter unique distinct records case sensitive
22. Find all sequences of consecutive dates
24. Find numbers closest to sum
25. Find the most recent date that meets a particular condition
26. Follow stock market trends – Moving Average
27. Get date ranges from a schedule
28. How to compare two data sets
29. How to copy non contiguous cell ranges
30. How to create date ranges in Excel
31. How to extract numbers from a cell value
32. How to generate a round-robin tournament
33. How to return a value if lookup value is in a range
35. How to use the MAKEARRAY function
36. How to use the ROWS function
37. How to use VLOOKUP/XLOOKUP with multiple conditions
38. INDEX MATCH – multiple results
39. Match two criteria and return multiple records
40. Merge cell ranges into one list
41. Partial match and return multiple adjacent values
42. Partial match for multiple strings – AND logic
43. Populate drop down list with unique distinct values sorted from A to Z
44. Rearrange values using formulas
45. Repeat values across cells
46. Search for a sequence of values
47. Search for a text string in a data set and return multiple records
48. Sort a column alphabetically
49. Split data across multiple sheets – VBA
50. Team Generator
51. VLOOKUP – Return multiple unique distinct values
53. Working with overlapping date ranges
54. Working with Relational Tables in Excel
55. 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 unique distinct records
9. How to extract numbers from a cell value
10. How to use the SEARCH function
11. If cell contains text from list
12. INDEX MATCH – multiple results
13. Lookup and return multiple values concatenated into one cell
14. Match two criteria and return multiple records
15. Partial match and return multiple adjacent values
16. Partial match for multiple strings – AND logic
17. Search for a text string in a data set and return multiple records
18. VLOOKUP – Return multiple unique distinct values
19. Wildcard lookups and include or exclude criteria
20. Working with classic ciphers in Excel
SEC function
1. How to use the SEC function
SECOND function
1. 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. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
4. Compare two columns and extract differences
5. Create a dynamic named range
6. Extract dates from overlapping date ranges
7. Extract unique distinct values from an Excel Table filtered list
9. Find numbers closest to sum
10. Fuzzy VLOOKUP
11. Get date ranges from a schedule
12. How to copy non contiguous cell ranges
13. How to create date ranges in Excel
14. How to extract numbers from a cell value
15. How to use the SEQUENCE function
16. How to use VLOOKUP/XLOOKUP with multiple conditions
17. Rearrange values using formulas
18. Repeat values across cells
19. Search for a text string in a data set and return multiple records
20. Sort a column alphabetically
22. Team Generator
23. Working with classic ciphers in Excel
24. 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. Complex Calculations: A Guide to Excel’s IM Functions
2. Engineering functions – D to IMC
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. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
9. Count cells containing text from list
10. Create dependent drop down lists containing unique distinct values
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 from 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. Fuzzy VLOOKUP
28. Get date ranges from a schedule
29. How to compare two data sets
30. How to create date ranges in Excel
31. How to extract numbers from a cell value
32. How to generate a round-robin tournament
33. How to perform a two-dimensional lookup
34. How to return a value if lookup value is in a range
36. How to use the SMALL function
37. How to use VLOOKUP/XLOOKUP with multiple conditions
38. Identify rows of overlapping records
39. If cell contains text from list
40. INDEX MATCH – multiple results
41. Lookup a date in date ranges and get the corresponding value
42. Lookup multiple values across columns and return a single value
43. Lookup with any number of criteria
44. Match two criteria and return multiple records
45. Merge cell ranges into one list
46. Partial match and return multiple adjacent values
47. Partial match for multiple strings – AND logic
48. Plot date ranges in a calendar
49. Populate drop down list with unique distinct values sorted from A to Z
50. Repeat values across cells
51. Search for a sequence of values
52. Search for a text string in a data set and return multiple records
53. Sort a column alphabetically
54. Split data across multiple sheets – VBA
56. Use a drop down list to search and return multiple values
57. VLOOKUP – Return multiple unique distinct values
58. Wildcard lookups and include or exclude criteria
59. Working with COMBO BOXES [Form Controls]
61. Working with overlapping date ranges
62. Working with Relational Tables in Excel
63. 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
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
9. Find and return the highest number and corresponding date based on a condition
10. Fuzzy VLOOKUP
11. How to create date ranges in Excel
12. How to extract numbers from a cell value
13. How to use the SORT function
14. Sort a column alphabetically
15. Working with classic ciphers in Excel
17. Working with unique values
Sort values
1. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
2. Sort a column alphabetically
SORTBY function
1. Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
3. Extract a unique distinct list sorted from A to Z
4. How to list unique distinct values sorted by frequency
5. How to use the SORTBY function
6. INDEX MATCH – multiple results
7. Sort a column alphabetically
9. Unique distinct records sorted based on count or frequency
10. 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
1. Follow stock market trends – Moving Average
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. Extract specific word based on position in cell value
5. How to use the SUBSTITUTE function
6. Partial match and return multiple adjacent values
7. Search for a text string in a data set and return multiple records
8. Working with classic ciphers in Excel
Substitute Replace
SUBTOTAL function
2. Extract unique distinct values from 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
10. Extract a list of duplicates from a column
11. Extract a unique distinct list sorted from A to Z
12. Extract unique distinct values from an Excel Table filtered list
13. Filter unique distinct records case sensitive
14. Get date ranges from a schedule
15. Highlight unique values in a filtered Excel table
16. How to do tiered calculations in one formula
18. How to use the asterisk character
19. How to use the SUM function
20. Identify numbers in sum using Excel solver
21. If cell contains text from list
22. Lookup with any number of criteria
23. Repeat values across cells
24. Rotating unique groups with no repeat
25. Search for a text string in a data set and return multiple records
26. Sort a column alphabetically
28. Team Generator
29. Working with classic ciphers in Excel
30. Working with overlapping date ranges
31. Working with Relational Tables in Excel
32. 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. Excel calendar
11. Filter unique distinct records
12. Find the most recent date that meets a particular condition
13. How to create date ranges in Excel
14. How to do tiered calculations in one formula
15. How to generate a round-robin tournament
16. How to return a value if lookup value is in a range
17. How to use the SUMPRODUCT function
18. Identify numbers in sum using Excel solver
19. Identify rows of overlapping records
20. If cell contains text from list
21. Lookup a date in date ranges and get the corresponding value
22. Plot date ranges in a calendar
23. Prevent duplicate records in a worksheet
24. Repeat values across cells
25. Team Generator
26. Working with overlapping date ranges
27. 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. Find and return the highest number and corresponding date based on a condition
2. How to use the TAKE function
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. Follow stock market trends – Moving Average
3. How to create date ranges in Excel
4. How to extract numbers from a cell value
5. How to use the TEXT function
6. Lookup and return multiple values concatenated into one cell
9. VLOOKUP – Return multiple unique distinct values
10. Working with classic ciphers in Excel
12. 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. Extract specific word based on position in cell value
3. How to use the TEXTSPLIT function
4. If cell contains text from list
5. Lookup with any number of criteria
6. Rearrange values using formulas
7. Search for a text string in a data set and return multiple records
TextToColumns method
Time
TIME function
1. How to use the TIME function
TIMEVALUE function
1. How to use the TIMEVALUE function
TOCOL function
1. 5 easy ways to VLOOKUP and return multiple values
2. Compare two columns in different worksheets
3. Count unique distinct values
5. Extract a list of duplicates from a column
6. Extract a unique distinct list from multiple non adjacent cell ranges
7. Extract duplicates from a multi-column cell range
8. Extract unique distinct values from a multi-column cell range
9. Get date ranges from a schedule
10. How to compare two data sets
11. How to create date ranges in Excel
12. How to list unique distinct values sorted by frequency
13. How to use the TOCOL function
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
2. Get date ranges from a schedule
3. How to track sector performance in the stock market – Excel template
4. How to use the TODAY function
Top/Bottom Rules
TOROW function
1. How to use the TOROW function
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. Automate net asset value (NAV) calculation on your stock portfolio
5. Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors
6. Compare two columns in different worksheets
10. Extract a list of duplicates from a column
11. Extract duplicates from a multi-column cell range
12. Extract specific word based on position in cell value
13. Extract unique distinct values from a multi-column cell range
14. How to compare two data sets
15. How to extract numbers from a cell value
16. How to list unique distinct values sorted by frequency
17. How to perform a two-dimensional lookup
18. How to return a value if lookup value is in a range
19. How to use VLOOKUP/XLOOKUP with multiple conditions
20. Identify rows of overlapping records
21. If cell contains text from list
22. INDEX MATCH – multiple results
23. Lookup a date in date ranges and get the corresponding value
24. Lookup and return multiple values concatenated into one cell
25. Lookup multiple values across columns and return a single value
26. Lookup with any number of criteria
27. Partial match for multiple strings – AND logic
28. Rearrange values using formulas
29. Search for a sequence of values
30. Search for a text string in a data set and return multiple records
32. VLOOKUP – Return multiple unique distinct values
33. Working with classic ciphers in Excel
34. 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 from an Excel Table filtered list
6. VLOOKUP – Return multiple unique distinct values
UNIQUE function
1. 5 easy ways to extract Unique Distinct Values
2. Compare two columns in different worksheets
4. Count unique distinct records
5. Count unique distinct values
6. Create dependent drop down lists containing unique distinct values
7. Extract a list of duplicates from a column
8. Extract a unique distinct list from multiple non adjacent cell ranges
9. Extract a unique distinct list sorted from A to Z
10. Extract duplicates from a multi-column cell range
11. Extract unique distinct values from a multi-column cell range
12. Extract unique distinct values from an Excel Table filtered list
13. Filter unique distinct records
14. How to compare two data sets
15. How to create date ranges in Excel
16. How to extract numbers from a cell value
17. How to list unique distinct values sorted by frequency
18. How to return a value if lookup value is in a range
19. How to use the UNIQUE function
20. Lookup and return multiple values concatenated into one cell
21. Merge cell ranges into one list
22. Populate drop down list with unique distinct values sorted from A to Z
23. Search for a text string in a data set and return multiple records
26. Unique distinct records sorted based on count or frequency
27. Use a drop down list to search and return multiple values
28. VLOOKUP – Return multiple unique distinct values
29. Working with classic ciphers in Excel
30. Working with unique values
Unique values
1. 5 easy ways to extract Unique Distinct Values
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 from 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 new worksheets programmatically based on values in a cell range [VBA]
8. Customize the ribbon and how to add your macros
10. Excel template: Getting Things Done [VBA]
12. Extract unique distinct values from an Excel Table filtered list
14. How to copy non contiguous cell ranges
15. How to create an interactive Excel chart
16. How to save specific multiple worksheets to a pdf file programmatically
18. How to use the LIKE OPERATOR
20. List all hyperlinks in worksheet programmatically
21. Run a Macro from a Drop Down list [VBA]
23. Search all workbooks in a folder
24. Search for a file in folder and subfolders – UDF
25. Show / hide a picture using a button
26. Split data across multiple sheets – VBA
27. Working with ARRAY VARIABLES (VBA)
28. Working with COMBO BOXES [Form Controls]
29. Working with comments – VBA
30. Working with Excel tables programmatically
32. Working with LIST BOXES (Form Controls)
33. 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. How to return a value if lookup value is in a range
2. How to use the asterisk character
3. How to use the VLOOKUP function
4. How to use VLOOKUP/XLOOKUP with multiple conditions
5. Lookup a date in date ranges and get the corresponding value
6. Merge tables based on a condition
VSTACK function
1. 5 easy ways to VLOOKUP and return multiple values
2. Calculate machine utilization
3. Compare tables: Filter records occurring only in one table
4. Compare two columns and extract differences
5. Extract a list of duplicates from a column
6. Filter unique distinct records
7. Filter unique distinct records case sensitive
9. Find the most recent date that meets a particular condition
10. How to create date ranges in Excel
11. How to use the VSTACK function
12. Merge cell ranges into one list
13. Search for a text string in a data set and return multiple records
14. Working with classic ciphers in Excel
15. Working with unique values
Waterfall chart
WEBSERVICE function
1. How to use the WEBSERVICE function
WEEKDAY function
1. Calculate machine utilization
3. How to track sector performance in the stock market – Excel template
4. How to use the WEEKDAY function
WEEKNUM function
1. Count unique distinct values
2. Extract a list of duplicates from a column
3. How to use the WEEKNUM function
Wildcard Search
Win/loss
WITH ... END WITH Statement
WORKDAY function
1. How to track sector performance in the stock market – Excel template
2. How to use the WORKDAY function
Worksheet
1. List all hyperlinks in worksheet programmatically
WRAPCOLS function
1. How to use the WRAPCOLS function
WRAPROWS function
1. 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
6. Extract a list of duplicates from a column
7. Filter unique distinct records
8. Follow stock market trends – Moving Average
9. How to create date ranges in Excel
10. How to track sector performance in the stock market – Excel template
11. How to use the YEAR function
13. VLOOKUP – Return multiple unique distinct values
15. Yet another Excel Calendar
YEARFRAC function
1. How to use the YEARFRAC function
YIELD function
Comments Off on Excel formula examples
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form