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?
Formula result doesn't show, leaves blank cell
google spreadsheets