▲ 15 r/excel
Lets say we have a column in which cells have values like you can see below:
How can I use a sort function in the way, that in this example it would sort it from the least to most repeating values?
My goal is to get it to show me the least repeating values on top, so in this case it should be as follows: Lemon, Lemon, Apple, Apple, Apple, Pear, Pear, Pear.
I have a feeling that there is a simple solution, but I'm failing to figure out how to google it.
P.S. In my real life case I have over 15 000 rows, in which that specific column represents the room number (the whole sheet is for inventory items), so I need excel to show me the rooms with least items on top.
u/Cheatmeal95 — 10 days ago