I have a column in an excel file like this-

I want to sort this column like this-

How can I achieve this by using excel sort by creating a custom list?

CodePudding user response：

Create a helper column that counts the number of Replication above it. Put this in the helper column:

=COUNTIFS($A$2:A2,A2)

Then sort ascending both columns looking first at the sort column:

Then you can hide the sort column if you desire or delete it if the sort is just a one off.