MrExcel Excel Videos

Mysteriously, some Excel cells are showing a leading space. But when you double-click to edit the cell, the leading space disappears! The cells are left-justified, no indent. What is causing the problem?

Today's question: You have to rent rail tank car #123 for a 3 month period. The daily rate changes twice ; once in May, and once in June. Given the start date, end date, and the rate changes, how can you calculated the total rental charge or average per day? Bill shows how he has been reading MIke's Ctrl+Shift+Enter book and creates an array formula. Mike makes the formula better. Links: Mike's Ctrl+Shift+Enter book: Ctrl + Shift + Enter Bill's May 9 seminar in Tampa: https://www.eventbrite.com/e/bill-mrexcel-jelen-at-spring-ima-fl-council-seminar-8-cpe-tickets-10676733397 Mike's appearance on ExcelTV:

On Sheet 1, you have customer data with subtotals added by the Subtotal command. On Sheet 2, you have a list of customers. How do you do VLOOKUP from Sheet 2 to get the total for each customer from Sheet 1? This question was posed during my Fort Wayne seminar. In episode 1882, two possible ways to solve the problem.

I love doing Power Excel seminars. I was in Fort Wayne, doing a seminar at a baseball stadium, when a question popped up: If I double click on Sunday, it automatically fills down with Monday, Tuesday, Wednesday. Will your Ctrl key trick work to make it Copy? I don't want to have to use the pop-up menu to change back to Copy instead of Fill. Why was this a great question? Because I had no idea that double-clicking a cell would cause the AutoFill to work! In episode 1881, you will see how to AutoFill by Double Click, how to set up a custom list, a workaround to prevent the AutoFill and make it a copy, plus, in the outtake, a formula using INDEX ROW and MOD together.

Michael has data in column A. He needs to extract everything after the dash to column B. This podcast shows four different methods. If you ever wondered how to create fake data for your own Excel podcast, watch the outtake at the end. For information on the May 9 Tampa Power Excel seminar, visit: ow.ly/w9xMG

If you change your zoom to 39% or lower, Excel 2013 will show you the name and shape of your named ranges. Thanks to Excel MVP Bob Umlas for showing me this great trick!

Darvaish asks how to keep leading zeroes during data entry. If you type 0523 in Excel, it changes to 523. Today's episode offers three solutions.

Thanks to #NASASocial and SpaceX, I was invited to watch the Falcon 9 rocket launch on April 18, 2014. SpaceX gave us great swag bags that included a Dragon Docking Simulator. Check out the simulator in action. NASASocial offers opportunities to get an inside look at the science happening at NASA. Apply at NASA Socials

If any record for the project is marked Finished, highlight all records for that product in green. Bill and Mike try different methods, such as COUNTIFS, LOOKUP, and Conditional Formatting.