You can generate the sequence

with something like

=row(1:1000)

for example, in a new cell put in

=row(1:100)

then select row(1:100) and hit F9. then escape to return to the formula.

If can be made dynamic. Put some data in A1:A15, then enter this formula
elsewhere:

=row(indirect("1:" & counta(A1:A100)))

Now select
row(indirect("1:" & counta(A1:A100)))

and hit F9.

Actually, I was going to ask if you could use a dummy column - it is
certainly easier - much simpler I think you will agree.

--
Regards,
Tom Ogilvy


"sa02000" wrote:

>
> I created a dummy column with this formula
>
> =IF(E2>=1000,RANK(E2,$E$2:$E$122,0)+RANK(I2,$I1:$I$122,0)/100,RANK(I2,$I$2:$I$122,0)+RANK(E2,$E$2:$E$122,0)/1000+COUNTIF($E$2:$E$122,">=1000"))
>
> and then ranked this dummy column to get my actual ranking
> =RANK(K2,$K$2:$K$122,1)
>
> I used help from this page by chris Pearson....
> http://www.cpearson.com/excel/rank.htm
>
> Thanks for all those who replied to this and other similar posts.
>
> Jay
>
>
> --
> sa02000
> ------------------------------------------------------------------------
> sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
> View this thread: http://www.excelforum.com/showthread...hreadid=533404
>
>