MrExcel Excel Videos

Ronak asks: How can I use Excel to find out how many weekedays per month for the whole year? This video shows how to do it using SEQUENCE, TEXT and a quick pivot table in Excel.

Michele has 46000 rows of data. Each ID has several records in a row. Many records are marked as "Changed". When there is a change, Michele needs to check the record marked, plus the matching IDs just above and below. In this video, I try Find All and 2 Advanced Filters. I bet you have something better.

Microsoft Excel Tutorial: Version History has improved. A cool new feature from the MVP Summit: The Version History pane in Excel Online gives you an impressive visual view of who made what changes to your Excel workbook. I previously mentioned how Show Changes debuted 9 months ago. Somewhere in the last nine months, the obscure Version History feature (found under File, Info) has gotten much better. Save your document to OneDrive or SharePoint Online. Work as normal in Desktop Excel. If something gets screwed up, you can go to Excel Online. Use File, Info, Version History and preview every change made from the new Version History panel. These new improvements will make this an amazing feature. Buy Bill Jelen's latest Excel...

You have a bunch of sentences in Excel. How do you find the last word in each cell using a formula? The new TEXTAFTER function solves the problem.

Way back in episode 2326, I spent 8+ minutes showing how to use LET to get the second to last word from a cell. Today, it still requires TEXTBEFORE, TEXTAFTER, and TRIM but can be done in 45 seconds.

Why does the new TEXTSPLIT function in Excel return #N/A errors at the right side? When does a double space create a blank cell? Solve both problems using optional arguments for Ignore_empty and Pad_With.

How to get the Unique list of items appearing in a rectangular range. This solution uses the new TOCOL function released on March 16, 2022 to Microsoft 365 Office Insiders.

Today, a deeper dive into the new Excel functions TOCOL and TOROW. Table of Contents (0:00) Ignore errors with TOCOL (0:46) Non-contiguous ranges with TOCOL (0:56) 3-D Ranges with TOCOL (1:26) Using TAKE and HSTACK (2:01) VSTACK for Headings

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button. Note: A similar discussion happened in episodes 742-745. You might want to review those videos as well, as they go the extra step of creating an add-in. PLEASE - if you need to save as PDF or if you alphanumeric invoice numbers, read through the FAQ at Next Invoice Number. Your question has already been answered many times in the comments below...