Issue with Rank Formula

Upon download I found what appears to be a floating point issue in the data.

Entering

Formula:

=MATCH(E2:E26,E2:E26,0)

in an unused area returns this array.

Formula:

{1;1;1;1;1;6;1;8;1;1;11;1;1;1;1;1;1;1;1;1;1;1;1;24;1}

Those numbers (8 and 11) correspond with the $1,875.00 figures. They should both be 8s.

Shadowing column E with rounded values in column F (ROUND(E2,2)) and then changing the formula in column C to reference F produced expected results.

What is strange is that restoring references in C back to column E now produced the expected returns, and

Formula:

=MATCH(E2:E26,E2:E26,0)

then returned the array

Formula:

{1;1;1;1;1;6;1;8;1;1;8;1;1;1;1;1;1;1;1;1;1;1;1;24;1}

. In other words the floating point seemed to disappear from column E and your formula worked fine!!

Please try the MATCH function at your end to confirm the differences between the $1,875.00 figures. RANK and COUNTIF seem to be evaluating them differently.

As for the evident "self correction" I have no explanations.