How to use the RANK and SUMPRODUCT functions in Excel with COUNTIF
sort items in ascending or descending order using a combination of the relatively simple countif, rank.eq, and sumproduct functions. you can sort items with or without duplicatesNew Ranking functions in SQL Server 2005
along with sql server 2005, microsoft introduced a number of new features and these features will make it easier for dba or sql server specialists to code and maintain sql server