Display Ranking from a list

Need help
1

Hello
I would like to sort by number of occurrences from a list.

For example,
I make a list of text like this
“ccc”
“bbb”
“ccc”
“aaa”
“ccc”
“bbb”

Then I wanna show a repeating list like this,
“ccc” 3
"bbb"2
"aaa"1

In additional ,I refer to this.
when I’m using just a list , I can’t find “group by”.

I’m not sure how to make it.
Can anyone help me?
Thank you in advance.

2

This topic was automatically closed after 70 days. New replies are no longer allowed.