Remove rows with subtotals/ totals in Excel data set
на канале: 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
