Latest Lists

Excel 2007 - formula to auto rank largest to smallest number?

I've done this before, but can't remember the formula now... What formula do I use so that a column of numbers would automatically list in top down order, largest to smallest, as I enter them? I know about filtering and auto sort, but I want to be able to enter a score next to a name so that as soon as I enter it, it will place that score in the proper rank against others already entered. Thanks so much!

Public Comments

1. Names in col A, scores in col B, C1 =B1+Rows($1:1)/10000 D1 =Large(B:B,Rows($1:1)) format so no decimal points show E1 =Index(A:A,Match(D1,C:C,0)) copy C1 & D1 & E1 down columns