00:00How to sort fractions in ascending order. To do this, you need to help a column with this formula.
00:06We start with the split function that splits the fraction with a forward slash as a delimiter.
00:10This will return an array of 1 and 10. To get the numerator, we encapsulate the split function with
00:16the index function and get the first element of array, which is going to return the value of 1.
00:21We will use the same technique to get the denominator. If we divide the output of this
00:25two index function like this, we'll get the decimal value for the fraction. Apply the same formula to
00:32the rest of the row. Next, to enable the filter by selecting the cell B4 and go to data, create
00:38a
00:38filter, and sort A to Z on the helper column.
