How can i get top 5 salaries in a database

haisubbu · Feb 18, 2006

Any body please help me how to get top 5 salaries from the emp table;

Biff · Feb 18, 2006

Hi!

Salaries in A1:A100

=LARGE(A$1:A$100,ROWS($1:1))

Copy down to 5 cells

Biff