By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order. To see how to avoid ranks that are the same visit http://www.auditexcel.co.za/blog/how-to-rank-items-that-have-the-same-rank/ or http://www.auditexcel.co.za/blog/how-to-avoid-the-rank-function-finding-equal-results/ )