So, I know there is a easy way to sort unique values in alphabetic order using
SORT(UNIQUE(),1,TRUE)
but i'm trying to order based on how many times a item has appeared.
exemple, if had a column like
- Apple
- Apple
- Banana
- Banana
- Banana
- Lemon
I would like a return like:
- Banana
- Apple
- Lemon