Creating a Special Ranking System in Microsoft Excel.

Posted on February 15, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

This next Excel Tip and Trick is a pretty cool one and also a very useful one.

What you can do in MS Excel is create a column with certain values and manually sort it and you could create some sort of a ranking when you’ve added an extra column. This might work although it’s not the easiest way. This Trick isn’t working when the column contains double values.

Use this Excel Tutorial to Create a Special Ranking System.

First you need to create a Spreadsheet similar to the one below.

Excel-tip-trick-pic1

Select Cell A2 and type in 1 and press Enter
Now select Cell A2 again
Go to the data menu
And click on the Sort Ascending icon.

Excel-tip-trick-pic2

Now select the Cells B3:B12
And Type in the following formula =B2+(A2<A3)
And Press CTRL+ENTER

Excel-tip-trick-pic3

And your whole column should be ranked.

I hope you all liked this week’s Microsoft Excel Tips and Tricks. And I hope even more that you all have a great weekend, I’ll talk to you all on Monday, see you!!

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.