| You are here: | About>Computing & Technology>Spreadsheets> Functions in Excel> Excel RANK - Excel 2007 RANK Function |
![]() | Spreadsheets |
![]() Excel 2007 RANK function © Ted French Free Excel 2007 Chart TutorialsExcel 2007 Pie Chart TutorialExcel 2007 Column Chart TutorialExcel 2007 Line Graph Tutorial Excel 2007 Functions and FormulasExcel 2007 Formulas Step by Step TutorialExcel 2007 IF FunctionExcel 2007 SUM Function Excel 2007 RANK FunctionThe RANK function, one of Excel's statistical functions, ranks the size of a number compared to other numbers in a list a data.
The syntax for the RANK function is: = RANK ( Number, Ref, Order )
Number - the cell reference of the number to be ranked. Ref - the range of cells to use in ranking the Number. Order - determines whether the Number is ranked in ascending or descending order. Type a "0" (zero) to rank in descending order (largest to smallest). Type a 1 to rank in ascending order (smallest to largest).
Example Using Excel's RANK Function:
Note: For help with this example, see the image to the right.
Related Articles Free Excel 2007 Chart TutorialsExcel 2007 Pie Chart TutorialExcel 2007 Column Chart TutorialExcel 2007 Line Graph Tutorial Excel 2007 Functions and FormulasExcel 2007 Formulas Step by Step TutorialExcel 2007 IF FunctionExcel 2007 SUM Function |
Las Vegas on a BudgetFind a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less |
All Topics | Email Article | | | ![]() |
| Advertising Info | News & Events | Work at About | SiteMap | Reprints | Help | Our Story | Be a Guide |
| User Agreement | Ethics Policy | Patent Info. | Privacy Policy | ©2008 About, Inc., A part of The New York Times Company. All rights reserved. |



