MrExcel Excel Videos

Four answers today: Excel remove duplicates without shifting Keep Duplicates Remove Everything Else Which Row does Excel Keep during Remove Duplicates Excel Get Duplicates Back Formula to Remove Duplicates in Excel using UNIQUE and SORT functions FILTER to keep only certain columns Ctrl+z or Alt+Backspace to Undo Topics discussed in this video include: excel remove duplicates without shifting excel only include duplicates excel keep duplicates remove unique excel keep duplicates remove everything else excel keep duplicates excel duplicates keep how to get duplicates back in excel can you add duplicates back in excel excel list duplicates between two columns excel remove duplicates using formula excel duplicates remove formula excel...

Mohammad asks: How do we vlookup part of a cell in part of another cell. For example, find "bank of america" in "you have received money from bank of america account". This video shows how to solve this with VLOOKUP, XLOOKUP, and SUMIFS. Topics here: wildcard excel lookup wildcards in excel formula how to use excel wildcards excel how to search wildcards what are excel wildcards wildcards excel search excel wildcard search in formula excel wildcard search not working excel wildcards search microsoft excel wildcards microsoft excel wildcard in formula wildcard not working excel excel wildcards does not work excel using wildcards excel wildcard for text excel wildcards vlookup excel wildcard xlookup excel wildcard zero or more characters...

Vineela is testing if two cells are the same with =IF(A2=B2. Both cells look exactly the same, but Excel is saying they don't match! How to find why they don't match. Table of Contents (0:00) Cells look alike (0:20) =A2=B2 (0:33) Leading spaces (0:45) F2 for trailing spaces (1:20) Length & each character (2:18) MID & ROW (2:50) Five new books (2:59) Get ASCII CODE (3:20) Non-Breaking Space 160 (3:52) Formula to Fix (4:50) Wrap-up

Why Excel SUM is zero. Why Excel Sum function not working. Why Excel SUM returns 0. Why Excel Sum is wrong. Why Excel Sum shows 0. Why Excel Not Showing Sum. Why Excel Sum Formula Not working. Do you have a column of numbers that won't sum in Excel? It is most likely that the numbers have been stored as text. Here are two quick ways to convert those text numbers and the numbers will then sum. One frustrating behavior when this happens: =SUM(A2:A4) is zero, but =A2+A3+A4 calculates correctly. That is because the plus sign coerces a number out of the text, but the SUM function is programmed to ignore text.

Can Excel translate languages? Part 1: There is a built-in Translation tool on the Review tab in Excel. It shows the answers in a task pane, but it does a bad job of getting those answers back to the Excel grid. Five new books were published this summer. Check them out at: Products Part 2: You can use a small bit of Power Query code from Smozgur at MrExcel to solve the problem. Get that code from: Using Power Query in Excel to Translate Data Using the Google Translation API Table of Contents (0:00) Can Excel translate languages (0:24) Translation on Review tab (1:15) Paste back to Excel fails (1:47) Five new books published (3:00) Translating with Power Query (5:12) Wrap-up

Broadway Gypsy asks if there is a way to create a "minute by minute changing up/down stock price arrow in Excel"? In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to the stock prices. He then uses the new Microsoft 365 data types and a tiny bit of VBA code to build a minute-by-minute database of stock prices. Table of Contents (0:00:00) Welcome (0:00:47) Adding Up/Down Arrows (0:03:06) Using Data Types to pull current stock price (0:06:16) VBA to update every minute

Danny from Stuart Florida noticed that when you group all worksheets in an Excel workbook, you can not protect or unprotect the worksheets. This episode offers two very short VBA macros that you can use to unprotect all sheets and then re-protect them with a password.

Holly from Vero Beach gets a report each week with Member ID. She needs to pull in the Member Name from last week's report. This involves doing a VLOOKUP from one workbook to the other - Holly's employers is on Excel 2016 instead of 365.

Laura from Nashville is looking for a way to make sure that all future pivot tables default to having No Subtotals. This *was* a feature in the PowerPivot Add-in back in Excel 2010, but then was removed. However, thanks to Pivot Table Defaults, you can force all future pivot tables into a flat pivot table that is ready for re-use.