Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple ...
See how to do 1 Condition Lookup Adding for both the VLOOKUP and HLOOKUP functions. See how to use an array constant in the row/column num argument ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells
by
ExcelIsFun
on
Youtube
Duration:
0.11 hours
See how to lookup two values at once and return then both to: 1. One Cell using 2 VLOOKUP functions and concatenation (Ampersand &) 2. Two Cells using 1 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
by
ExcelIsFun
on
Youtube
Duration:
0.23 hours
Complex text extract formula that extracts text to use in VLOOKUP to lookup values and return data. See these Tricks: 1. Extract all letters from text string 2.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data ...
by
ExcelIsFun
on
Youtube
Duration:
0.24 hours
See how to create an Excel solution that allows user to type in an area code and retrieve phone numbers of all suppliers in the area code. See these Excel tricks: ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Number...
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
See a formula to compare two list of numbers and see what happens (and how to solve it) when one list is numbers (aligned right) and the other list is numbers ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch
by
ExcelIsFun
on
Youtube
Duration:
0.21 hours
We have In Time & Out Time for either Day or Night Shift and we must subtract 1 hour for weekday lunch and 1/2 hour for weekend lunch. See the formula to ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 715: Take Number with Spaces and Convert to Number
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to: 1. Take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero 2. Take a number with ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn about Relative and Absolute Cell References in Formulas. Learn how to ...
