Category: Excel

Excel Duplicates – 5 Answers in 55 Seconds – #shorts

Posted on by Annie D

5 Excel topics in 55 seconds. In this video, I answer five common questions about duplicates in Excel. This video will address:
excel find duplicates without deleting
can excel find duplicates
excel duplicates find
can i find duplicates in excel
excel remove duplicates without losing data
excel find duplicates in a list
can excel highlight duplicates
excel duplicates highlight
can excel look for duplicates
can excel pick up duplicates
excel recognize duplicates
how to see if duplicates in excel
how to see duplicates in excel column
excel check for duplicates in a list
excel duplicate check
excel check if duplicates in range
excel for duplicates
excel duplicates in one column
excel duplicates color
excel and duplicates
excel duplicates conditional formatting
excel duplicate Continue reading “Excel Duplicates – 5 Answers in 55 Seconds – #shorts” →

Wildcards in Excel VLOOKUP XLOOKUP and SUMIFS – 2512

Posted on by Annie D

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” →

Why Excel SUM is Zero #Shorts

Posted on by Annie D

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 Continue reading “Why Excel SUM is Zero #Shorts” →

Two Excel Cells Look The Same Why Don’t They Match – 2511

Posted on by Annie D

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 – 2510

Posted on by Annie D

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” →

Date & Time Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 05

Posted on by Annie D

Download Excel file: https://excelisfun.net/files/05-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/05-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin.
Topics in video:
1. (00:00) Introduction
2. (01:12) Fundamentals of how Date Values work in Excel, Power Query and the Data Model
3. (04:08) How Date Number Formatting Works
4. (05:38) Date Formulas to calculate the difference between two dates
5. (08:08) Count Workdays. NETWORKDAY.INTL function
6. (10:15) Add or subtract days to get a future date. WORKDAY.INTL function
7. (12:48) Month Date calculations such as determining date by adding or subtracting months with EDATE function or determining end of month by using EOMONTH Continue reading “Date & Time Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 05” →

Excel Mark Each Unique Value In A Different Color – 2508A

Posted on by Annie D

Automatically assign a cell color to each cell based on value. If there are ten unique values in a range, assign ten colors.

I had previously done this using VBA in an old video: “Assign A Unique Color Value”: Podcast #1718 from May 28, 2013.

In this video, I show how it is easier to use DOSE for Excel to color-code each name or value in a range.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel Sum Or Count By Color – 2508

Posted on by Annie D

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

Excel Count Words Characters Or Sheets – 2508B

Posted on by Annie D

How can you count words in Excel? Instead of copying the data to Word, use you can use the DOSE for Excel add-in. In this video, I show you how to:
Count words in a range.
Count characters in a range.
Count worksheets in a workbook.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel How to Add Checkboxes – 2508F

Posted on by Annie D

Sometimes in Excel, you need checkboxes. Many checkboxes.
If you are designing a form and need checkboxes, this video will help.
All the way back in video 1871, I showed one method for getting checkboxes in Excel.
Today, I show how you can do this quickly and easily with the DOSE for Excel add-in.

In a perfect world, those Checkboxes would be tied to a set of cells, so you could use formulas to reach which ones are checked.

Also in this video, how to convert text in cells to an option buttons – this allows people to choose exactly one option, but not Continue reading “Excel How to Add Checkboxes – 2508F” →

Excel Reverse Text in Excel – 2508E

Posted on by Annie D

Back in episode 2444, I had Tommy Tutone singing a crazy formula to reverse text in Excel. Today, a less musical way, but a much easier way.

Using the DOSE for Excel add-in, you can easily reverse text, making “ABCDEF” change to “FEDCBA”. However, Dose does even better, offering an option to take “Jenny Jenny I’ve Got Your Number” and changing it to “Number Your Got I’ve Jenny Jenny”.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose