I have a spreadsheet and between B2:B101, I have a number on each one. I am trying to get a rank on E2:E101, regarding to their given number. I tried using
=rank, and it successfully shows the result in a tooltip, but when I press enter, it doesn't write the value.
The cell is blank.
View > All Formulas is unchecked, also tried with checked. No luck. What am I doing wrong?