1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How Do I Remove N/A Error from by formula

    From MyVeryOwnSelf@21:1/5 to All on Tue Jul 16 10:06:21 2019
    =RANK(B2,B$2:B$15,0)

    My guess is that B2 doesn't contain an Excel number value, but instead contains an Excel text value that looks like a number.

    One way to fix this is by wrapping it this way in B2:
    =--(Whatever_is_in_B2_now)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)