Easily combine rows based on duplicate in one column, and then sort combined rows by the duplicates in Excel

Normally we can apply the Rank function and return the rank number easily in Excel.

Select a blank cell, enter the formula =RANK("84",B2:B23) into it, and press the Enter key. See screen shot:

Note: in the formula of =RANK("84",B2:B23), 84 is your score, and B2:B23 is the score range you want to rank your score in, and you can change them based on your needs.

If you have Kutools for Excel installed, you can easily batch rank duplicate values in Excel. Please do as follows:

1. Select the range you will rank duplicates, and click Kutools > Content > Advanced Combine Rows. See screenshot below:

2. In the opening Advanced Combine Rows dialog box, Pease (see screenshot above):

(1) Select the column with duplicates (in our case select the Score column) and click the Primary Key;

(2) Select the column you will combine ( in our case select the Name column) and click the Combine > Comma.

And now rows in the selected range are combined based on the sc roes, sorted/ranked by the scores. See screenshot below:

Easily sort values by occurrences of duplicates in Excel