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 duplicates
Tags : rank
New 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