Hello!

I use this forum a ton, but rarely post. I'm trying to figure this out. I am using the rank + countif formula to do a tie breaker and then vlookup to rank. But for some reason I can't figure out, one of my data sets it has an error. I have narrowed it down to this: This is the rank without a countif

Rank Number
9 8.55
8 9.40
7 10.15
6 10.70
5 10.80
3 10.80
3 10.80
2 11.60
1 13.35

Notice the 10.8 is ranked 5 then 3, 3. If I set up a grid referencing the three 10.8's and using =Cell=Cell, I get this: (L6, L7, L8 are the cell references for the 10.8's)

L6 L7 L8
L6 TRUE TRUE TRUE
L7 TRUE TRUE TRUE
L8 TRUE TRUE TRUE

Any idea why rank would rank them different despite them being the same? The formula for rank I drug down is this:

=RANK(L6,$L$2:$L$10,0)
=RANK(L7,$L$2:$L$10,0)
=RANK(L8,$L$2:$L$10,0)