Category: Excel

Excel Remove Duplicate Amounts But Do Not Remove Rows 2382

Posted on by Annie D

Michelle asks this Excel question:
Is there a way to clear duplicate data in Excel but keep rows. Do not delete or remove the rows.

For example column A has company name. Column B has many dates. The amounts in column C are the same for each company. I need to keep the amount in the first row but clear the amounts in all the subsequent rows for that company.

Michelle has over 100K rows and manually deleting amounts is breaking her mind and body.

This video shows three solutions.
The easiest: data is sorted by company and the amounts never change.
Scenario 2: The data Continue reading “Excel Remove Duplicate Amounts But Do Not Remove Rows 2382” →

Shortcut To Hide or Unhide Rows or Columns In Excel

Posted on by Annie D

easiest way to unhide rows on excel
how do you quickly unhide rows and columns in excel
how do you unhide rows in excel quickly youtube
how to easily unhide rows in excel
how to hide and unhide columns rows excel shortcut
how to unhide all rows in excel shortcut
how to unhide rows in excel shortcut
how to unhide rows in excel shortcut key
how to unhide the rows in excel keyboard shortcut
quick way to unhide rows in excel
how to quickly unhide rows in excel
how to unhide rows excel shortcut

How To Unhide Multiple Rows In Excel

Posted on by Annie D

can you unhide multiple rows in excel
easy way to unhide multiple rows in excel
excel how do i unhide lines
excel how to unhide collapsed rows
excel how to unhide rows when hidden
how can i unhide rows from excel
how can i unhide rows in excel
how do i get lines to unhide excel
how do i unhide lines in excel
how do i unhide lines in excel spreadsheet
how do i unhide multiple rows in excel at one time
how do i unhide multiple rows in excel spreadsheet
how do i unhide multiple rows on excel
how do i unhide row in excel
how do i unhide rows excel
how do i Continue reading “How To Unhide Multiple Rows In Excel” →

How To Unhide Top Row In Excel

Posted on by Annie D

excel how to unhide top row
how do i unhide row 1 in excel
how do i unhide rows at top of excel sheet
how do i unhide rows in excel that are at the top
how do i unhide the first row in excel
how do i unhide the first row in excel?
how do i unhide the top rows in excel
how do i unhide top rows in excel
how do i unhide top rows in excell
how do you unhide first rows in excel
how to unhide a top row in excel
how to unhide first row in excel
how to unhide first rows in excel
how to unhide row Continue reading “How To Unhide Top Row In Excel” →

How To Unhide All Rows In Excel

Posted on by Annie D

Short video showing how to unhide all rows in Excel.
excel how to easily unhide all rows
excel how to unhide all columns and rows
excel how to unhide all rows in one
excel how to unhide all the rows
how can i unhide all rows in excel
how can you unhide all rows in excel
how do i unhide all rows in excel?
how do i unhide all rows on excel
how do i unhide row all rows in excel
how do you unhide all excel rows and colums
how to get excel to unhide rows at once
how to quickly unhide all rows in excel
how to unhide al rows in Continue reading “How To Unhide All Rows In Excel” →

Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1819.xlsx
The best Excel formulas are not always what they seem. In this video: learn the best ways to create counting formulas in Excel using COUNTIFS, FILTER and SUM( IF ). Learn both Microsoft 365 Excel formulas and formulas that will work in any version of Excel.
Topics:
1. (00:00) Introduction
2. (00:14) COUNTIFS for counting customers who paid Cash. (Single Condition)
3. (01:07) AND Logical Tests. OR Logical Tests. And what is required in counting formulas.
4. (01:32) COUNTIFS for counting customers who spent less than $50 and paid with PayPal. (AND Test). Learn about two ways to enter Continue reading “Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819” →

Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1818.xlsx
Learn about how to create a joint probability table from a cross tabulated frequency distribution, then five tricks for calculating probabilities. Everyone should know this – not just staticticians.
Topics:
1. (00:00) Introduction
2. (00:04) Calculate Joint Probability Table from Cross Tabulated Counts with Excel Formulas.
3. (02:55)Makes probability calculations from a Joint Probability Table.
4. (03:14) Single Conditional Probability
5. (03:27) AND Logical Test Probability (Joint)
6. (03:49) OR Logical Test Probability (Mutually Exclusive)
7. (04:20) OR Logical Test Probability (NOT Mutually Exclusive)
8. (05:02) Conditional Probability
9. (05:40) Closing, Video Links

#excel
#excelisfun
#excelformulas
#excelfunctions
#dynamicarrays
#array #arrayformula
#statistics
#excelsolutions
#joint
#probability
#probabilitytricks Continue reading “Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818” →

Excel Subtotal By ID And Name 2381

Posted on by Annie D

Kara asks: Do you have a trick for the subtotal function?
In a “subtotal by” task where I use three fields (ID / Name / Amount) to get the total amount, Excel makes me choose between ID or Name for “at each change in” but I’d like to retain both so I currently perform data gymnastics to concatenate the ID and Name fields…..and then after using the function, I perform more gymnastics after selecting level 2, “go to special” / visible cells only on the subtotals, paste to another sheet, and then split the ID and name back out Continue reading “Excel Subtotal By ID And Name 2381” →

Excel Select All Formulas And Their Precedents – 2380

Posted on by Annie D

Harsinchh asks if there is a way to highlight all formula cells and the precedents of those formulas. There are a lot of techniques discussed in this video:
Show Formulas in Excel
Select all Formulas in Excel
Go To Special Precedents in Excel
Direct versus All Precedents in Excel
VBA to select formulas in Excel
VBA to select precedents in Excel
VBA to union two ranges in Excel

Table of Contents
(0:00) Excel: Select Formulas & the precedents
(0:25) Excel Show Formulas
(0:55) Selecting all Excel Formulas
(1:16) Selecting Formula Precedents with Go To Special
(1:40) All Precedents versus Direct Precedents
(2:52) Four-step is a kludge
(3:08) VBA Macro to select formulas and precedents
(4:49) Personal Continue reading “Excel Select All Formulas And Their Precedents – 2380” →

Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_

Posted on by Annie D

Free Classes & Videos on the home page of my excelisfun channel: https://www.youtube.com/@excelisfun
This video introduces you to the excelisfun channel at YouTube, where you can learn anything would want about Excel and Power BI. My name is Mike Girvin. I am a professor at Highline College and a Microsoft Excel MVP since 2013. I have posted over 3,500 videos and created over 100 playlist of videos since Feb 2008 here at YouTube. The Home page: youtuve.com/@excelisfun , has full free classes in: 1) Microsoft 365 Excel/Power BI, 2) Basic and Advanced Excel, 3) Basics and Advanced Data Continue reading “Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_” →

Excel Replace Is Breaking VLOOKUP – 2379

Posted on by Annie D

Rich needs to VLOOKUP into data with ” Total” after the tracking number.

When he tries to Replace ” Total” with “”, Excel converts the tracking numbers to scientific notation. When he tries to convert everything to numbers and I lose the last several digits when they change to 0000.

In today’s video, a new option in Microsoft 365 beta to prevent the conversion to scientific notation. And then a way to hack the VLOOKUP formula.

Table of Contents
(0:00) Copy subtotals in Excel
(0:36) Replace in Excel converts to Scientific Notation
(0:54) Long numbers in Excel last digits change to zero
(1:09) Beta option Continue reading “Excel Replace Is Breaking VLOOKUP – 2379” →