I'm trying to rank numbers that contain decimals, example starting with 100 to be ranked as 1 and the rest in descending order, such as 99.5, 98.7, 80.2, 50.1, etc. There are also more than one of several numbers, such as 3 that are 50.1 as an example. Using the Excel help I get the idea that I should use RANK.EQ as the function and they give an example for tie breakers. but it doesn't seem to work with decimal numbers. Is the RANK function for whole numbers only????? If so, is there any other functions to use to rank decimal numbers. The reason I'm using decimal numbers is because there would be many replicates of the same whole number and the ranking seems to be useless then. Any help would be greatly appreciated.