•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it possible to create a custom sort order?
Our take
Sorting data in a custom order can enhance clarity and organization, especially when standard numerical or alphabetical sorting doesn’t meet your needs. While traditional methods may seem limiting, there are approaches you can explore to achieve a more tailored arrangement without compromising the legibility of your spreadsheet. Although using numeric prefixes is one option, it can appear clunky.
This is more of a curiosity than a problem I HAVE to solve, so it's not essential if I don't get a solution!
I have some data that I wish to sort, but rather than 1-10 or A-Z, I need it to do a specific order. Is this possible?
- Ai
- Up
- Ye
- Un
- No
EDIT: I know that I could just put the number in front of the words, basically like I have done here and than sort numerically. It just looks a bit clunky, and also I have very narrow column for this info as I need the whole sheet to fit on the screen and be legible.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#custom sort order#data sorting#specific order#A-Z sorting#numerical sorting