Forum Discussion
Modula
May 25, 2022Brass Contributor
Removing rows that contain a number of specific characters anywhere in a cell
How would you remove all rows in a sheet that contain anymore then 5 / in a cell? We're creating a Visio chart of a SharePoint directory that has many folders, however we only need to see the ...
- May 25, 2022
Modula I would use Power Query for such a task. You'll find a working example in the attached workbook.
Riny_van_Eekelen
May 25, 2022Platinum Contributor
Modula I would use Power Query for such a task. You'll find a working example in the attached workbook.
Modula
May 26, 2022Brass Contributor
Wow, thanks a lot
Looks like I will have to get better at Power Query
Looks like I will have to get better at Power Query