Sort textual fractions as per numerator only

[ElmerS]

Hi,

How can I sort the range B2:B7 to get range C2:C7 as the result ?

As always, I will appreciate minimum Formulas not to mention Helper columns, VBA etc...

If helper column(s) is a must - then the fewer the better.

Thanks, Elm

[shg]

=LEFT(A2, FIND("/", A2 & "/") - 1) and sort on that.

[DonkeyOte]

Using the specifics of the example (and as usual in no way intended as advised)

B2: =SUBSTITUTE(SMALL(0+SUBSTITUTE($A$2:$A$7;"/";",");ROWS(B$2:B2));",";"/")
confirmed with CTRL + SHIFT + ENTER
copied down

(note I used , as decimal separator)

[Marcol]

Try in C2

Please Login or Register  to view this content.

Fill / Drag down

Then sort

This can be done with a macro to remove the helper column if you wish.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[ElmerS]

Thanks all three of you,

I will adopt DO suggestion because it sorts the result values - eliminating the need to sort the source values as per the other two formulas.

Elm