Explanation

Ordinal numbers represent position or rank in a sequential order.

They are normally written using a number + letter suffix: 1st, 2nd, 3rd, etc.

All other numbers use the 10 suffix values inside CHOOSE.

Excel formula: Rank function example

The ABS function is used to handle negative numbers as well as positive numbers.

The values provided to CHOOSE can include references.

ABS Function

The Excel ABS function returns the absolute value of a number.

Excel formula: Rank race results

ABS converts negative numbers to positive numbers, and positive numbers are unaffected.

MOD Function

The Excel MOD function returns the remainder of two numbers after division.

For example, MOD(10,3) = 1.

Excel CHOOSE function

The result of MOD carries the same sign as the divisor.

Excel ABS function

Excel MOD function