Hi there, and thank you in advance! I really, really appreciate this forum! ![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have data which was not set up in an easy manner to pull information from, so I would love to see if this is possible to do:
I'd like to use a formula beneath each column, which would display values in a column (and the counts of each) from highest-in-number to lowest-in-number, in that column. For example,
before:
Column A
Bon boy
Bon boy
Bon boy
Yo girl
Yo girl
The cat
after:
Column A
Bon boy
Bon boy
Bon boy
Yo girl
Yo girl
The cat
Bon boy 3
Yo girl 2
The cat 1
Thank you... SO much, experts!!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have data which was not set up in an easy manner to pull information from, so I would love to see if this is possible to do:
I'd like to use a formula beneath each column, which would display values in a column (and the counts of each) from highest-in-number to lowest-in-number, in that column. For example,
before:
Column A
Bon boy
Bon boy
Bon boy
Yo girl
Yo girl
The cat
after:
Column A
Bon boy
Bon boy
Bon boy
Yo girl
Yo girl
The cat
Bon boy 3
Yo girl 2
The cat 1
Thank you... SO much, experts!!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Last edited: