Excel Tip: Rank Function

News User Comments History Notify Me

9/25/2009 12:18:42 PM
Excel Tip: Rank Function
By Richard Rost

This week's new Excel Tip shows you how to use the RANK function in Excel to automatically rank a list of items. For example, we'll rank our monthly sales figures from 1 to 12.

/tips/excel/rank-function

Enjoy.

Permanent Link
Keywords: excel tips rank function

Post Reply

Reg Rank function Comment from UP @ 12/5/2010

Sir, The rank function example as shown to us by you at "http://599cd.com/tips/excel/rank-function" skips rank 11 or supposed to skips some ranks when two numbers are equal and they got equal rank.

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 2+1:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard