Hi I'm new here and I have the following problem: I have a sheet with approximately 72 companies and each day I update it with their respectively sales quantity obtaining the total number of items sold since the beginning of the month for each of them. I would like to create a new sheet in the same Workbook that could rank which companies are selling more until the moment (it needs to show the names of the companies in a descending order with the respectively total items). Until now I'm using the function =RANK() that returns the rank of total items sold in a list of numbers, the problem is that it's hard to find in which position is each company looking to the classification (numbers) obtained by the function above, so it would be nicer if it showed the name of these companies in the ranking instead of the numbers created by =RANK().


Thanks in advance