Sort data by word frequency

[2vbr]

I've tried googling this, but I don't think I'm using the right keywords.

I have the following data:

Red	1
Blue	1
Blue	2
Green	1
Green	2
Green	3
White	1
White	2
White	3
White	4

What I need to do is sort the data that results in the most frequently used word at the top.

Like so:

White	1
White	2
White	3
White	4
Green	1
Green	2
Green	3
Blue	1
Blue	2
Red	1

Basically, "White" has the highest count of usage (four times), so those rows that feature "White" are put at the top. There are three instances of "Green", so it's next down the list. Then there's two Blue... and finally Red is at the bottom, because it's only used once.

Can Excel do such a thing?

I'm thinking maybe a formula that places the total count next to each color, and then using Excel's inbuilt SORT ability accordingly. Unless there's some quicker/easier way?

Sorry if I'm explaining it badly. It actually took several tries to type this up in a way that makes sense.

[CK76]

Yes, easiest way is to add helper column.
Using =COUNTIF($A$2:$A$11,A2)

Then sort by helper, desc and Count, asc.

[AliGW]

If you add a ranking column, you can use this when you set up the sort on three columns.

[2vbr]

Thanks for the help!

Both methods worked, so I'll play around with both some more too see which comes more naturally.

Completely unrelated question, but one I've been wondering for years: When locking cells with the $ modifier, is it possible to do it with the mouse?

When selecting large columns, I usually click a cell and then use SHIFT+CTRL+DOWN ARROW to select the entire column of data. But that would only give me A1:A200. If I wanted $A$1:$A$200, I need to manually type it in. Are there any alternatives using the mouse or combo keys?

EDIT: Never mind! I finally found the magic google keywords!

ANSWER: Press F4 after selecting the range.

[CK76]

You are welcome and thanks for the rep