I have to say that when I see this many Arrays I always tend to look for alternative approaches that may be more efficient in the long run (though less elegant), for ex. you could do something like:
The abvoe restricts the range being reviewed in each formula (ie only looking at individual chunks of data based on assumption that Sheet1!A:A is ordered in Ascending order as implied in your file)
you could optimise further by storing the recurring MATCH calcs in adjacent cells thereby lessening repetitive calcs.
The new values in D permit you to dispense with Arrays on Sheet2 such that:
applied across matrix
LinkBack URL
About LinkBacks
Rank items within groups
Register To Reply
re: Rank items within groups
Bookmarks