Hi Matt,

Part 1 worked, no problem.

Parts 2 and 3 display#VALUE!

I changed only the ,s to ;s as my excel is set up on continental settings. I
tried both enter and ctrl-shift-enter, but both came up with the same error.

Hope you can come up with a fix.

Kind Regards

"GoBow777" wrote:


dartanion;600980 Wrote:
I want to display a league table showing first 5 names and their
positions in
asscending order.

Paste this formula in cell B100 and copy across to cell AI100.


Code:
--------------------
=IF(B5="","",RANK(B$5,$5:$5,1)+COLUMN()/100000)
--------------------


Paste this formula in cell G8 and copy down.


Code:
--------------------
=IF(ISERR(LARGE($100:$100,ROW(1:1))),"",OFFSET($A$ 1,0,MID(LARGE($100:$100,ROW(1:1)),FIND(".",LARGE($ 100:$100,ROW(1:1))),6)*100000-1))
--------------------


Paste this formula in cell H8 and copy down.


Code:
--------------------
=IF(ISERR(LARGE($100:$100,ROW(1:1))),"",OFFSET($A$ 1,4,MID(LARGE($100:$100,ROW(1:1)),FIND(".",LARGE($ 100:$100,ROW(1:1))),6)*100000-1))
--------------------


Matt




--
GoBow777