Sort data where each record occupies three rows.
Erik asks how do deal with data where each record takes up three rows. Episode #1176 shows you how.
-
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.
Use countif for variable value.
A question from Trinidad about using countif. Episode #1175 shows you how.
Links stop updating in Excel 2007.
A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode #1174 shows why and how to fix this problem forever.
Move a column of names to be a row of names.
Paula asks how to take a range and turn it on its side. Episode #1173 shows you how.
Pivot tables start appearing in strange sequences in Excel 2007.
Szilvia noted a strange anomaly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode #1170 takes a look at this mystery and the solution.
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.
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.
