Rank added using autofill

March 9, 2012 at 10:25:05
Specs: Windows 7
Numbers are already sorted large-small.
Need to rank 1-13 using autofill. ?????

Rank State Mwe
Nevada 102800
Idaho 67900
Oregon 62400
New Mexico 55700
Arizona 54700
Colorado 52600
California 48100
Utah 47200
Montana 16900
Washington 6500
Wyoming 3000
Hawaii 2625
Alaska 2355


See More: Rank added using autofill

Report •

#1
March 9, 2012 at 10:40:28
First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to post data in this forum so that it will look like this:

    A           B                     C  
1 Rank        State                  Mwe
2             Nevada               102800
3             Idaho                 67900
4             Oregon                62400
5             New Mexico            55700
6             Arizona               54700
7             Colorado              52600
8             California            48100
9             Utah                  47200
10            Montana                6900
11            Washington             6500
12            Wyoming                3000
13            Hawaii                 2625
14            Alaska                 2355

Try this in A2 and drag it down:

=RANK(C2,$C$2:$C$14)

BTW...there is no need to Sort the data before using the RANK function, so I'm not sure why you mentioned that.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question