Share via

SORT : That function isn't valid

Anonymous
2022-02-07T18:37:11+00:00

Hello,

I just try to use the function SORT, to sort one column, but I get and error message : That function isn't valid.

or I try =SORT(A1:A10) but same error.

I surely do something wrong, any idea ?

Thank you

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2022-02-07T18:46:30+00:00

    Try:-

    =SORT(A1:A10)

    1 person found this answer helpful.
    0 comments
  2. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2022-02-07T18:51:44+00:00

    . . . or to sort in descending order:-

    =SORT(A1:A10,1,-1)

    0 comments
  3. Anonymous
    2022-02-07T19:14:17+00:00

    Same error : That function isn't valid.

    1 person found this answer helpful.
    0 comments
  4. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2022-02-07T19:39:36+00:00

    Same error : That function isn't valid.

    Both items tested in 16.0.14827.20158 and both working correctly here.

    0 comments
  5. Anonymous
    2022-02-07T19:55:13+00:00

    I have no doubt the formula is working, but something should be wrong with my Excel.

    I even reinstall it and got the same error.

    1 person found this answer helpful.
    0 comments