Hi All-
I am looking for an answer to something that seems relatively simple. I have a formula that I would like to drag across horizontally or across the columns and have it increase or change in a similar fashion to if I was to drag vertically.
In cell B2 I have the formula =RANK(Results!B3,Results!B3:Results!F3)
When I drag horizontally I would like it to change to
=RANK(Results!B4,Results!B4:Results!F4)
=RANK(Results!B5,Results!B5:Results!F5)
=RANK(Results!B6,Results!B6:Results!F6)
etc....
I have tried several different things, such as Paste Special and Transpose, adding $'s to make the formula absolute and lots of Google searching.
Hope I was clear. Any and all help is greatly appreciated!! Thank you!
Bookmarks