Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display a number in feet inches and fractions of and inch Michael Peace[_2_] Excel Worksheet Functions 1 April 15th 09 11:34 PM
How tp display fractions / custom number Diane Excel Worksheet Functions 2 December 22nd 06 10:57 PM
Whole number from fractions Jim Excel Worksheet Functions 1 October 22nd 06 04:19 AM
How do I round up fractions to the next whole number? JHL1927 Excel Worksheet Functions 4 October 27th 05 10:35 PM
How do I sort a column consisting of fractions, decimals, and who. Split Window Diner Excel Discussion (Misc queries) 4 May 16th 05 05:51 PM


All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"