•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sort the rows from least repeating value to most repeating value.
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#google sheets
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Lemon, Apple, Pear
#least repeating values
#over 15 000
#simple solution
#rows
#show
#example
#function
#cells
#column