From a List of dates, see how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month. Also see a formula that ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #221: LEN function Counts Spaces
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to use the LEN function to count charters including spaces. Then see how to use the LEN, SUBSTITUTE, and TRIM function to count characters but not ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #229: Dump Data Pivot Table Macro
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
This video is in response to Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2. See how to dump data on a sheet and then run the Macro To ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #225: 2 Way Lookup With Duplicates
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
See how to do a Two Variable Lookup When There are duplicates. See the INDEX, IF, ROW and MAX functions. Also see these videos: Excel Magic Trick # 158: ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #224: Extract Prefix From Product ID
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
See how to extract prefix from product id when there is no dash or space to establish a pattern. See the LEFT, MATCH, ISERROR, ROW, INDIRECT and LEN ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #228: Text Formula & Forced Wrap Text
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
Amazing Text Formula Trick. See how to use the CHAR (10) function to add hard line returns (Forced Wrap Text) to a Text Formula created with the Ampersand ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #223 Count Single Character In Text String
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
How many "X"s are ther in that word? See how to count individual letters in a word. See how to count the occurrence of a given character in a text string. See the ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #230: Dynamic Stock Chart Excel Table List
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to use the Excel List Table feature to make a dynamic Stock Price Line Chart. Excel 2003 create a List use Ctrl + L. Then the ranges in the table are ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how use VLOOKUP when there are 3 tables on 3 different sheets. See how to use the VLOOKUP & INDIRECT functions as well as named cell ranges in a ...
