Sort and group and then for each group create a descending order sort

Question

Sort and group and then for each group create a descending order sort

Jose Cerda 0

Good Afternoon,

Do you happen to have VBA code to make a sort in excel, where I first sort by a field which groups together a category, then for each category group I can sort in descending order a quantity column.

0 comments

1 answer

Your answer

Answer 1

Susmitha T (INFOSYS LIMITED) 2,690 Microsoft External Staff

Thank you for reaching out!

Yes, this can be achieved in Excel using a multi-level sort in VBA.

The approach is to apply two sort levels:

1.First, sort by the category column in ascending order. This groups all similar categories together.

2.Then, apply a second sort on the quantity column in descending order. Excel will automatically sort the quantity values within each category group.

This method ensures that your data is grouped correctly and that each group is internally sorted from highest to lowest quantity.

Let me know if you need any further help with this. I will be happy to assist.
If you find this helpful, Kindly mark the provided solution as "Accept Answer", so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

Susmitha T (INFOSYS LIMITED) 2,690 Reputation points Microsoft External Staff

2026-02-16T08:30:30.98+00:00

Hi, hope you’re doing well. We’re following up on this thread to check if the issue is still occurring or has been resolved. If it has been resolved, kindly mark the answer as accepted. We will proceed with thread closure by 17th February.
Looking forward to your response.
Susmitha T (INFOSYS LIMITED) 2,690 Reputation points Microsoft External Staff

2026-02-18T05:34:43.4533333+00:00

As we haven’t received any further updates or follow-up on this thread, we will be proceeding with thread closure. If you need additional assistance or have new information to share, please feel free to post a new thread. We’ll be happy to support you further as needed.

Share via

Sort and group and then for each group create a descending order sort

1 answer

Your answer