Hi There,

I have a query.

I want to sort rows in Excel from A-Z top to bottom, but where it comes to entries with the same name it keeps those rows in the same order they are in in relation to each other. So rows with the same name in the first column would not be moved above or below each other.

Does this make sense and is this possible?

As far as I'm aware it already does that. If you have a table sorted on one column and then sort on a different one, the order of items with the same value for the second sort key will remain in the same order.

It's called a "stable" sort.

Gordon

As far as I'm aware it already does that. If you have a table sorted on one column and then sort on a different one, the order of items with the same value for the second sort key will remain in the same order.

It's called a "stable" sort.

Gordon

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, March 23, 2015 9:04 AM
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, March 30, 2015 7:04 AM

Thanks. The spreadsheet I was looking at was particularly long so hence I didn't notice that it was double mixed.

Best