| You are here: | About>Computing & Technology>Spreadsheets> Functions in Excel> Excel SMALL Function - Excel 2007 SMALL Function |
![]() | Spreadsheets |
![]() Excel 2007 SMALL 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 SMALL FunctionThe SMALL function, one of Excel's statistical functions, can be used to find data based on relative size.
The syntax for the SMALL function is: = SMALL ( Array , K )
Array - the array or range of cells containing the data to be used in the function. K - the Kth smallest value, such as the third smallest value, that is being sought.
Example Using Excel's SMALL 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 Related ArticlesExcel Function - Excel CONVERT Function - Excel 2007 CO...COUNTBLANK - Excel 2007 COUNTBLANK - Excel COUNTBLANK F...COUNTIF - Excel 2007 COUNTIF - Excel COUNTIF ExampleAVERAGE IF - Excel 2007 AVERAGE IF - How to Use Excel A...QUOTIENT Function - Excel QUOTIENT Function - Use the E... |
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. |



