Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP
Loading...
Loading...
1:21
Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Functionby ExcelIsFun8,595 views- 7:39
Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formulaby ExcelIsFun2,620 views
- 5:16
Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookupby ExcelIsFun1,311 views
- 6:11
Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheetby ExcelIsFun1,585 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun16,269 views
- 6:56
Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculationby ExcelIsFun5,832 views
- 5:53
Excel Magic Trick 435: Extract Duplicate Records with Formulaby ExcelIsFun4,718 views
- 9:33
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headersby ExcelIsFun3,397 views
- 9:23
Historical Volatility Calculation with Excelby lordbinder20,235 views
- 9:06
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Totalby ExcelIsFun5,217 views
- 6:43
Excel Magic Trick 436: VLOOKUP W 4 Lookup Columnsby ExcelIsFun2,332 views
- 7:09
Excel Magic Trick 493: Repeat a List of Names 7 timesby ExcelIsFun2,210 views
- 6:01
Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)by ExcelIsFun1,419 views
- 5:27
Excel Magic Trick 490: Conditional Format for Budget Less Than $500.by ExcelIsFun2,510 views
- 4:50
Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbersby ExcelIsFun4,119 views
- 2:41
Excel Magic Trick 484: Stop Automatic Copyright symbol ©by ExcelIsFun3,375 views
- 1:52
Excel Magic Trick 474: Conditional Format At Every Change In Valueby ExcelIsFun1,903 views
- 3:52
Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formulaby ExcelIsFun1,301 views
- 7:01
Excel Magic Trick 492: Count Matches in Single Cellby ExcelIsFun1,364 views
- 1:36
Excel Magic Trick 456: Add Only Integer Part SUM & INT functionsby ExcelIsFun1,321 views
EXCELlent!!!
ExcelIsFun 2 years ago
Thank you for refering me to the the series #5. I understand the functionof F9 now.
wevenhuis 2 years ago
F9 key is the evaluate key. You can highlight any part of a formula and hit the F9 key to see what it evaluates to. This is particularly helpful when learning how to make a complicated formula. Be sure to undo so you don't hard code the evaluated formula part into the formula.
The F9 key can also be used to hard code a table into a VLOOKUP formula. See this video:
Excel Lookup Series #5: VLOOKUP Function 5th Example
ExcelIsFun 2 years ago
I am confused about the F9. What are you exactly doing when pressing this key?
wevenhuis 2 years ago