Remove rows with subtotals/ totals in Excel data set
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
A quick way to remove all the rows that contain sub totals in a data set. Sub Totals will cause problems when using things like Pivot Tables so it is generally better to get back to the raw data.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Remove all rows with sub totals in them
00:12 Apply the filter
00:28 Look for the unique aspect to identify the sub total rows
00:53 Remove the subtotals to be left with only the raw data
Watch video Remove rows with subtotals/ totals in Excel data set online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 15 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,775 once and liked it 3 people.