I have a set of numbers for which I want to assign ranks based on their values. The smallest value will get a rank of 1 and the larger values on an ascending order. Is there any way this can be accomplished in Excel? Please let me know.Thanks.