ExcelBanter - sort number with fractions

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - sort number with fractions (https://www.excelbanter.com/new-users-excel/227979-sort-number-fractions.html)

surveyer

sort number with fractions

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!

Stefi

sort number with fractions

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:

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!

All times are GMT +1. The time now is 12:46 AM.