| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i get top 5 salaries in a database
Any body please help me how to get top 5 salaries from the emp table;
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i get top 5 salaries in a database
Hi!
Salaries in A1:A100 =LARGE(A$1:A$100,ROWS($1:1)) Copy down to 5 cells Biff wrote in message oups.com... Any body please help me how to get top 5 salaries from the emp table; |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total Sales from a Database | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Links to External Database | Excel Discussion (Misc queries) | |||
| The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
| Graphing Database Growth Rate | Charts and Charting in Excel | |||
Linear Mode
