• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sort Sr No column in ascending order.

vrunda

Member
I have a file in which i did some work using helper column but then my sr. no column was not setting in ascending order. I tried using sort but not getting result.
It is simple still i am unable to get the column in ascending order.
I am using Microsoft 365.

Thank you!!
 

Attachments

  • chngdFullStatementReport_2021-05-14 18_21_23.485.xlsx
    338.9 KB · Views: 2
vrunda
Sorting - eg like below
Screenshot 2021-05-28 at 12.40.30.png

If You would like to sort those SI.No. as number then
... You should trim ... clean some characters before Your each SI. No. number (which now act as text).
Screenshot 2021-05-28 at 12.41.29.png
 
ok i got it, Thank you . I trimmed & clean data & converted to no. then it could get sortd in ascending order.
 
Back
Top