Dueling Excel

Dueling Excel 67

March 2, 2016 0

Extract Initials From Full Name: VBA or Formula? DESCRIPTION See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1194

February 29, 2016 0

VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do? DESCRIPTION See how convert Number lookup_value to Text Number and how to convert Text Number lookup_value to Number to VLOOKUP does not yield #N/A: (00:08) Problem […]

THE RIBBON

The Developer Tab

February 25, 2016 0

The Developer Tab contains a variety of tools that allow you to customize Excel. Of particular importance is the fact that the Developer tab contains tools that allow you to create, access and edit macros. […]

Dueling Excel

Dueling Excel 66

February 24, 2016 0

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

February 23, 2016 0

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 […]

Excel Is Fun

Excel Magic Trick 1193

February 22, 2016 0

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 […]

Dueling Excel

Dueling Excel 64

February 17, 2016 0

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

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 […]