Ahmed asks how to do a lookup that only looks at the text portion of the lookup value. Mike and Bill compare methods in this Dueling Excel Episode 1169.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Concatenate to 3 Rows - 1168 - Learn Excel from MrExcel

Khader asks how to concatenate three cells so that they appear on three lines in a new cell. Episode 1168 shows you how.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Coercing Number Array 1167 - Learn Excel Podcast

Building on Teo's question from yesterday, Bill expands the technique to generate an array of 50 sequential numbers instead of typing that whole range out. Episode 1167 shows you how.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Sum Big 3 - 1166 - Learn Excel from MrExcel Podcast

Teo asks how to sum up the three largest values in a range. Episode 1166 shows you how.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Lookup 3 Tables - 1165 - Dueling Excel Podcast

In today's dueling podcast, we need to look up a value in one of three different tables depending on the product selected. Mike and Bill show many ways to solve the problem in Episode 1165.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Curved Arrows - 1164 - Learn Excel from MrExcel Podcast

Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows.


...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Show a Month - 1163 - Learn Excel from MrExcel

Shaun has a large worksheet with 12 monthly reports on it. On a summary worksheet, he would like to show one particular month based on a dropdown. In episode 1163,discusses Paste Special Column Widths, Array Formulas, Match, and OFFSET.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

January Not = January - 1162 - Learn Excel from MrExcel Podcast

A simple MATCH formula is not working. In episode 1162, we wander through the Validation dialog, the Name Manager dialog, all trying to figure out why the MATCH formula is returning #N/A.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

VLOOKUP All Columns - 1161

Today's dueling podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.

Sheet Tabs - 1160 - Learn Excel from MrExcel

Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, Episode 1160 shows various ways of dealing with the issue.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

PowerPivot Mashup - 1159 - Learn Excel From MrExcel

Using PowerPivot for Excel 2010 to mashup data on two different worksheets. Episode 1159 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Right Two

David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Easy-XL

Easy-XL adds 50 new data analysis features to Excel. Episode 1157 shows some of the cool features of Easy-XL.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Named Lists

Ed asks how to assign a list of weekdays to a name in Excel. Episode 1156 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Thousands Millions

A question from Texas about setting up a chart in Excel. The goal is to show a mix of points that contain thousands and/or millions. While typing the K or M abbreviations might seem like a good way to get the table to appear, it is not a good way to have numbers that you can chart. Episode 1155 shows you how to solve the problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Mapping Route - 1154 - Learn Excel From MrExcel Podcast

Take geographic data from Excel and plot it as a route in MapPoint. Episode 1154 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!