ok i can't figure out this step i need to do. heres what they are telling me to do:


Using the columns we created, we want to list each
the number of dogs registered (e.g., the breed with the most dogs registered
will be ranked as #1).
a. In cell D4, use the RANK() function to determine the ranking of the
Affenpinscher breed in 2003 registrations. Use AutoFill to copy your
formula to all other breeds for 2003 (cells D5 through D157).
b. Copy your formula for figuring 2003 rankings to calculate 2004 rankings
(column F) and 2005 rankings (column H).


i just cant get the rank function figured out on this

and heres a picture of the table set up

http://www.profuseimage.com/out.php/i8907_Untitled.jpg

any help would be appreciated. thanks.