Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

list management excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » List management in excel

List management in excel

ResolvedVersion 2010

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

Fri 16 Feb 2018: Automatically marked as resolved.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.