Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in a list box same values should be grouped. Can a tree structure be realized with a formula?
AD-K
AD-K (A)
AD-K (B)
AD-K (C)
AD-K (D)
AD-H
AD-H (S)
AD-H (T)
Regards
Stefan
Yes, i don't want to see AD and AS.
May be this
=If(Len(Trim(Site)) > 0 and Match(Site, 'AD', 'AS') = 0, SubField(Site, ' ', 1) & '/' & Site)
Now it's working fine. Many Thanks for you help.
Also working:
=If(Left(Site,3)='AD-', SubField(Site, ' ', 1) & '/' & Aggr(Only({<site = {'AD-K*', 'AD-H*'}>} Site), Site))