MrExcel Excel Videos

subtotal a column in excel how to add subtotal function in excel how to formulate subtotal in excel how to subtotal sum in excel how to use subtotal in excel for sum using subtotals in excel to sum how do you do a subtotal in excel how to automatically subtotal data in excel how to automatically subtotal rows in excel how to calculate subtotals in excel how to insert subtotals into excel excel how to make subtotals excel how to subtotal excel how to use subtotals how create subtotals in excel how do i add subtotals in excel how do i do a subtotal in excel how do i do subtotal in excel how do i use the subtotal command in excel how do you add subtotals in excel how do you get subtotals in excel how does excel subtotal work how does...

can you filter by subtotal on excel? how to keep subtotal in excel when filtered? how do i get a subtotal with filters in excel? how do i subtotal filtered data in excel? how to get subtotal in excel after filter? how to subtotal data in excel with filters? how to subtotal in excel with filters? how to use subtotal in excel with filters?

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 is sorted by date and not by company. Scenario 3: One company can have two amounts. Excel skills: Filter in Excel Testing if this row is the same as the row above in...

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

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 unhide rows in an excel spreadsheet how do i unhide rows in excel how do you unhide excel rows how do you unhide lines in excel how do you unhide rows and columns in excel how do you...

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 1 in excel how to unhide row a1 in excel how to unhide rows 1 and 2 in excel how to unhide rows at the top of excel how to unhide rows at the top of excel sheet how to unhide rows at top of excel how to unhide rows at top of excel sheet how to unhide...

How to unhide a specific row in Excel. can you unhide a specifc row in excel excel how to unhide a specific row how do you unhide specific rows in excel how to unhide a specific row in excel how to unhide certain rows in excel how to unhide selected rows in excel how to unhide some rows in excel how to unhide specific rows in excel how to unhide a few rows in excel how to unhide a group of rows in excel how to unhide a range of rows in excel

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 excel how to unhide all rows in excel how to unhide all columns and rows in excel how to unhide all hidden columns / rows in excel how to unhide all in excel row how to unhide all of the rows in excel how to unhide all...

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 with the subtotaled amount. This is way too many steps!! I have two solutions in today's video: 1) Subtotal by ID and use Select Visible Cells to pull the Name down into the subtotal row 2) Use Excel Power Query...