Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
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.
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.
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.
Today's dueling Excel podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.
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.
Using PowerPivot for Excel 2010 to mashup data on two different worksheets.
David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 shows you how.
