custom sort in list box

[everest226]

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 .

[Anil_Babu_Samineni]

May be use descending number

[surendraj]

do u want to remove caption?

[vvvvvvizard]

maybe sort by expressing , ascending , if(Match(Name,'NO Name, 'Alex','Bam','Cat')

[everest226]

wont work because i have some name that comes after  n  also

[surendraj]

Properties-->Sort-->text-->Z-A

[everest226]

wont work some names are after no names also. just want no name at y top then ascending order

[Anil_Babu_Samineni]

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

[surendraj]

Go with Yusuuf Answer!!it works by custom sort only.

[trdandamudi · Accepted solution]

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)