Questions tagged [sorting]

Sorting is any process of arranging items according to a certain sequence or into different sets.

183 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
3answers
29k views

How to order a numbered list in descending order?

When using a numbered list in Word, how can I have it order in descending order (ie. 10., 9., 8., 7., ...) ?
3
votes
2answers
195 views

MS Excel 365 Not Sorting

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does ...
3
votes
2answers
411 views

How do I properly organize Windows Explorer lexicographically?

I'm just trying to organize my PlayStation zip files, but it seems to be having trouble organizing the numbers. "007 - The World Is Not Enough" should be at the top. That is how numbers work. What is ...
3
votes
2answers
1k views

How do I reorder sheets in specific order, then alphabetically?

I need to reorder my sheets in a specific order, then if there are any left, do it alphabetically. I have the macro below to reorder them alphabetically. If i have sheets ""METALS", "SVOC", "GENCHEM"...
3
votes
1answer
139 views

Varying Format Part Number Sort Issue

(Current Sort Sample:) 2-1203-4 2-1206-3 2CM- 3-1610-1 3-999 … AR3021-A-7802 AR3021-A-7802-1 B43570- B43570-3 I am working on an 8000+ record parts list. The challenge I am running into is that ...
3
votes
1answer
194 views

Is it possible to change the 'Type' of a directory in Windows

Directories in Windows are always tagged as "File folder" in the explorer: Is it possible to edit this field? To introduce a new kind of folder? I would like to do that in order to enable another ...
3
votes
0answers
218 views

Sort mails by 3 criteria on Thunderbird

I would like to sort my mails by 3 criteria, on this order : Date (new mails up the list) Read state (unread messages upper) "Starred" (starred messages at the uppest) But it seems that it is ...
3
votes
0answers
3k views

Save folder sort setting in Windows 7

I have an Image folder and sort my images by date. Every time I open a folder, Windows sorts all files by name and then a green bar fills the address bar. After that all images are sorted ...
3
votes
1answer
704 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, sometimes ...
2
votes
0answers
345 views

Modify the locale collation order in Windows 10

The collation order is what determines the order strings are sorted in for a given locale. It comes in two layers, the root order which determines that all variants of A is treated as a (Á À Ä Ã ...), ...
2
votes
1answer
404 views

Sort with case-sensitivity in macOS in the Terminal

I am trying to use the answer in GNU Sort by case-sensitive to sort a file in my Mac OS. My file.txt looks like this: "Best" "A" "BEST" In the second answer to the mentioned question, it says that ...
2
votes
1answer
572 views

Excel: referencing a table cell

In Excel I have a table, with the first column acting as a unique identifier (I make sure there aren't duplicates). I want to be able to reference a cell of this table's first column so that: - if I ...
2
votes
0answers
1k views

File Sorting in HEX on Windows?

How can I sort file names by HEX instead of whatever Windows 10 does to sort files? I have a huge list of sound effect files in a folder and because of how Windows has no option (from what I can see) ...
2
votes
0answers
1k views

Windows 10 sort folders with files

In Windows 10 when I filter a folder by "Date modified" the folders and files are ordered independently. I have grouping set to none. An example: If I have two files and a folder with the folder ...
2
votes
1answer
166 views

How do I duplicate column data and preserve row relationships across worksheets?

I have a large amount of data on one worksheet, and would like to split it between two separate linked worksheets. Assume I have these columns on my first worksheet (Worksheet A): Apple | Red ...
2
votes
0answers
4k views

How to sort contacts alphabetically in Skype for Business

I am using Skype for Business. I observed that the list of contacts is sorted alphabetically, but by first name for some people and by family name for others, e.g.: Albert Einstein Doe, John ...
2
votes
0answers
326 views

Bash sort and join problems

I have to join two files. Firstly, I use commant sort and made two new sorted files. Next I use join, but it doesn't work. My script: sort -t ',' -r -k 4,4 file1.csv > sortf1.csv sort -t ',' -r -...
2
votes
0answers
406 views

How to move starred and unread messages to top without destroying the order by date (descending)?

I'm trying to order my messages in my thunderbird inboxes and have multiple issues. I want to oder my mails like the following: Importent (starred) messages should always stay on top. Unread ...
2
votes
1answer
78 views

Reordering file lines like other file (Unix)

Is there a tool (or option for sort) which will re-order lines of a file so that they are ordered like a key in another file? For example, I have a data file: T01F01475558 30 T01F022B3A17 31 ...
2
votes
1answer
239 views

Tagging or defining automatically in an Excel or Libre office spreadsheet?

I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget program....
2
votes
1answer
3k views

batch-rename filenames with numbers to sort alphabetically

I want to batch-rename files containing numbers, padding the numbers with zeroes. The goal is to sort numbered sets of files alphabetically in the correct order in any application. In a set of files ...
2
votes
0answers
756 views

Path Finder: How to sort files by date, but folders by name?

This is possible in Total Commander. How can I make such separate sorting in Path Finder as well? I like to sort files by date, but I don't see any point in sorting folders this way - they just jump ...
2
votes
4answers
891 views

Is there a way to do Drag and Drap sorting of emails in Outlook?

I'd like to be able to manually sort emails in a particular Outlook folder instead of having it auto-sort by some particular column. Basically, for emails that I need to do some sort of follow up, I ...
1
vote
1answer
26 views

Counting and sorting a cell in excel

I need help to sort out a list of agencies. I have now gotten the frequency for each agency but I need them to match. Then, I need to sort out this list from Largest to Smallest frequency. That means ...
1
vote
1answer
34 views

Win 10 Libraries option “Arrange by” won't display pictures from previous years?

It's simple as the title. On Windows 10, when I go to "Libraries", then to "Pictures" I can see folders that I included in a Library. When I open the folder, all the pictures are ...
1
vote
1answer
84 views

How can I sort an email alphabetically in bash

I am trying to sort a list of emails in alphabetical order in bash to no avail The emails involve numbers and periods: kori.flap10@flap.com flap39@flap.com flap.flap@flap.com flap@flap.com k.slick20@...
1
vote
1answer
310 views

Sorting in outlook by flag - change sort order

I would like to make outlook to sort my messages in a certain search folder by the following order: First - sort by flag status in the following order: followup flag first, unflagged second, completed ...
1
vote
0answers
26 views

Sorting polytonic Greek list by initial letter case in Excel

I'd like to extract all the capitalised words from a list of polytonic Greek words. For example, out of... Ἀθηναῖοι αἱ ἄλλα I'd like just Ἀθηναῖοι as it begins with a capital. I've done this before ...
1
vote
2answers
68 views

How to sort two columns of numbers to minimize the differences between them?

I'm sorting two columns of numbers. One is a series of spools of wire, and another is a series of needed lengths. I want to optimize the selection of spools for the needed lengths, while flagging ...
1
vote
0answers
30 views

Sort by type while retaining numerical ordering in Explorer

Windows XP and later OSes have a NoStrCmpLogical API that allows sorting numerically rather than lexicographical. All references say this is not supported until after Windows 2000, yet, somehow that ...
1
vote
1answer
43 views

sorting various headings in rows

A friend of mine has given me his excel collection of recipies. He has around 500 recipies which has split into each letter on a different sheet. He wants me to then sort the recpies for each letter ...
1
vote
1answer
307 views

Sorting issue with Windows 10 File Explorer

I'm using 0-9 and A-Z to name files. For example, ex_1A, ex_23, etc. I pad to 2 digits, so 9 would be ex_09. In Windows 10 File Explorer, it sorts things completely wrong: ex_00 ex_0A ... ex_0Z ...
1
vote
0answers
153 views

Linux merge sort is *slower* that full sort?

I'm using Linux merge sort (sort -m) to sort a large group of presorted files. I was assuming that merge sort would be considerably faster than a full sort on the unsorted data but that's not what I'm ...
1
vote
0answers
47 views

Power Query and Excel don't agree on sorting?

Take a table that has the following records Field A | a If I sort it with Excel, I get the pipe character before the "a" Field A | a Now, if I sort it with Power Query, I get Field A a | That ...
1
vote
0answers
59 views

Sort excel and be able to revert to previous order after edits

I manage a spreedsheet that has about 30 columns and around 140 rows. It is a manning roster, and there is a set order that it needs to be in by office. Sometimes I need to sort by date or some other ...
1
vote
2answers
45 views

Unsorted dates after sorting in Excel

Sometimes, even though I sort the column dates from early to late, some dates remain unsorted.  I fix it by rewriting the dates manually, but this is inefficient.
1
vote
3answers
346 views

Spreadsheet: create column based on one column sorted by values of another

I want to create a new column of data from one column sorted by another column. It's easiest to explain with an example. This is not actually what I'm doing, but I think it explains it well. Let's ...
1
vote
0answers
722 views

How to get files ordered by name with `dir`?

This used to be really easy in the old OS's. dir /o:n >> list.txt for %a in (`list.txt`) do copy %a ..\ordered And voila, there was the list of files in the other folder, created in the sorted ...
1
vote
0answers
200 views

Excel macro to sort two columns side by side

This is a task I frequently have to do: I have two tables whose contents are similar but not the same. Let's say: Table 1 with columns A1, B1, C1, ... Table 2 with columns A2, B2, C2, ... Let's say ...
1
vote
1answer
153 views

Sort App Shortcuts in OS X System Preferences Keyboard Shortcuts

I have a long list of custom shortcuts I've created in System Preferences > Keyboard > Shortcuts > App Shortcuts for menu items in Pro Tools. Despite having edited the application's plist file (com....
1
vote
0answers
271 views

How do I automate sorting/aligning multiple data sets in Excel by NEARLY common values?

I would like to align multiple (6+) data sets (each 3 columns x 1000 rows) by a common variable('mass' column) where each set will have a couple of exactly matching common values, numerous nearly-...
1
vote
2answers
742 views

In Excel, how do I sort column data while keeping sorted to another?

Here is an example of the data I'm looking at: A A01 A A08 A A04 A A07 B B03 B B05 B B02 B B06 I understand I can simply select the rows for Data Set A by Column B and then sort alphabetically, but ...
1
vote
0answers
38 views

Can I change a file/folder's index number within its parent?

I just learned that files and folders have index numbers that are given to them when they are created inside of their parent folder or drive. These numbers seem to be based on the order in which the ...
1
vote
0answers
291 views

Any way to do Linux-style sort --merge in Windows PowerShell?

In PowerShell, if I have two files that are already sorted and want to merge them into one big sorted file, it seems wasteful and inefficient to do gc file1, file2 | sort-object > newfile, ...
1
vote
1answer
794 views

Sort list into tuples in Excel

Is there any way to sort a list into tuples as defined by a priority list in Excel? For example I would do a draw to get priorities: Banana -> 1 Apple -> 2 Tomato -> 3 And I have sheet of ...
1
vote
1answer
2k views

Sorting by different currency symbols in Excel 2010

The Accounting Department enters receipts of money in different currencies ($, shekels, & Australian pounds). Is it possible to sort a column containing mixed currencies by currency type if the ...
1
vote
1answer
769 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
1
vote
1answer
685 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
1
vote
0answers
839 views

Music Library Sorting Issue

I'm using WMP for for managing my music library. Lately I noticed something. I was reorganizing my library and came across a strange -I mean annoying- behavior of WMP. The way WMP sorts Artists. ...
1
vote
2answers
1k views

How to manually sort files in win explorer?

I want to manually sort (drag and drop) my files in a certain (not in all) folders (win xp sp3). Is there any fix to do it ? If no - is there another file explorer with the feature.