Skip to Content
0
Former Member
Apr 24, 2007 at 09:55 PM

Sort logic

13 Views

Hi,

I have the following known values on the left hand side

1----


(1)

10----


(5)

10.5-------(6)

1.5----


(2)

2----


(3)

2.5----


(4)

and would want to give a number in parentheses to the corresponding number on the left hand side, so when sorting the number in parentheses the number will be sorted in the following order:

1----


(1)

1.5----


(2)

2----


(3)

2.5----


(4)

10----


(5)

10.5----


(6)

How would I write a logic to assign the numbers in paraentheses to the number on the left hand side?

Thanks