Welcome Guest.

3Answers

Excel table: -1-1 to -1-1700 how to ascend

Asked by: Diane 233 views Software December 21, 2018

In the EXCEL form, my data has been entered, from -1-1 to -1-1700, how to sort up

3 Answers

  1. +4Votes  

    Upload sorting is to select the column (row) and click:

    You are not the ascending order that Excel says, it is the custom sequence that Excel said.

    Do you mean this:

    -1-1

    -1-2

    -1-3

    ……

    -1-1700

    If yes, solve it by adding auxiliary columns (rows).

    Marie- December 21, 2018 |

  2. +8Votes  

    The cell format is set to

    "-1-"0

    to be in ascending order, Or sorted in descending order.

     

    Gregory Adams- December 21, 2018 |

  3. +1Votes  

    You can’t directly sort by 1 to 1700 directly!

         Because your format is definitely text format, text sorting and number sorting are not the same

     

    To reach Sort by last number:

           You can only add one copy column, extract the last number to this auxiliary column, and sort by auxiliary column

    Figure effect:

    B1 input formula:

    =–RIGHT(A1,LEN(A1)-FIND("-1-",A1)-2)

    This can be sorted by column B auxiliary columns, as shown in descending order

    Johnson- December 21, 2018 |