odd number format sorting
I have some data that has in invoice number that looks like:
10-195,265-195,360-105
when i sort this column, i want it to sort before the dash first and then after, so ascending would be:
10-195,265-195,360-105
descending would be:
360-105,265-195,10-195
anyone know how to do this?
can i set a custom sort function to a column or something?
10-195,265-195,360-105
when i sort this column, i want it to sort before the dash first and then after, so ascending would be:
10-195,265-195,360-105
descending would be:
360-105,265-195,10-195
anyone know how to do this?
can i set a custom sort function to a column or something?
Jonathan Doklovic
February 6,