List Values By Frequency

[Pestomania]

Hello!

Let's say I have 1 column. I want to list Values from most frequented to least frequent.

Column B
1
5
6
9
11
12
9
9
5
5
5
1

I want column C to return the values in the order of frequency.

5
9
1
6
11
12

Is there a way to do this? I can't sort the column due to other columns.

 

[steve the fish]

Here you go. In C1:

=IFERROR(INDEX($B$1:$B$12,MODE(MATCH($B$1:$B$12,$B$1:$B$12,0)+{0,0})),"")

In C2:

=IFERROR(INDEX(B$1:B$12,MODE(IF(COUNTIF(C$1:C1,B$1:B$12)=0,MATCH(B$1:B$12,B$1:B$12,0)+{0,0}))),"")

Drag down until you get no more results. Both require CTRL-SHIFT-ENTER to enter into the cell.