### Dueling Excel 67

March 2, 2016

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 Magic Trick 1194

February 29, 2016

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

### Data Validation Pick List

February 26, 2016

WORKBOOKS

### The Developer Tab

February 25, 2016

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 66

February 24, 2016

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

### Display Day Name From A Date

February 23, 2016

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 Magic Trick 1193

February 22, 2016

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

### INDIRECT Function

February 20, 2016

WORKBOOKS

### Dueling Excel 64

February 17, 2016

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 Magic Trick 1192

February 15, 2016

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