Custom sort list box

[#1]

Hi,

I have a list box created with an expression =[Product ID] & ' - ' & [Product Description] that has values like

001 - abc

123 - bcs

234 - 276

I want to sort the list box by the product Description in ascending order. Kindly suggest!

Thanks!

[#2]

Sunny, can you explain me why have you sorted the Rank function in descending order rather than ascending?

[sunny_talwar]

Rank function will give a rank 1 to something beginning with Z, rather than something beginning with A.... So to make Z the last, I will have to do descending sort order, right?

[#4]

Thank you Sunny.

[sunny_talwar]

Yup, no problem