On 10.09.10, In Ranking numbers made easy by using Microsoft Excel.
Even how plenty are your numbers to be ranked, excel can do it in an instant. You just have to enter all the numbers you need to rank. By doing that simply open Microsoft Excel. You can copy or type in there the data needed.
Well begin here, select or click the first number.
Then, type equal sign =
Click fx (this is usually located at the side of the = sign you recently typed.
After hitting fx, select a category. You have to look for the word RANK.
When you are able to find the RANK, click OK. After this, another box will appear.
The box is about Function Arguments.
Below that are 3 spaces namely: Number, Reference, and Order.
Beside NUMBER, enter the cell number of the first data.
Then go to REF, this time, highlight all the numbers you want to rank.
Click OK, and you’ll see the rank of the first number.
To see the rank of the rest of the data, drag the result down and you’ll get each rank in an instant.
Below is a youtube video where a live explanation is taken.
Nice Share.
$- good work-$
Thank you for visiting and for your comments!
Nice Share.j
It’s is so true . Excel is a tool that can make our life easier. I am using also in the office.
very helpful and informative article. thanks for sharing. i enjoyed it all.
Pretty good trick with related video… good job!
Nice Post
I’m glad you find it useful and interesting. Thank you for dropping by. See you around.
haha sounds very difficult. huhu