We kow that Max() & Min() Functions will give us the highest and lowest value of range of value.But how can we Know the Top 10 or the least 10 Values?

In excel home tab, Select Conditional Formatting, after select Top/Bottom rules.

I hope, it will work.

Go to "Home - Conditional Formatting - Top bottom rules. 

 :OPEN THE FLOW LINK

http://www.accountingweb.com/technology/excel/identifying-largest-and-smallest-values-in-an-excel-list

http://www.addictivetips.com/microsoft-office/find-max-min-values-in-excel-2010/

My Solution By Using 2 Function To achieve this :

1- large(array,Rank)

2- Small(array,Rank)

Example:

=LARGE(A1:A5,4) will return the fourth top value of array of data

=small(A1:A5,4) will return the fourth least value of array of data