Hi Aladin,

Thank you very much for your assistance: your Formulae provided the desired
results.

Cheers,
Sam

Aladin Akyurek wrote:
Q2:

=RANK(P2,$P$2:$P$40)

Q3, copied down:

=IF(ISNUMBER(MATCH(P3,$P$2:P2,0)),"",RANK(P3,$P$2 :$P$40))

R1:

=MAX($R$2:$R$40)

R2, copied down:

=IF(N(Q2),RANK(Q2,$Q$2:$Q$40),"")

E50, copied down:

=IF(ROWS($E$50:E50)<=$R$1,INDEX($P$2:$P$40,MATCH( ROWS($E$50:E50),$R$2:$R$40,0)),"")


Aladin Akyurek wrote:
Q2:

=RANK(P2,$P$2:$P$40)

Q3, copied down:

=IF(ISNUMBER(MATCH(P3,$P$2:P2,0)),"",RANK(P3,$P$2 :$P$40))

R1:

=MAX($R$2:$R$40)

R2, copied down:

=IF(N(Q2),RANK(Q2,$Q$2:$Q$40),"")

E50, copied down:

=IF(ROWS($E$50:E50)<=$R$1,INDEX($P$2:$P$40,MATCH( ROWS($E$50:E50),$R$2:$R$40,0)),"")

Hi All,

[quoted text clipped - 5 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com