S surveyer Apr 17, 2009 #1 How can i sort this 1/1 1/2 10 191/2 2 201 202/5 280 3 3/2 to this 1/1 1/2 2 3 3/2 10 191/2 201 202/5 280? Please help!
How can i sort this 1/1 1/2 10 191/2 2 201 202/5 280 3 3/2 to this 1/1 1/2 2 3 3/2 10 191/2 201 202/5 280? Please help!
S Stefi Apr 17, 2009 #2 If you have these values in column T from T1 down then enter formula =VALUE(LEFT(T1,IF(ISERROR(SEARCH("/",T1)),LEN(T1),SEARCH("/",T1)-1))) in U1, select range T1:U10 and sort selection by column U (choose no header)! Regards, Stefi „surveyer†ezt Ãrta:
If you have these values in column T from T1 down then enter formula =VALUE(LEFT(T1,IF(ISERROR(SEARCH("/",T1)),LEN(T1),SEARCH("/",T1)-1))) in U1, select range T1:U10 and sort selection by column U (choose no header)! Regards, Stefi „surveyer†ezt Ãrta:
