Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
4 views

Group Outlook tasks by due-date categories: "Today," "Tomorrow," "This Week," "Next Week," etc

I use Outlook's Task "peek" to organize my to-do list. When I let Outlook "Automatically group [tasks] according to arrangement," as in this picture— —it groups them by the ...
user avatar
0 votes
1 answer
25 views

Why do these sort in different order?

I expect 01 to appear first or last in both of these sorts but actually changing the length of the second record changes the sort order. Why? $ { echo 01; echo 0_12; } | sort 01 0_12 $ { echo 01; ...
user avatar
0 votes
1 answer
21 views

Sorting in excel with additional conditions

I have several rows of objects, each row with a specific date. Currently, the spreadsheet is ordering the rows by date increasing, using the ROW function. However, I need to introduce a new ordering ...
user avatar
  • 103
0 votes
1 answer
20 views

How to modify search order for ALL folders

what I mean by this is when you right-click in a folder, there is an option "More" By default, the only time-based sorting is Date Modified which takes very long, sometimes half a minute and ...
user avatar
0 votes
0 answers
29 views

Different sorting by name in Windows Explorer and other Apps

i noticed Windows Explorer and many apps like Winrar sort folders by name like this order: (test )test .test @test _test +test 0test 1test atest -atest but in some other apps like 7z and unlocker, i ...
user avatar
  • 23
1 vote
2 answers
21 views

Excel / LibreOffice Calc: find item in column with latest first occurrence?

In a Calc or Excel sheet I have a column with bunch of names. Each name can occur one or multiple times. Each name has a 'first occurrence' i.e. the first row in which it appears. I'm looking for an ...
user avatar
0 votes
0 answers
37 views

How to sort dates in ascending order in pivot table by month

I am trying to get a pivot table data set to sort dates in ascending order. The first step I took was to ensure the year was populated first. So, this is sorted by the year. However, the months are ...
user avatar
0 votes
1 answer
21 views

Sorting the list of subnets as Integers ascending

I have a list of subnets for eg. 180.151.96.0/22 180.151.240.0/21 119.82.112.0/22 203.122.29.0/24 203.122.48.0/22 119.82.92.0/24 180.151.108.0/23 119.82.124.0/24 119.82.89.0/24 180.151.17.0/24 119.82....
user avatar
  • 27
0 votes
2 answers
71 views

Windows Powershell: Get Items from directory -> md5 them -> sort list by filename -> out to file

Is there the way to complete mimic this unux command entirely by Windows Poweshell means, not with using the WSL: find ./<dir1>/ -type f -exec md5sum {} + | sort -k 2 > dir1_hashes.md I ...
user avatar
  • 1
0 votes
1 answer
30 views

Keeping two rows together when sorting

I would like to know how to link specific rows when sorting a table in excel. I have already made the table and in each row contains data for a specific person. Each person has two rows. My boss would ...
user avatar
1 vote
1 answer
25 views

Windows 10 - Sort option acts differently between two folders

I have a folder where, when I sort my files by date modified descending, all the subfolders are at the bottom. Then, in another folder, it is also sorted by date modified descending, yet the ...
user avatar
  • 123
0 votes
2 answers
48 views

Multi-level sorting in Excel

I have to run a report that has the data shown in the pictures. I need to sort it only by the R-A** (release) in column c then sort each release by assembly (column b). I can't sort it that way ...
user avatar
  • 1
0 votes
0 answers
27 views

Thunderbird email headers sort options

I just made a big upgrade from Thunderbird V2.0 (2007) to V91.9. No significant problem, kudos ! All my emails are sorted by message headers. In V2, headers starting by the "[" characters, ...
user avatar
0 votes
0 answers
81 views

How to sort output of top command based on nice value?

We can use Shift+p to sort on basic of cpu usage, Shift+r to sort on basis of pid & Shift+m on basis of memory utilisation. How to sort output of top command based on nice value?
user avatar
  • 374
0 votes
1 answer
140 views

Excel custom sort list works in Excel but not when file is transferred to SharePoint

I created a custom sort list of fiscal weeks that I use for my reports in Excel. For many reports I also use them as a Slicer. I have come across the issue where this custom sort list works perfectly ...
user avatar
  • 3
0 votes
0 answers
28 views

Custom excel sort/order?

So I've gone through a whole lot of sorting which isn't relevant to the question, but for elaboration I'm getting 10 results out of 14. These results will be in order from 1-14 as I get them through ...
user avatar
0 votes
1 answer
73 views

Which file system sort order is fastest in Windows 10 for large libraries?

Which file system sort order is fastest to load in Windows 10 for large libraries? My intuition always told me that sorting by date modified was the fastest one to load up.
user avatar
0 votes
1 answer
310 views

Pivot Table: Sort row by hidden field

I have a table in Excel 2016 (source: Microsoft Query/ODBC): Raw data: Construction Type Location Sort Reconstruction Main St - Red St to Blue St 1 ...
user avatar
  • 105
0 votes
1 answer
160 views

Linux `sort` doesn't work on numeric field

Here is a sample text file: Peter:123777:ETA Joan:16466:HLT John:11223:HR David:23456::::FSI George::::876543:ECS The task is to sort on second field, so I did the below: cat input.txt | tr -...
user avatar
1 vote
1 answer
40 views

Sort lines with "natural order" in Notepad++ like Windows Explorer?

Q: Is it possible to sort line with "natural order" (or what it calls, I'm not sure the correct name) like/similar to Windows Explorer? With or without plugin are fine Demo lines: text 1 ...
user avatar
  • 245
0 votes
1 answer
18 views

Automatically send certain filetypes to preset location

So the workflow I'm going for is saving the active webpage as .MHTML using a keystroke and make it go into a pre-set save location, so there's no interruption to browsing. I can easily get the .MHTML ...
user avatar
0 votes
2 answers
107 views

Excel Sort Command not working AT ALL as expected

I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways: the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
user avatar
  • 3
0 votes
2 answers
36 views

Sorting Function in sheets or excel

How do I do a repeated function in excel? I want the pattern to go: (Vertical) =a1 =b1 =c1 =a2 =b2 =c2 =a3 =b3 =c3 and so on. this will go on for until: =a400 =b400 =c400 Example in sheets
user avatar
  • 1
0 votes
0 answers
27 views

Display folders first in File Explorer search

Whenever I search for something (in this case "*") in File Explorer, folders appear mixed in with files: Is there a way to make it display all folders at the top like it does outside of ...
user avatar
0 votes
2 answers
89 views

Sorting Excel tables by localized alphabetical order

The English Excel (improperly) sorts the following strings as follows: SARKIN ŞENER SEZER ŞİMŞEK SÜRMELİ However, these are all Turkish strings where S and Ş are strictly different letters and Ş ...
user avatar
0 votes
1 answer
24 views

Applying View Options to Uploads

(First post here, so forgive me if I get anything wrong.) I'm an artist, so I have a lot of image folders, and a lot of images in those folders. I order them by date to avoid confusion, but whenever I ...
user avatar
  • 1
0 votes
0 answers
9 views

For a single windows folder AND all its subfolders: how to DEFAULT make it show all files with the same columns and in the same order

I have one folder where ALL downloads go. I want to open it via a desktop shortcut (win 10). In order to manage its content (delete/save/move/show etc.) I would like this folder (and only this one) to ...
user avatar
3 votes
3 answers
230 views

Sort chemical elements such as H, He, Li, Be by atomic number in Excel

I have a long table with columns for sample, analysis number, test method, etc. and, importantly, the chemical element that was analyzed. I would like to sort my table by sample first, then by ...
user avatar
  • 91
1 vote
2 answers
53 views

Save Recycle Bin view settings - Win 10

I want to always display deleted items sorted by Date Deleted (I am using detailed view). But whenever I open Recycle Bin it auto sorts by Name. When I sort it by Date Deleted and close the window, ...
user avatar
  • 265
1 vote
1 answer
17 views

Order file by colum where column is a date

I have a file in the following format 222 aaaaa 2021-12-24 333fd bbb 2021-09-1 444 cc 2022-01-16 555 zzz 2021-08-21 6666 www 2021-09-5 777 yyy 2021-03-14 888 xxx 2021-11-27 999 ffffff 2021-12-4 I am ...
user avatar
  • 13
0 votes
0 answers
22 views

Platform/version-independent sorting for gnu sort

I am trying to do an offline comparison of two lists generated on two different systems. They both have GNU coreutils so to aid the diff'ing, I sort both lists using sort before transferring them. I'...
user avatar
  • 213
0 votes
1 answer
227 views

how can sort my files in windows with custom filter?

I have roughly 80 files in that files all files have # number like (in file name's last portion has #1,#2,#3 like) I want to sort this with # order how can I do that. Please see image for more ...
user avatar
0 votes
0 answers
33 views

sort games in their subfolders

Recently I started using Batocera, and I am collecting games. I found on my drive tons of amiga games, which in most cases are in multiple files e.g. samurai1.adf samurai2.adf Battleships.adf exile - ...
user avatar
0 votes
1 answer
123 views

Sort LibreOffice Calc rows through all columns

I have a list of items with set of properties. Some of the properties are unique, some are the same. I want to sort the properties through all items to see which items have equal properties. Maybe it'...
user avatar
  • 1
0 votes
0 answers
61 views

Can I sort tree command according to time in ascending order?

tree Folder PATH listing Different Aspects of Function calling ├───Function with Arguments and with Return value ├───Function with Arguments and without Return value ├───Function without Arguments ...
user avatar
0 votes
2 answers
57 views

How do you sort Paired Data on Spreadsheet?

How do i sort my data to produce a sorted paired row + sorted position outcome? Desired Outcome: Row Position R1 A01 R2 A01 R1 A02 R2 A02 R1 A03 R2 A03 R3 A01 R4 A01 R3 A02 R4 A02 R3 A03 ...
user avatar
1 vote
1 answer
599 views

Windows Explorer filename sort order: why ×a before 'a?

Have a look at this filename sort order in Windows 10 Explorer: The character ' is mostly sorted before ×. But why is it the other way around for 'a vs. ×a?
user avatar
  • 922
0 votes
1 answer
39 views

How to sort values in a column depending on values on different columns?

I have a large table in which I want to sort as follows: Sort by column F If a value in column F is between 5000 and 6000, sort these rows by values in column B If a value in column F is between 6000 ...
user avatar
  • 1
0 votes
0 answers
83 views

Sort folders by custom value in Windows 10

I am currently cataloguing a large amount of family photos and I have gotten to a point where I would need to sort a lot of folders by a custom value. From what I gathered on the internet, Windows ...
user avatar
0 votes
1 answer
386 views

How to sort text by last column?

This command udisksctl status with Ubuntu 20.04.3 gives: MODEL REVISION SERIAL DEVICE -------------------------------------------------------------------------- ...
user avatar
0 votes
1 answer
138 views

How to do custom sort on multiple tables in excel?

I want to sort them by these options and doing it one by one for over forty tables is tiring: first, column "Point A": Largest to Smallest then, column "Point B": Largest to ...
user avatar
0 votes
1 answer
1k views

How do I sort folders by most recently added files in Windows?

I use the sort by Date Modified a lot, but this is absolutely useless for folders as it always defaults to when the folder itself was created, not when new files are added to said folder. I need a way ...
user avatar
  • 141
1 vote
1 answer
196 views

Power BI sort by column (Date) is producing different results

I have two graphs that are based off of the same dataset. I had an issue with sorting the graph chronologically, so I sorted by a YearMonNum column. The data looks something like this: id YearMonNum ...
user avatar
1 vote
1 answer
62 views

A command to sort stdin in ASCII order

Sometimes, GNU sort does not behave as expected. Here's an example: > bind | sort (This assumes you're using fish. In bash, the equivalent is bind -p.) All of the non-alpha characters in the ...
user avatar
0 votes
0 answers
539 views

"Date modified" of downloaded file is in the past - Windows 10

I like to order most of my folders by "date modified". But sometimes I will download a file with a timestamp in the past. This is very disruptive to me (I have to check chrome downloads to ...
user avatar
0 votes
1 answer
63 views

Excel is not sorting letter correctly

I have a weird problem with Excel: it is sorting the letter "CH" incorrectly (it places "CH" after "CZ"). As you can see in the attached image, it only happens with "...
user avatar
  • 3
0 votes
2 answers
858 views

How to sort files in Windows explorer in custom order?

I have a great deal of folders. Each contains more than 30 files. I’d like to sort these files in a custom order. How do I create a custom order and have it sorted out the files the way I want? I was ...
user avatar
0 votes
0 answers
44 views

Matching 2 Data Set rows with similar column headings

I have 2 data sets A-Q (left) and U-AA (right) I am trying to match the rows on the (right) U-AA with the rows on the (left) A-Q Once a record on the right matches the first like record to the left ...
user avatar
1 vote
2 answers
534 views

How to change the default sort order in Windows Open window?

How to change the default sort order in Windows Open window? Example: Paint => File => Open => /* need to order by date by default */.
user avatar
  • 180
0 votes
1 answer
30 views

Post-processing of multi-column CSV: remove dublicate lines + sort

I am dealing with the csv produced by the concatenation (via cat) of several CSVs: ID(Prot), ID(lig), ID(cluster), dG(rescored), dG(before), POP(before) 1000, lig40, 1, 0.805136, -5....
user avatar
  • 147

1
2 3 4 5
14