How do I weigh ranking based on value size

Hi All   Im trying to rank some numbers in excel and it works fine so far. However it is not depicting differences between values as i would like: Ranked table is on top with the following formula...