 |
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to Do a ... Posted by: ExcelIsFun
Video duration: 404 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to Do a lookup that finds the smallest value that is greater than or equal to lookup_value using the INDEX function and a -1 (minus one) in the 3rd argument of the MATCH function, or said a different way: Upside down VLOOKUP: Sort 1st Column Decending & Bump Into First Smallest Value, then jump back a row. |
 |
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet Posted by: ExcelIsFun
Video duration: 497 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data Validation List, the INDIRECT Function, and the join symbol ampersand & 2. Learn about syntax for Sheet References 3. INDIRECT Function 4. Data Validation Drop Down List |
 |
Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107 Posted by: ExcelIsFun
Video duration: 481 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm SchultzesBlues and Daniel1Dion at YouTube give great examples of how to add a leading zero and dash to a number using the REPLACE function and Custom Number Formatting, Related to this video: Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers |
 |
Excel Magic Trick 910: Adding with AND, BETWEEN and OR Criteria: SUMIFS and COUNTIF Functions Posted by: ExcelIsFun
Video duration: 323 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to Adding with AND, BETWEEN and OR Criteria with SUMIFS function for AND criteria and 2 COUNTIF functions for OR criteria. |
 |
Mr Excel & excelisfun Trick 106: LOOKUP Function in VisiCalc, Lotus and Excel Posted by: ExcelIsFun
Video duration: 611 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See Mr Excel and excelisfun talk about LOOKUP in VisiCalc, Lotus and Excel |
 |
Mr Excel & excelisfun Trick 105: Count Between Words Posted by: ExcelIsFun
Video duration: 484 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words |
 |
Excel Magic Trick 908: Count Text Entries Between Two Dates Posted by: ExcelIsFun
Video duration: 305 seconds Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm See how to: 1. Count Text Entries Between Two Dates using COUNTIFS, Date Criteria and Comparative Operators, and wildcards for Text |
