
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.

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.

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.

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. Episode 1163 discusses Paste Special Column Widths, Array Formulas, Match, and OFFSET.

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.

Bren McFadden
Anyone having trouble logging in?
It won't let me!
It says "redirecting" but still doesn't show that im logged in.

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.

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.

John Shaw
Hello,
I was hoping for some help. I am trying to produce a yearly delivery performance for my company. Basically I have a column of delivery dates and a column of whether they were delivered early of late. Current I have an overall delvery performance using =COUNTIF(Repairs!Y$476:Y$563,"Early") to calculate early and s...imilar for late then I just total it. But i need to change it to year and I am having trouble inserting a IF statement in front with a date range. So i need it to say if column x is in 2008 then countif early.
Any help please.
Thanks

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

MrExcel.com We launched a new Excel add-in today at www.Easy-XL.com - 50 tools to simplify data analysis. Free 30 day trial.
www.Easy-XL.com
Easy-XL From MrExcel Excel Data Analytics Made Simple

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

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, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>...











