Forum Discussion
Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/map...
Excel formula approach.
=UNIQUE(LET(x,REGEXREPLACE(A2.:.A5000,"[0-9]",""),IF(RIGHT(x,1)="/",LEFT(x,LEN(x)-1),x)))