Quote:
Originally Posted by dartanion
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
|
OK dave, I think I have a better understanding.
Delete the contents of row 100 and replace the formula in row 5 with this one.
Code:
=IF(B4="","",RANK(B$4,$4:$4,1)+COLUMN()/100000)
Paste this formula in cell G8 and copy down.
Code:
=IF(ISERR(SMALL($5:$5,ROW(1:1))),"",OFFSET($A$1,3,MID(SMALL($5:$5,ROW(1:1)),FIND(".",SMALL($5:$5,ROW(1:1))),6)*100000-1))
Paste this formula in cell H8 and copy down.
Code:
=IF(ISERR(SMALL($5:$5,ROW(1:1))),"",OFFSET($A$1,0,MID(SMALL($5:$5,ROW(1:1)),FIND(".",SMALL($5:$5,ROW(1:1))),6)*100000-1))
Matt