MrExcel Excel Videos

A new recipe on a favorite trick from Albuquerque New Mexico. First, a little roasting of Hatch chiles. Then, how to create a filter criteria in a cell below your data. This episode shows two different ways to filter - one for Ctrl+T tables and a faster way for regular ranges. Table of Contents (0:00) Roasting Hatch chiles (0:37) Introduction (0:45) Creating Criteria row for a Ctrl+T table. (1:40) Using AutoFilter on a regular range (2:19) Wrap up

As of August 25, 2020, there have been 85 launches of the Atlas V rocket. Don't take my word for it. We ask Tory Bruno, the CEO of United Launch Alliance. He says there have been 85. But Excel insists there are 36. Wolfram Alpha says their data is expertly curated. This begs the question: expertly curated by whom? And when we report an error, who is checking it? And what errors are coming to Excel that we don't know are errors?

Experimenting with the Wolfram Alpha data types, I discovered that Excel can predict when the Sun will rise at your location with amazing accuracy. Since the sunrise time is based on Latitude and Longitude of the viewer, this means that Excel must know where you are located, based on the I.P. address of your computer.

Thanks to a comment from Gaetan, I realized that the Excel dynamic array function FILTER could be used to filter out columns as well as rows. As long as your second argument evaluates to a one-row array constant, you are good to go. Examples in this video: Filtering to specific column with a hard-coded array constant. Filtering to specific columns using XMATCH or MATCH. Filtering to columns using formulas in a helper row.

UserVoice viewers have been asking Microsoft for a TEXTSPLIT function. Thanks to a comment from Daniel Dion, it turns out that we've had a function to do TEXTSPLIT since Excel 2013! In this episode, we break down the FILTERXML function in Excel.

Jonathan remembers that Excel 2010 would let you Select Visible while filtered, then clear the filter. It is not working today. Or is it working? The bug seems to be with the grey selection boxes that show you what is selected. The good news, once you know it is a bug, you can keep those visible cells as the only ones selected.

Sher has data with text months such as Jan'20, Feb'20, and so on. How can you sort those months by date? Today, a trick from Sam Radakovitz using text months as a custom list and then sorting by a custom list.

New in Office Excel, Word, and PowerPoint. Right-click any object and choose Save As Picture. This feature seems so natural, it is hard to believe it has not been there for decades. Same SmartArt as a picture. Save a chart as a picture. Save Cutout Randy as a picture. Also in this episode, using a Linked Picture to be able to save part of the grid as a picture.

Sowmiya needs to highlight entire row with highest value with different data sets.. for eg coulmn A having id numbers , id 1 and 2 etc.. column b having lead count.. coloumn C having dates. Id1 taken lead count 6, 9 , 10 in different dates.. id number 2 having lead count 15 , 10 , 9 in different dates. I need to highlight unique highest values for each id. Output I need is to highlight the row id1 against lead count 10 and id 2 against 15 which is the highest value