MrExcel Excel Videos

The new XLOOKUP for Excel debuted yesterday. Can it replace INDEX-MATCH? Can it replace INDEX-MATCH-MATCH? The answer is Yes!

You have a bunch of zip codes (postal codes) in Excel. What can you do with those? Thanks to the new Office 365 Geography Data type, you can easily get the city, county, state or province from Excel. Then, I show you how to use a State slicer to create a zip code map for any state showing where your customers are located.

Robert asks: Is there a fast way to take a 60-sheet Excel file and create a series of linked tables in Word? Today, using some code from Suat Ozgur, a macro to solve the problem. Buy Suat's Javascript Book: Excel JavaScript UDFs Straight to the Point Download the Macro: https://www.mrexcel.com/download-center/2019/06/macrototransfertoword.xlsm Videos from MBAS:

If you work in Accounts Payable, check out the great resources at AP-Now.com. Today's question from a recent webinar that I did for the AP-Now members: Given an Excel worksheet of payments made by accounts payable, how can you look for duplicate payments. My solution involves the new TEXTJOIN function, the Mark Duplicates feature in Conditional Formatting, and then Filter by Color.

Kim has a distribution list in Outlook with 130+ names. She wants those names in Excel. When she copies and pastes, everything ends up in a single cell. In this episode, a simple set of steps to split the distribution list into rows and then columns for Name and E-Mail address. These steps won't (yet) work on a Mac. You are using the Get & Transform tools (also known as Power Query) on the Windows version of Excel.

I was trading Excel tips with Robert from Florida and he gave me a list of four hard ways to get bullets into Excel. There is now a fifth way and it is super-easy! At least, it is easy if you are using Excel on a Windows machine and you have a numeric keypad on your keyboard.

To buy or try WBMerge: https://mrx.cl/2HVj0wU Save 20% on WBMerge through June 30 2019 using discount code MREXCEL In this video, I try the WBMerge utility on a collection of Excel workbooks that might be problematic in Power Query. WBMerge is a $39 utility from Workbook Tools. The utility can merge data from multiple Excel workbook or multiple Google Sheets files.

I have two great things to report about Excel. First, the old Tool Tabs in the Ribbon have become smaller. I love the new style and it makes perfect sense. Second, I have a bit of a rant about the questionable Microsoft Search box that is now dominating the Title Bar in Excel. Who is using this? Why are they making it so large? Great news part 2: If you plan to never use the Search box, minimize it to a tiny icon.

I can't solve today's question using the regular Filter. I am sure someone has a better way. A person in my Milwaukee seminar wants to filter text account numbers to everything between 6 & 9. Do you have a solution?