Crash1 wrote...
Why would I pay for it? . . .

Because in the Excel equivalent to your love life, your only
alternative is your right hand, and you're left-handed.

What's so difficult about understanding this? The top row is the
number. The row below it is the rank for the number on top. And this
continues down the row. The next column is the next set of numbers
with the rank below each row.

Rows are horizontal. They go left to right, not up and down. Presumably
you mean it goes down the COLUMN, and it seems different columns
represent independent data to rank separately. If so, an awkward
layout, as you've discovered.

You'd be FAR BETTER OFF storing the data in simple tables with no
interleaved ranks, just data in each row with one data point following
the next in the next row. Then you'd need to pull them into the
interleaved display. If the data were in B2:B9 and the B2 value would
be displayed in X99, the X99 formula would be

=INDEX(B$2:B$9,(ROWS(X$99:X100)/2)

Copy X99 and paste into X101, X103, . . ., X113. The rankings would
begin in X100 with

=RANK(X99,B$2:B$9)

Copy X100 and paste into X102, X104, . . ., X114.

If you just have to enter the data in nonadjacent cells with
intervening ranks between data values, it can be done. It requires
using FREQUENCY, INDEX and SUMPRODUCT functions and multiple area
ranges. However, it's such a bad idea someone else would have to
provide the details. And if you don't think I know how to do this, I'll
post it somewhere else and provide a link to it after the weekend.