We able to automate some of the frequently used options. In this tutorial we are going to see the way to sort a data set automatically using VLOOKUP and RANK functions. This is a special video for my friend Ravi who asked this doubt to me.
You will learn the following methods in this Excel tutorial:
Watching this tutorial teaches you the basic concept of sorting data from an Excel data sets
for practice
You should have noticed the followings in the previously learned “How to sort Data Automatically in PART 1” tutorial.
Watching this tutorial teaches you the solution of the above listed issues.
The above two concepts can be used in the older version of Excel, so you should learn those concepts if you have only the older version of Excel.
Do you feel that the above said concepts are boring and more formula intensive one. Then the Sorting concept is more easy with Office 365. Yes if you have the latest version of Excel the sorting concept is very easy. Lets learn the simple method in the following tutorial.
The SORT function sorts the contents of a range or array. Unless the old concepts, this is new, fresh, efficient & quick. Lets understand the structure of this formula.
=SORT(array,[sort_index],[sort_order],[by_col])
To understand the Sort function effectively, a live demonstration should be needed. Practice file is also given with this article. So practice it along with the tutorial.
for practice
Hope you learned all the concepts and mastered in Sorting concept.