Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i have list box (Name) , there is a value , in ascending like , Alex , Bam, Cat, NO name, sdd, hjsgdh ,,zzz,, etc
I want to show no name on top .
One way to do this is as below:
Expression:
=Pick(Match(Name, 'NO name')+1, Name ,'NO name')
Sort Expression:
=Pick(Match(Name, 'NO name'),1,2)
May be use descending number
do u want to remove caption?
maybe sort by expressing , ascending , if(Match(Name,'NO Name, 'Alex','Bam','Cat')
wont work because i have some name that comes after n also
Properties-->Sort-->text-->Z-A
wont work some names are after no names also. just want no name at y top then ascending order
Not sure, How many values under this field. And ext. could be use Sort by expression with Match(FieldName, 1,2,3,4)
Here - 1,2,3,4 are the values you want to sort If values has less rows
Go with Yusuuf Answer!!it works by custom sort only.
One way to do this is as below:
Expression:
=Pick(Match(Name, 'NO name')+1, Name ,'NO name')
Sort Expression:
=Pick(Match(Name, 'NO name'),1,2)