Share via

Excel - sort multiple rows as groups

mark goldin 691 Reputation points
2023-02-10T12:59:18.24+00:00

I have the following data:

User's image

I want sort it by Asset Ranking so rows 6,7, and 8 will be on the top. Is it possible?

Thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,979 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nobuko Ichimaru 316 Reputation points
    2023-02-11T14:50:45.59+00:00

    exampleSort.pdf
    I wish I could help

    Please refer to the pdf.

    for example,

    unmerge the cells,

    Add columns for sorting.

    put the formula in column E

    Put the branch number in column F

    by sorting

    E column priority descending order,

    Then F column ascending order,

    With the above, sorting is possible.

    After that, if necessary,

    joins, drop EF columns, etc.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.