Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a number in feet inches and fractions of and inch | Excel Worksheet Functions | |||
How tp display fractions / custom number | Excel Worksheet Functions | |||
Whole number from fractions | Excel Worksheet Functions | |||
How do I round up fractions to the next whole number? | Excel Worksheet Functions | |||
How do I sort a column consisting of fractions, decimals, and who. | Excel Discussion (Misc queries) |