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

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 duplicates formula
excel is duplicate formula
in excel duplicate formula
excel no duplicates formula
excel Continue reading “Excel KEEP Duplicates Delete Everything Else – 2513” →

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
excel wildcard Continue reading “Wildcards in Excel VLOOKUP XLOOKUP and SUMIFS – 2512” →

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

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: https://www.mrexcel.com/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: https://www.mrexcel.com/board/excel-articles/using-power-query-in-excel-to-translate-data-using-the-google-translation-api.33/

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 Continue reading “Can Excel Translate Languages – 2510” →

Total the numbers in the red cells. Average the cells with green font. While I have previously shown how to do this with VBA, it is now possible to quickly do this using a new add-in called DOSE for Excel.

Use coupon code MrExcel25 to save 25% on DOSE. Shop at https://MRX.CL/getdose