Hallo,
I have a rather tedious job ahaead of me that I would like to automate
as much as possible. I have to calculate the rank of a cell in a
varying number of cells.

Let me explain.
I have a lot of sports results (i.e. speed skating times) without the
position people ultimately ended on. Sometimes there are 20 results,
sometime more, sometimes less. Results are always in a column: e.g.
from b5:b34, or d1:d14 etc

When I want to calculate the rank of each cell I always start with the
cell next to the topcell in the range where the results are (to the
right).

I am not very familiar with making VBA code. I've tried to "record" it
but this didn't work, thereforre my question:
An example of a rank formula I use in cell c3 is:
=Rank(B3;$B$3:$B$6;1)
Is there a way to make this formula automatically, eg by using the
combination <ctrl-shift-Q AND copying this to the range C4:C6?

To make matters worse: sometime the chain of results is broken (empty
cells in the range). Is it possible to stop the code after the
"end-down" bit and give me the possiblity to enlarge the range to rank
and after this to give "return" and the code continious?

Hope somebody can help me.

Thanks for your trouble
Hein


--
Hein
------------------------------------------------------------------------
Hein's Profile: http://www.excelforum.com/member.php...o&userid=24744
View this thread: http://www.excelforum.com/showthread...hreadid=474730