Repeat Numbers

Question

How to sort numbers that are repeated according to column A in ABCD order according to column B.

Answer 1

Hi,

For Column B, you can enter the A in B1 first then enter the formula in B2:

=IF(A2=A1,CHAR(CODE(B1)+1),CHAR(65))

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Select the range (both columns).

Open the Data tab.

Select the large sort icon.

Specify the number column as the first "sort by".

Specify the letter column as the next "sort by".

Click OK

Answer 3

Hi,

Select the A and B Columns.

And click on Sort & Filter, and click on Sort A to Z for ascending order and Sort Z to A for descending order.

Best Regards.