How to use countif function for ranking numbers.

Please refer attachment for an example.

Or suggest any other function to perform this operation.New Picture111.jpg