May 24 2022 08:57 PM
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 first few layers. Otherwise it tries to chart nearly 4000 folders
e.g
The below layer is fine
teams/accounts/Shared Documents/affiliates/processes/subprocesses
But to remove any row that has anything more than that
teams/accounts/Shared Documents/affiliates/processes/subprocesses/thing1/thing2/thing3/....
If a row has a cell that has a directory than has more the 5 / it needs to go.
Is there anyway to achieve this automatically?
Thanks
May 25 2022 12:37 AM
Solution@silaman I would use Power Query for such a task. You'll find a working example in the attached workbook.
May 25 2022 07:07 PM
May 25 2022 12:37 AM
Solution@silaman I would use Power Query for such a task. You'll find a working example in the attached workbook.