Indent Levels in Excel list of cells (with no VBA) скачать в хорошем качестве

Indent Levels in Excel list of cells (with no VBA)

An alternate to an Excel indent level formula which will enable to match all the cells with the same level and list the levels next to the cells. Useful when using software that exports data to Excel and using indents to show the level and grouping of accounts. ------------------------------------------------------------------------------------------------------------------------------------------------------ ✅- 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 Extract the indent level in Excel cells 00:17 Are indents spaces or actual indents? 00:44 Get the indent level on a single cell 01:28 Indent level on all cells without using VBA 01:55 Using FIND to identify cells with the same indentation level 02:08 FIND the format within a cell with indentation of 2 levels 02:41 List all the cells with level 2 indentation 02:49 Color all the cells with the same indentation level the same color 03:12 Do another find on ALL cells for next indent level 03:45 Color all level 6 indents with a different color 04:15 WARNING- Correct the FIND tool before you proceed 05:20 Put the indent level number in a cell based on matching colors 06:17 VBA can be used