Excel Is Fun

Excel Magic Trick 1192

February 15, 2016 0

Match Lookup Value to Closest Number in 1st Column of Lookup Table DESCRIPTION What to do if you need to match Lookup Value to Closest Number in 1st Column of Lookup Table: (00:10) Problem Set […]

Formulas & Functions

IF Function

February 14, 2016 0

IF function Use the IF function to return one value if a condition is true and another value if it’s false. Syntax IF(logical_test, value_if_true, [value_if_false]) example: =IF(A2>B2,“Over Budget”,“OK”) =IF(A4=500,B4-A4,“”) WORKBOOKS

Dueling Excel

Dueling Excel 63

February 10, 2016 0

2 Criteria Lookup and Multiple Table Lookup From Different Sheets DESCRIPTION See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that: 1. Uses functions […]

Excel VBA

Excel VBA Typed Collections

February 9, 2016 1

Excel VBA Introduction Part 38 – Typed Collections DESCRIPTION One of the issues with the Collection class in VBA is that it’s untyped. This means you can add any kind of object to the collection […]

Excel Is Fun

Excel Magic Trick 1191

February 8, 2016 0

VLOOKUP: Lookup Temperature and Return to Bat Observation Table DESCRIPTION In this example we have Date Set 1 with Bat Observation Date-Times and we need to lookup the Date-Time in a second Data Set with […]

Dueling Excel

Dueling Excel 62

February 3, 2016 0

Conditional Format Chart Auto Feature or Formula DESCRIPTION See Mr Excel & excelisfun Conditional Format a Chart: 1) Excel 2010 with an automatic feature 2) Formula Method Format Columns where quality rating is greater than […]

Excel VBA

Excel VBA Custom Collections

February 2, 2016 0

Excel VBA Introduction Part 37 – Custom Collections DESCRIPTION Excel VBA is full of collections and you can even create your own custom collections using the Collection object. This video teaches you how to create […]

Excel Is Fun

Excel Magic Trick 1190

February 1, 2016 0

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]