MrExcel Excel Videos

Excel IF Contains Excel IF cell contains text Excel IF contains excel like wildcard excel wildcard excel like wildcard if How can you test which cells in Excel contain text? Can you use an IF statement in Excel to find which cells contain certain text? This video looks at COUNTIF, FIND, SEARCH, LOWER, SIGN, ISNUMBER, IFERROR functions. Table of Contents (0:00) Question (0:22) Check for equality (0:41) Wildcards fail in IF (1:05) Using COUNTIF with wildcard (1:39) Using FIND in Excel (2:23) Adding SIGN, IFERROR, LOWER (2:59) Using SEARCH in Excel (3:25) Using ISNUMBER with SEARCH (4:22) Excel IF contains solution (4:44) Finding Contains using Filter (5:11) Nancy Faust

Table of Contents (0:00) Excel shows formula not result (0:04) Cell formatted as Text (0:23) in Show Formulas mode

5 Excel topics in 55 seconds. In this video, I answer five common questions about duplicates in Excel. Table of Contents (0:00) Welcome (0:02) Excel Highlight Duplicates (0:12) Excel Remove Duplicates (0:20) Why Excel highlighting duplicates (0:25) Excel Remove Both Duplicates (0:36) Highlight duplicates but not first

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