Hi Matt,

Tried the alternate row 100, same result.

This is the formula in row 5, with B1 being as follows -
=IF(ISERROR(RANK(B4;B4:AI4;1));"";(RANK(B4;B4:AI4; 1))) - which is array, and
simply ranks row 4, ignoring any blanks.

Row 1 has a formula which just brings the name from the input page to the
output/presentation page, and B1 is as follows - ='THIS WEEK'!C86

Kind regards
David

"GoBow777" wrote:


dartanion;601540 Wrote:
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
-

Dartanion:

Hmm. Ya, I guess Im confused. When you say
€œpositions€�, I assumed row 5 is populated with number
values, is this correct? If not, what determines the ranking of those
positions?

Any way, try this formula in place of the one in row 100.


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




--
GoBow777