Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to create a list box where i want to list only some values using set analyis in searching text. I've tried to use concat since Maxstring gives me only 1 value, i need a list of value,
=concat({<Code={"AB/123/1_G*"},Dimension1={'80'}>} Code,'')
but i don't obtain what i need.
Can you help me?
Hi Anna,
Try like this
=Aggr(Only({<Code={"=Left(Code,10) ='AB/123/1_G'"},Dimension1={'80'}>} Code),Code)
Regards,
Antonio
Hi Anna,
Try like this
=Aggr(Only({<Code={"=Left(Code,10) ='AB/123/1_G'"},Dimension1={'80'}>} Code),Code)
Regards,
Antonio
Thank you Antonio, i know there was something i missed.