List management in excel

Hi Samantha

In Excel, there is no direct function for you to sort the data by frequency of occurrence at once, you need to count the occurrence of the values first, and then apply sort function in Excel.

1. Select a blank cell beside original column, and enter this formula =COUNTIF($A$2:$A$16,A2) into it, and then drag this cell's AutoFill Handle down to the range as you need.

2. Keep selecting these formula cells, and click Data > Sort A to Z or Sort Z to A as you need

3. In the opening Sort Warning dialog box, please check the Expand the selection option, and click the Sort button.

4. And now the original column has been sorted by the frequency already. If necessary, please delete the added helper column

Hopefully this answers your question.

Regards,

Sarah
Excel Trainer