Excel Is Fun

Excel Magic Trick 1161

September 17, 2015 0

F4 Key To Repeat Last Action DESCRIPTION See how to use the F4 Key To Repeat Last Action

Dueling Excel

Dueling Excel 041

September 16, 2015 0

VBA or Formula Extract Prefix for VLOOKUP DESCRIPTION See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. […]

Excel VBA

Excel VBA For Each Loops

September 15, 2015 0

Excel VBA Introduction Part 17 – For Each Loops DESCRIPTION A For Each Loop is used to loop over a collection of objects and there are lots of good reasons for wanting to do that […]

Excel Is Fun

Excel Magic Trick 1160

September 14, 2015 0

Jump To Next Change In Column: Go To Special, Column Difference DESCRIPTION See how to use Jump To Next Change In Column: Go To Special, Column Difference. Learn the keyboards to do this quickly

Excel Is Fun

Excel Magic Trick 1159

September 10, 2015 0

Extract Unique List For Data Validation List with Power Query DESCRIPTION See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown: (00:08) Problem Set, including showing how complicated Array Formula […]

Dueling Excel

Dueling Excel 040

September 9, 2015 0

VLOOKUP to 3 Different Lookup Tables (3 table_arrays) DESCRIPTION See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks: 1) INDIRECT and CHOOSE 2) CHOOSE alone 3) […]

Excel VBA

Excel VBA For Next Loops

September 8, 2015 0

Excel VBA Introduction Part 16 – For Next Loops DESCRIPTION You can use a For Next Loop to tell your program to repeat a set of instructions a number of times. This video teaches you […]