Rank and multiple Tie-breaks problem

[knoxy777]

I have 5 columns each containing 7 scores, where only the best 4 score
are used to create a total-at the bottom of each column. For this
used the SUM(LARGE,..,1...)etc.

I then used Rank to rank these scores, with the highest score receivin
the lowest rank.

My problem is that to resolve a tie-break situtation I want to use th
next highest score in the tieing columns to have a unique rank; i
these are equal, then the 6th highest score would be used, and s
on-but only in the columns that are tied.

This sounds simple, and probably is, but I'm no good at VBA and only
beginner in Excel, so I'm really stuck!!:

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/rank.htm
and
http://www.xldynamic.com/source/xld.RANK.html