If you are interested in downloading a 29 KB Excel 2010 sample file go to my Download page, please.
If you have a huge file with plenty of data you can minimise the runtime by creating a sorted list of unique entries (do not take my UDF GSort - take Excel's internal sort) and then match all input values: In cell D2 you would enter
and copy down. To inverse the rank order you just need to sort the unique entries descending - but keep in mind that you need to change the last parameter of MATCH to -1!
Other rank solutions I present here.