Hi!
I want to rank the values from a2 to a 21 so that the smallest gets 1 to the cell next to it. Same thing in values a22 to a41 and a42 to a61 and so on. How can i do it using the rank function?
Hi!
I want to rank the values from a2 to a 21 so that the smallest gets 1 to the cell next to it. Same thing in values a22 to a41 and a42 to a61 and so on. How can i do it using the rank function?
Try this formula in B2
=IF(A2="","",RANK(A2,OFFSET(A$2,FLOOR(ROWS(A$2:A2),20),0,20),1))
filled down to the end of the data
To do that quickly put formula in B2 and select B2 ....then in the box above A1 type the whole range to fill, e.g. B2:B58000, press ENTER then CTRL+D to fill
Last edited by daddylonglegs; 01-15-2013 at 03:52 PM.
Audere est facere
Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks