•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
Related Articles
- Sort data with multiple header rows?Hi everyone! I am trying to see if it's possible for me to sort data in a sheet that has multiple header rows. The sheet is tracking orders in different statuses, I have it separated for the New orders in the top section, then row 11 starts those that have had initial attention, but not fully in progress, on row 25, I have a header row for those who are fully in progress, etc The purpose of the separation is because there is different information I have to keep track of for each of these statuses, but I don't want to have them in different sheets because it's so helpful to be able to refer to them all in one spot. I'm hoping to be able to alphabetically sort customer names and also sort by dates, but the date columns are not uniform throughout the different statuses. If anyone knows if this is possible, help would be so appreciated!! Nevermind everyone! I figured it out by highlighting each section and inserting a table with headers! Leaving this here and marking as solved in case it helps someone! submitted by /u/tashykat [link] [comments]
- Sorting columns on a LARGE Excel sheet with 5 pagesHello, I’m looking for some help learning how to sort data columns on this excel sheet. The sheet is used to track inventory by the person who’s using it. In the top right of the page you’ll see a row of Zones with corresponding numbers. Below the zone, the name of the person consuming the inventory. Then a little below that, random numbers I’ve entered to simulate inventory demand. I need a way to select the zones and sort them from smallest to largest number while keeping the column information the same. Also this page is connect to 4 other pages. The other pages are coded to look at this page and carry the data over. Is it possible to code this Excel sheet so that ALL pages sort by zone? submitted by /u/Soft_Dragonfruit4097 [link] [comments]
- Is there a way to keep rows together while using the SORT Formula?I am having excel use the sort formula so it’ll automatically sort anytime a new requirement is added onto a table on another sheet. However, anytime a new requirement is added, the data in the rows (user input) doesn’t get sorted. This causes a mismatch between the user input in the row and the requirement. I looked into just using the sort function instead. However, as the column it would need to be sorted by can include letters, excel is putting those at the bottom of the list. submitted by /u/Aromatic_Presence_49 [link] [comments]
- Is there a way to change the order in which symbols are alphabetically?I have a spreadsheet that has cells that consist of words both from English and Latvian. The Latvian alphabet is the same as English, but there are different letters, that are usually just versions of other letters (so for example Ā, Ē, Ģ, Ķ ect.). Whenever i try sorting the cells alphabetically excel just ignores the symbols and treats them as if they're a different letter (so for example it treats Ļ as if it was just L). Is there any way to solve this? submitted by /u/Beginning_Dingo3812 [link] [comments]