excel automatically fill in place

A1 = 55, A2 = 36, A3 = 78, A4 = 20 ,……to the B list are automatically fill in the corresponding high and low points, the first, second, third ……How

you to use a few examples, the ranking of that region (A1:A4), and so on, insert the name of the custom , Type out the name (for example:total), to determine.B1 in the input = RANK (A1, total), you can enter.A first list of high-to low-ranking, and then in the B shortcut to fill out with B1 input into the ranking formula:”= RANK (A1, $ A $ 1:$ A $ 4)”, the B1 to copy the formula down.
Attention:”$ A $ 1:$ A $ 4″ absolutely must address, or else Copy the formula would produce an error.
Meaning:the return of “A1” in the number of A1 to A4 in the number of these rankings.Scores of A1-A50 in there, B1 enter
= rank (A1, $ A $ 1:$ A $ 50,0)
drag b1 fill handle.Ok! Note that all of English punctuation.
$ Is fixed to the region, do not drag back to the change in the absolute path is the smallest .0 is, if the writing is a small to large.

Leave a Reply