Excel Magic Trick #179: Are All Four Word The Same?
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
Determine whether four words in four cells are exactly the same (case sensitive). Use the IF, AND and EXACT functions in 2 different formulas: A long IF formula ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #183: Income Statement by Year & Month
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to sum revenue from a table of data by year and month using the SUMPRODUCT & TEXT & SUM & IF & LEFT functions in an array formula. SUM items ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #184: Setup Database in Excel
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to create a simple database in Excel using the List or Table feature. A simple database can be created in Excel using the Excel 2003 "List" feature or ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria
by
ExcelIsFun
on
Youtube
Duration:
0.16 hours
See methods for counting: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to use Advanced Filter to extract records from a table with 2 criteria. Related Videos: Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick #187: Unique List w Dynamic Formula
by
ExcelIsFun
on
Youtube
Duration:
0.16 hours
Create a unique list of items for a large list that contains duplicates with 2 array formula that contain the functions: SUM, IF, ROWS, COUNTIF, INDEX, SMALL, ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
This formula will extract records that meet two conditions (criteria) and list them in order with no extra rows between records. Create a formula to extract part of a ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
Macro and Advanced Filter. See how to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automatic it. Related Videos: Excel ...
