order can be used (that little button with an A and Z) to excel to sort information from highest to lowest or vice versa, this is a manual process which is not bad, but can also be done differently using LARGE and SMALL functions to excel.
The syntax of these functions is as follows:
LARGE (array, order)
SMALL (array, order)
Where
matrix refers to a set of selected data. For example if you use the LARGE function of a set of data and select the item you want to order 1, because this will be the largest data set and if you want the element of order 2, it will return the most value that follows the first and so on. Something similar happens with the SMALL function.
In the attached excel can see how these two functions are used.
0 comments:
Post a Comment