Question

Data can only be sorted from the smallest to the largest value

Answer 1

Answer:

no it's not necessary

Explanation:

computer can store all types of data or software

Answer 2

Explanation:

To dynamically sort a list of numbers in ascending order, you can a simple formula based on the SMALL function with an expanding range. In the example shown, the formula in cell C5 is:=SMALL(data,ROWS($B$5:B5))

where "data" is the named range B5:B14

How this formula works

The SMALL function is meant to extract the "nth" smallest value from a set of data. The value for N is supplied as the second argument. To get the smallest value with SMALL, supply 1, to get the second smallest value, supply 2, and so on.

=SMALL(data,1) // 1st smallest

=SMALL(data,2) // 2nd smallest

=SMALL(data,3) // 3rd smallest

In the example shown, "data" is the named range B5:B14. In this example, the main challenge is to increment a value for nth. This is done by using an expanding range inside the ROWS function: