Samantha has attended:
Excel Introduction course
List management in excel
If i have a report that u want to organise into number of time a company appears, is that possible?
RE: 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