MrExcel Excel Videos

A question from my Daytona Beach seminar last week: We know XLOOKUP can find the number just larger or just smaller than a number. But does this also work with Text? How about with Symbols? In this video, Bill Jelen shows how the approximate match works with XLOOKUP. Unlike MATCH or VLOOKUP, the table does not have to be sorted. You can find a value just smaller or just larger than the search value. This also works with Text, although it is case insensitive. And, it works with symbols, but in an unexpected sequence.

Did I know this? The Excel Status Bar Statistics pick up the number format of the active cell in the grid. This is a useful feature, and not a bug. But it could freak someone out when you get different answers depending on if you select from bottom to top or top to bottom. Also in this episode: the four zones of Custom Number Formats. And, the winner(s) of a free Excel PDF.

Diane has a fairly complex pivot table. She is using GETPIVOTDATA to pull data from the pivot tables to a summary report in another workbook. In another section of the report, she needs to pull YTD. But this complicates the formula, because she has to add an expanding range as the months continue. I mentioned that she could create a second pivot table that shows the sales numbers as YTD numbers. This video shows how to copy the first pivot table and how to use Running Total In to convert from monthly sales to YTD Sales.

how do i copy only subtotals in excel how to copy excel subtotals only how to copy just subtotals in excel how to only copy subtotals from excel how to extract excel subtotals how to extract subtotal from excel

Thanks for this tip from Paul A who was in my Akron seminar. Paul uses a function like SUM(XLOOKUP:XLOOKUP) to return the total of all numbers from a start date through an end date.

how to collapse subtotals in excel how to see only subtotals excel

excel subtotal how to sort how do i sort subtotals in excel how to data sort subtotal in excel how to sort a subtotals list in excel how to sort and subtotal in excel how to sort by subtotal in excel how to sort subtotal data in excel how to sort subtotals in excel

how to add a second level subtotal feature excel how to subtotal by two levels in excel how to subtotal multiple columns in excel excel how to make multiple subtotals how to add multiple subtotals in excel how to create multiple subtotals in excel how to create multiple subtotals in excel?

excel how to get rid of subtotals how do i remove subtotals in excel how remove subtotals in excel how to do subtotal remove all in excel how to remove a subtotal in excel how to remove all subtotals in excel how to remove excel subtotals how to remove subtotal excel how to remove subtotal in excel how to remove subtotals in excel how to remove the subtotal in excel how to undo subtotals in excel remove subtotal in excel how to take out a subtotal in excel how to eliminate subtotals in excel how to remove - from excel to show subtotal