Dueling Excel

Dueling Excel 66

Slaying Excel Dragons E-Book Available at Mr Excel Web Site! DESCRIPTION See Mr Excel and excelisfun talk about the new book Slaying Excel Dragons by Mike excelisfun Girvin. WORKBOOKS

Tricks & Tips

Display Day Name From A Date

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1193

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup [Read More >>>]

Dueling Excel

Dueling Excel 64

Extract Records With Not Criteria VBA or Filter DESCRIPTION See Mr Excel and excelisfun Extract Records From A Data Set With Not Criteria VBA or Filter. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1192

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 [Read More >>>]

Formulas & Functions

IF Function

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

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1191

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 [Read More >>>]