How to sort {9.2.7, 7.0.10, 10.0.10} kind of values in excel

Anonymous
2023-11-03T10:25:36+00:00

How to sort {9.2.7, 7.0.10, 10.0.10} kind of values in excel

Microsoft 365 and Office | Excel | For business | 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

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-05T04:09:49+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    Sort Dewey Decimal System.

    Example as applied to a BOM to aggregate costs in a PivotTable.

    https://www.mediafire.com/file_premium/7u53rabtzpnp80p/03_17_22.xlsx/file

    https://www.mediafire.com/file_premium/lccrh23cmlunj0t/03_17_22.pdf/file

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-11-05T01:47:42+00:00

    if with sql:

    select * from basic_order_by_natural order by colIndex[0:0] COLLATE NATURAL_CMP;

    https://b23.tv/ojqtPWF

    Image

    Was this answer helpful?

    0 comments