MrExcel Excel Videos

A cineplex has 18 theatres that show movies. Given the schedule of when each movies begins and ends, how many movies are being shown at any given moment? Bill and Mike offer competing formulas.

Due to a strange accounting error, I had to reduce 7 invoices by 80%. I had filtered to those 7 invoices. Copied 0.2 to the clipboard. I was about to Paste Special Multiply, when I wondered if it would work correctly. Episode 1900 shows you the result.

All week, I've been testing a Responsive Web Design (RWD) for a new section of MrExcel.com called the Excel Mall. It is Friday afternoon, and I am looking for some people with a variety of phones (Android, Windows, iPhone) or tablets to give the new site a spin and let me know if the site is rendering OK on your device? http://www.mrexcel.com/Excel_Utilities.html

You have a main table and two lookup tables. You need to use all three tables in a pivot table. Bill shows Power Pivot and Mike shows VLOOKUP in Dueling Excel episode 161

Can you have the height and width of a rectangle in Excel change in response to formula cells in the worksheet? Episode 1899 shows a Worksheet_Calculate event handler that does the trick.

You have a column of numbers. Select the column. Totals appear in the status bar. But they are wrong. Turns out a lot of the numbers are not in the total. The green triangles are not showing up to indicate text. There is no apostrophe. What is going on? This episode includes an open letter to the Excel team from all of us, asking for TRIM and CLEAN to start handling CHAR(160) - the Non-Breaking Space.

Char asks: When you have a column chart with a mix of positive and negative numbers, the month labels are appearing near the axis instead of at the bottom of the chart. How can you move the labels to the bottom of the chart? As a bonus, this podcast shows how to have the positive numbers in green and the negative columns in red. Covers both Excel 2013 and Excel 2010.

Sum all of the negative values from this range, but only if the row ID matches a particular value. Mike and Bill duel it out in Excel. Although Mike comes up with a single-cell formula and Bill needed many helper cells, when we used Charles Williams Fast Excel V3, the helper cell solution was faster.

The dueling Excel podcasts return with a new theme song from Sziliva Juhasz, a new voiceover from Charles "Fast" Williams, a D function from ExcelisFun, and more in this three-way lookup problem.